环境介绍:
11gr2 rac 双节点,两个network资源,network1作为应用访问,network2作为DG,OGG同步备份网络;对应的有两个本地监听LISTENER(端口1521),LISTENER_DG(1621),一个SCAN监听
昨晚趁着存储链路调整,修改了生产环境监听配置。
我们知道11Gr2 rac下,监听文件不再像原来在oracle用户下的$ORACLE_HOME/network/admin目录下了,而是变成了grid用户下的$ORACLE_HOME/network/admin目录下。因此监听的启停以及查看状态都是在grid用户下。
另外,11Gr2 对于监听文件,官方不推荐手动配置(vi),而是通过工具添加生成(srvctl)。我们之所以做监听变更也正是这个原因。一节点监听文件是正常工具生成的格式,二节点不是,从而导致查看集群信息时,二节点的监听状态一直是INTERMEDIATE,而且报错Not All Endpoints Registered。
一节点listener.ora:
LISTENER_DG=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_DG)))) # line added by Agent
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_DG=ON # line added by Agent
二节点listener.ora:
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ON
LISTENER_DG =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = edw2-dg-vip)(PORT = 1621))
)
)
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_DG = ON
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = sfpay-edw-db02)(PORT = 1521))
)
)
ENABLE_GLOBAL_DYNAMIC_END