在做HP-UX 互备双机时碰到的oracle起双监听问题

在做 HP-UX 互备双机时碰到的oracle双监听的问题：

HP-UX 11.31  oracle 10g

 

1、在rx8640 节点，oracle 监听：

SID_LIST_nstrong=
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /ora_ywgl/app/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = nstrong)
      (ORACLE_HOME = /ora_ywgl/app/product/10.2.0/db_1)
      (SID_NAME = nstrong)
    )
  )
nstrong =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.160.8.51)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )

 

2、在hp superdome 节点，监听：

SID_LIST_gzthgk =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /ora_tygk/app/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = gzthgk)
      (ORACLE_HOME = /ora_tygk/app/product/10.2.0/db_1)
      (SID_NAME = gzthgk)
    )
  )
gzthgk =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.160.8.35)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
  )

 

 

问题：
当在同一台机器上起监听时,报TNS-01106错误。
分析发现gzthgk监听的key=exproc0和nstrong监听相同,系统把它认为是相同的地址了.更改gzthgk的key=exproc01后或删除此行地址描述,问题解决.
上面的黑体：(KEY = EXTPROC0)

 

在同一台机器上起双监听的实例：
LISTENER2 =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.203.36.5)(PORT = 1522))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
   )
)

SID_LIST_LISTENER2 =
(SID_LIST =
    (SID_DESC =
      (SID_NAME = edwdb)
      (ORACLE_HOME = /u01/oracle/product/db10gr2)
    )
)

SID_LIST_LISTENER =
(SID_LIST =
    (SID_DESC =
      (SID_NAME = edwdb)
      (ORACLE_HOME = /u01/oracle/product/db10gr2)
    )
)

LISTENER =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.203.36.5)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
)