Oracle RAC集群监听Not All Endpoints Registered异常及解决方案
查看集群状态，就发现Not All Endpoints Registered报错，如下所示
[grid@erpdb1 ~]$ crsctl stat res -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.DATA.dg ONLINE ONLINE erpdb1 ONLINE ONLINE erpdb2 ora.LISTENER.lsnr ONLINE INTERMEDIATE erpdb1 Not All Endpoints R egistered ONLINE ONLINE erpdb2 ora.OCR.dg ONLINE ONLINE erpdb1 ONLINE ONLINE erpdb2 ora.asm ONLINE ONLINE erpdb1 Started ONLINE ONLINE erpdb2 Started ora.gsd OFFLINE OFFLINE erpdb1 OFFLINE OFFLINE erpdb2 ora.net1.network ONLINE ONLINE erpdb1 ONLINE ONLINE erpdb2 ora.ons ONLINE ONLINE erpdb1 ONLINE ONLINE erpdb2 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE erpdb2 ora.cvu 1 ONLINE ONLINE erpdb1 ora.erpdb1.vip 1 ONLINE ONLINE erpdb1 ora.erpdb2.vip 1 ONLINE ONLINE erpdb2 ora.oc4j 1 ONLINE ONLINE erpdb1 ora.orcl.db 1 ONLINE ONLINE erpdb1 Open 2 ONLINE ONLINE erpdb2 Open ora.pacs.db 1 ONLINE ONLINE erpdb1 Open 2 ONLINE ONLINE erpdb2 Open ora.scan1.vip 1 ONLINE ONLINE erpdb2
经查阅相关资料得知，该问题是由于数据库监听和集群监听同时开启所导致，关闭数据库监听即可解决该问题。
lsnrctl stop
另外将数据库监听配置文件直接重名或删除，以免误起监听。
