关于Oracle的TNS

作者: rtmoof  出自:

才开始学Oracle，遇到点问题，记录一下。

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

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

首先保证服务正常起来。

在次去看$Oracle_home/network/admin/listener.ora

如果只是在sqlplus 中出现这样的问题。

win
set ORACLE_ID=DBname

管理工具编辑listenr.org

QUOTE:

# 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))
)
)