连接报 TNS-12523: TNS:listener could not find instance appropriate for the...
环境WINDOWS2008+ORACLE 10.2.0.4通过CONN SYS/ORACLE@XMJMNEW AS SYSDBA连接的时候会报TNS-12523: TNS:listener could not find instance appropriate for the client connection，数据库模式是DEDICATED模式，重建过几次监听均无效果，查看各个状态好像没有发现有问题
请教各位大神，还有别的思路吗
LSNRCTL SERVICE配置如下：
LSNRCTL for 64-bit Windows: Version 10.2.0.4.0 - Production on 24-OCT-2014 09:25
:39
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hcyy-7)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "hctest" has 1 instance(s).
Instance "hctest", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "hctestXDB" has 1 instance(s).
Instance "hctest", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER <machine: HCYY-7, pid: 2340>
(ADDRESS=(PROTOCOL=tcp)(HOST=hcyy-7)(PORT=49173))
Service "xmjmnew" has 1 instance(s).
Instance "xmjmnew", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
Service "xmjmnew_XPT" has 1 instance(s).
Instance "xmjmnew", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0 state:ready
LOCAL SERVER
The command completed successfully
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 = TCP)(HOST = hcyy-7)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
TNSNAMES.ORA配置如下：
XMJMNEW =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = hcyy-7)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XMJMNEW)
)
) 请给出listener.log Liu Maclean(刘相兵 发表于 2014-10-25 10:37 static/image/common/back.gif
请给出listener.log
LISTENER.LOG日志里出现的都是以下报错
22-OCT-2014 02:29:48 * service_update * xmjmnew * 0
22-OCT-2014 02:29:53 * (CONNECT_DATA=(SERVICE_NAME=xmjmnew)(CID=(PROGRAM=D:\Program Files\xmzs\EMR Server\zdog.exe)(HOST=HCYY-21)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.95.32.21)(PORT=3298)) * establish * xmjmnew * 12523
TNS-12523: TNS:listener could not find instance appropriate for the client connection
22-OCT-2014 02:30:34 * service_update * hctest * 0
22-OCT-2014 02:30:53 * (CONNECT_DATA=(SERVICE_NAME=xmjmnew)(CID=(PROGRAM=D:\Program Files\xmzs\EMR Server\zdog.exe)(HOST=HCYY-21)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.95.32.21)(PORT=3301)) * establish * xmjmnew * 12523
TNS-12523: TNS:listener could not find instance appropriate for the client connection
22-OCT-2014 02:31:53 * (CONNECT_DATA=(SERVICE_NAME=xmjmnew)(CID=(PROGRAM=D:\Program Files\xmzs\EMR Server\zdog.exe)(HOST=HCYY-21)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.95.32.21)(PORT=3303)) * establish * xmjmnew * 12523
TNS-12523: TNS:listener could not find instance appropriate for the client connection
22-OCT-2014 02:32:53 * (CONNECT_DATA=(SERVICE_NAME=xmjmnew)(CID=(PROGRAM=D:\Program Files\xmzs\EMR Server\zdog.exe)(HOST=HCYY-21)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.95.32.21)(PORT=3305)) * establish * xmjmnew * 12523
TNS-12523: TNS:listener could not find instance appropriate for the client connection
22-OCT-2014 02:33:53 * (CONNECT_DATA=(SERVICE_NAME=xmjmnew)(CID=(PROGRAM=D:\Program Files\xmzs\EMR Server\zdog.exe)(HOST=HCYY-21)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.95.32.21)(PORT=3307)) * establish * xmjmnew * 12523
TNS-12523: TNS:listener could not find instance appropriate for the client connection
22-OCT-2014 02:34:53 * (CONNECT_DATA=(SERVICE_NAME=xmjmnew)(CID=(PROGRAM=D:\Program Files\xmzs\EMR Server\zdog.exe)(HOST=HCYY-21)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.95.32.21)(PORT=3309)) * establish * xmjmnew * 12523
TNS-12523: TNS:listener could not find instance appropriate for the client connection
22-OCT-2014 02:35:53 * (CONNECT_DATA=(SERVICE_NAME=xmjmnew)(CID=(PROGRAM=D:\Program Files\xmzs\EMR Server\zdog.exe)(HOST=HCYY-21)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.95.32.21)(PORT=3311)) * establish * xmjmnew * 12523
TNS-12523: TNS:listener could not find instance appropriate for the client connection
22-OCT-2014 02:36:30 * service_update * hctest * 0
22-OCT-2014 02:36:53 * (CONNECT_DATA=(SERVICE_NAME=xmjmnew)(CID=(PROGRAM=D:\Program Files\xmzs\EMR Server\zdog.exe)(HOST=HCYY-21)(USER=SYSTEM))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.95.32.21)(PORT=3313)) * establish * xmjmnew * 12523
TNS-12523: TNS:listener could not find instance appropriate for the client connection 问题已解决，把监听里的设置改成IP后恢复正常，或者监听设置加上一个IP设置 (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521)) 也能正常
页:
[1]