我的问题是, RAC系统有两个节点,
endpoints_listener和istener 配置如下:
node1:
LISTENER_DB1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=DB1-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.72.24.152)(PORT=1521)(IP=FIRST)))) # 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
node2:
LISTENER_DB2=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=DB2-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.72.24.153)(PORT=1521)(IP=FIRST)))) # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
一个节点客户端可以正常连接,另外一个就报ORA-12514(TNS:监听程序当前无法识别servicename),然后在这个节点上执行lsnrctl stop/start LISTENER 后,这个节点就正常了,但是另外的节点就不行了,执行lsnrctl start LISTENER,报错,说已经启动。也就是说两个节点不能同时起监听 只能有一个启动
我看两个节点上的监听配置文件里 监听名字都是LISTENER ,和这个有关系?应该起不同名字吗?求指教。