ora.LISTENER.lsnr状态为Not All Endpoints Registered

本文主要是介绍ora.LISTENER.lsnr状态为Not All Endpoints Registered，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

客户的监控反馈有个监听无法连接，登录环境检查发现ora.LISTENER.lsnr的状态为Not All Endpoints Registered，如下

[root@db2 ~]# crsctl status res -t
--------------------------------------------------------------------------------
NAME           TARGET STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.FRA.dg
               ONLINE ONLINE       db1
               ONLINE ONLINE       db2
ora.CRSDG.dg
               ONLINE ONLINE       db1
               ONLINE ONLINE       db2
ora.DATA.dg
               ONLINE ONLINE       db1
               ONLINE ONLINE       db2
ora.LISTENER.lsnr
               ONLINE ONLINE       db1
               ONLINE INTERMEDIATE db2                      Not All Endpoints R
                                                             egistered
ora.asm
               ONLINE ONLINE       db1                      Started
               ONLINE ONLINE       db2                      Started

经常遇到该类问题，有人使用oracle用户启停监听造成的，

[root@db2 ~]# ps -ef |grep LISTENER
root      2259 1936 0 13:58 pts/4    00:00:00 grep LISTENER
oracle   10681     1 0 Nov03 ?        00:20:01 /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr LISTENER -inherit
grid     32641     1 0 13:55 ?        00:00:00 /u01/app/grid/product/11.2.0/grid_1/bin/tnslsnr LISTENER -inherit
[root@db2 ~]#

处理办法：使用oracle用户把监听关闭 lsnrctl stop

orcl2:/home/oracle@db2> lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 29-NOV-2023 13:59:24

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
The command completed successfully

再次查看，，已恢复正常

[root@db2 ~]# crsctl status res -t
--------------------------------------------------------------------------------
NAME           TARGET STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.FRA.dg
               ONLINE ONLINE       db1
               ONLINE ONLINE       db2
ora.CRSDG.dg
               ONLINE ONLINE       db1
               ONLINE ONLINE       db2
ora.DATA.dg
               ONLINE ONLINE       db1
               ONLINE ONLINE       db2
ora.LISTENER.lsnr
               ONLINE ONLINE       db1
               OFFLINE ONLINE       db2
ora.asm
               ONLINE ONLINE       db1                      Started
               ONLINE ONLINE       db2                      Started