ORA-12560 : TNS:协议适配器错误

dong_jh

oracle服务已经启动，也能通过本地服务名方式连接（sqlplus user/passwd◎xxx），但是sqlplus " / as sysdba"或SRVMGRL里连接internal用户都报上述错误，经测试，通过监听器用本地服务名方式连接可以，但直接连接数据库不行，为何？

荣磊

windows 下
set   ORACLE_SID＝xxx  (xxx就是你的数据库SID)
linux 下
export ORACLE_SID=xxx

荣磊

C:\>;sqlplus system/solaris@joypark

SQL*Plus: Release 9.2.0.1.0 - Production on 星期五 10月 15 16:20:16 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


连接到:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL>;
SQL>;quit
C:\>;sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.1.0 - Production on 星期五 10月 15 16:21:15 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


连接到:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL>; quit
C:\>;set oracle_sid=fkdfk

C:\>;sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.1.0 - Production on 星期五 10月 15 16:21:51 2004

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

ERROR:
ORA-12560: TNS: 协议适配器错误


请输入用户名:

荣磊

如果你的是windows版本可以修改注册表把
set oracle_sid=xxx 加上注册表里
linux　加到用户主目录下的  .bash_profile


Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0]
"ID"="0"
"ORACLE_GROUP_NAME"="Oracle - OraHome92"
"ORACLE_HOME_NAME"="OraHome92"
"ORACLE_HOME"="D:\\oracle\\ora92"
"NLS_LANG"="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
"ORACLE_BUNDLE_NAME"="Enterprise"
"ORACLE_SID"="joypark"
"ORAMTS_CP_TRACE_LEVEL"="0"
"ORAMTS_CP_TRACE_DIR"="D:\\oracle\\ora92\\oramts\\Trace"
"ORAMTS_CONN_POOL_TIMEOUT"="120"
"ORAMTS_SESS_TXNTIMETOLIVE"="120"
"ORAMTS_NET_CACHE_MAXFREE"="5"
"ORAMTS_NET_CACHE_TIMEOUT"="120000"
"ORAMTS_OSCREDS_MATCH_LEVEL"="OS_AUTH_LOGIN"
"ORACLE_HOME_KEY"="Software\\ORACLE\\HOME0"
"ORACLE_BASE"="D:\\oracle"
"SQLPATH"="D:\\oracle\\ora92\\dbs"
"MSHELP_TOOLS"="D:\\oracle\\ora92\\MSHELP"
"RDBMS_CONTROL"="D:\\oracle\\ora92\\DATABASE"
"RDBMS_ARCHIVE"="D:\\oracle\\ora92\\DATABASE\\ARCHIVE"
"ORA_JOYPARK_AUTOSTART"=hex(2):54,00,52,00,55,00,45,00,00,00
"ORA_JOYPARK_SHUTDOWN"=hex(2):54,00,52,00,55,00,45,00,00,00
"ORA_JOYPARK_SHUTDOWNTYPE"=hex(2):69,00,00,00
"ORA_JOYPARK_SHUTDOWN_TIMEOUT"=hex(2):33,00,30,00,00,00

[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0\HTTP_Server]
"ath"="D:\\oracle\\ora92\\bin;D:\\oracle\\ora92\\Apache\\Perl\\5.00503\\bin\\mswin32-x86;D:\\oracle\\ora92\\Apache\\fastcgi"

dong_jh

解决了，设置注册表或环境变量都可以。