Oracle11G監聽報錯Connection refused

 

報錯：

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

TNS-00511: No listener

IBM/AIX RISC System/6000 Error: 79: Connection refused

監聽配置：

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.0.243 )(PORT = 1521))

)

)

系統AIX做hacmp雙機互備

10.10.10.101 boot01ip ap

10.10.10.102 boot02ip db

10.11.11.101 stb01ip

10.11.11.102 stb02ip

192.168.0.249 per01ip

192.168.0.250 per02ip

192.168.0.243 dbsvr

192.168.0.241 apsvr

修改監聽為靜態註冊，問題解決：

$ cat listener.ora

# listener.ora Network Configuration File: /oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

# Generated by Oracle configuration tools.

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = boot02ip)(PORT = 1521))

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)

)

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = XLZS57)

(ORACLE_HOME = /oracle/product/11.2.0/dbhome_1)

(SID_NAME = XLZS57)

)

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = /oracle/product/11.2.0/dbhome_1)

(PROGRAM = extproc)

)

)

ADR_BASE_LISTENER = /oracle/product

SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF