连接报 TNS-12523: TNS:listener could not find instance appropriate for the...

lxqin117

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

Liu Maclean(刘相兵

请给出listener.log

lxqin117

Liu Maclean(刘相兵 发表于 2014-10-25 10:37
请给出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

lxqin117

问题已解决，把监听里的设置改成IP后恢复正常，或者监听设置加上一个IP设置 (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521)) 也能正常