作者: rtmoof
2008-04-22 00:01:49
才开始学Oracle，遇到点问题，记录一下。
ORA-12560: TNS: 协议适配器错误
ORA-12514: TNS: 协议适配器错误
首先保证服务正常起来。
在次去看$Oracle_home/network/admin/listener.ora
如果只是在sqlplus 中出现这样的问题。
win
set ORACLE_ID=DBname
管理工具编辑listenr.org
引用:# listener.ora Network Configuration File: e:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = e:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
#add db name desc
(SID_DESC =
(GLOBAL_DBNAME = ebay)
(ORACLE_HOME = e:\oracle\product\10.2.0\db_1)
(SID_NAME = ebay)
)
#end
)
#不同IP端口监听
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.8)(PORT = 1521))
)
)
#end
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = 1521))
)
)