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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/14710393/viewspace-1254063/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/14710393/viewspace-1254063/