Oracle RAC中监听资源状态Not All Endpoints Registered

适用范围
Oracle Database 11g+

问题概述
Oracle RAC 节点1的ora.LISTENER.lsnr和ora.LISTENER_SCAN1.lsnr状态为Not All Endpoints Registered，实例不能注册到监听中，应用无法连接数据库。
问题原因
oracle用户的环境下启动了监听程序，grid用户启动监听后状态异常。
解决方案：
停止oracle用户的环境下启动的监听程序。
分析过程：
1、检查集群资源状态

[grid@racdb01 ~]$crsctl stat res -t
----------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
----------------------------------------------------------------------
Local Resources
----------------------------------------------------------------------
ora.FRA.dg
               ONLINE  ONLINE        racdb01                                          
               ONLINE  ONLINE        racdb02                                          
ora.SYSTEMDG.dg
               ONLINE  ONLINE        racdb01                                          
               ONLINE  ONLINE        racdb02                                          
ora.DATA.dg
               ONLINE  ONLINE        racdb01                                          
               ONLINE  ONLINE        racdb02                                          
ora.LISTENER.lsnr
       ONLINE   ONLINE               racdb01
       ONLINE   INTERMEDIATE         racdb02    Not All Endpoints Registered
ora.LISTENER_SCAN1.lsnr
   1   ONLINE   INTERMEDIATE         racdb02    Not All Endpoints Registered     
ora.asm
               ONLINE  ONLINE        racdb01                      Started             
               ONLINE  ONLINE        racdb02                      Started  

2、检查监听后台进程

[root@racdb01 ~]ps -ef | grep tns
grid   132443 1 0 Aug5 ? 08:00:24  /u01/app/grid/product/11.2.0/grid/bin/tnslsnr LISTENER_SCAN1 -inherit
grid   134271 1 0 Aug5 ? 08:00:24  /u01/app/grid/product/11.2.0/grid/bin/tnslsnr LISTENER   -inherit
appuser 124325 1 0 Aug4 ? 16:00:00 /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr LISTENER -inherit

数据库环境变量：
grid $GIRD_HOME:/u01/app/grid/product/11.2.0/grid
oracle $ORACLE_HOME:/u01/app/oracle/product/11.2.0/db_1
通过检查发现该节点上监听后台进程有3个，grid用户启动的2个监听后台进程分别为LISTENER_SCAN1和LISTENER，appuser用户使用了oracle用户的环境变量启动了LISTENER，appuser用户使用oracle用户的环境变量启动的监听不太正常，也不符合使用规范。
3、关闭appuser用户下的监听

kill -9 124325 
或者
[oracle@racdb01 ~]$ORACLE_HOME/bin/lsnrctl stop LISTENER

4、重启一下监听

[grid@racdb01 ~]/u01/app/grid/product/11.2.0/grid/bin/srvctl stop listener -n racdb01
[grid@racdb01 ~]/u01/app/grid/product/11.2.0/grid/bin/srvctl stop scan_listener -i 1

5、监听集群状态

[grid@racdb01 ~]$crsctl stat res -t
----------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
----------------------------------------------------------------------
Local Resources
----------------------------------------------------------------------
ora.FRA.dg
               ONLINE  ONLINE        racdb01                                          
               ONLINE  ONLINE        racdb02                                          
ora.SYSTEMDG.dg
               ONLINE  ONLINE        racdb01                                          
               ONLINE  ONLINE        racdb02                                          
ora.DATA.dg
               ONLINE  ONLINE        racdb01                                          
               ONLINE  ONLINE        racdb02                                          
ora.LISTENER.lsnr
       ONLINE   ONLINE               racdb01
       ONLINE   ONLINE               racdb02    
ora.LISTENER_SCAN1.lsnr
   1   ONLINE   ONLINE               racdb02     
ora.asm
               ONLINE  ONLINE        racdb01                      Started             
               ONLINE  ONLINE        racdb02                      Started  

监听资源状态已正常。
-the end-