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博客 ” ，链接：https://blog.itpub.net/14710393/viewspace-1254063/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- Install and configure VMware_vSphere 5
- Docker run OGG Classic Architecture container from CIFS with docker-volume-netsh
- 【OERR】 oerr ora 错误 12.2.0.1 【20000-39999】
- Oracle Online Redefinition在线重定义（下）
- Oracle Online Redefinition在线重定义（上）
- Oracle Online Redefinition在线重定义（中）
- Oracle中查找依赖的无效对象(invalid object)
- goldengate部署实施案例
- goldengate常用函数使用说明
- goldengate基于表复制
