ora 12528:TNS:监听程序:所有适用例程都无法建立新连接
如题，请问发生这样的错误如何解决？
[解决办法]
删了重建试试。
[解决办法]
在LISTENER.ora中添加SID
这个是我的LISTENER.ora
中
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = zl)(PORT = 1521))
)
)
设置后重启listener
lsnrctl stop
lsnrctl start.
[解决办法]
还有你用命令lsnrctl status看看监听状态是正常的吗？
[解决办法]
tnsnames.ora中追加(UR=A),类似如下,试试:
ncdb =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = xxx)
(UR=A)
)
)
