ORA-12518 TNS:监听程序无法分发客户机连接 解决办法
ORA-12518: TNS:listener could not hand off client connection
在测试中发现，客户端连接数据库服务器时，通过静态监听连接的时候报12518.在网上查了，许多说是因为连接数的限制，可我这个是新建的库，连接数是默认的150.也没有应用，不可能是由于这个原因导致。
经查，发现配置监控的时候把sid写错了,创建库的时候 sid是sid1，可在SID_LIST_LISTENER中配置的是orcl 呵呵，囧。
listener.ora配置信息如下(修改正确之后的)：
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = aa)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = sid1)
)
)
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = aa)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = sid1)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxx)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxx)(PORT = 1521))
)
tnnames.ora内容如下
TEST1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dbname1)
)
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dbname1)
)
)
AA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = aa)
)
)
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = aa)
)
)
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25152032/viewspace-752720/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
AIX 系统中 PVID 的含义与作用
请登录后发表评论
登录
全部评论
