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

引用楼主 lanxing106 的帖子:

如题，请问发生这样的错误如何解决？