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

bestsun999

已于 2023-11-29 17:01:20 修改

阅读量491

点赞数

分类专栏： OracleDB 文章标签：数据库运维 oracle

于 2023-11-29 16:55:49 首次发布

本文链接：https://blog.csdn.net/kevinyu998/article/details/134694243

版权

OracleDB 专栏收录该内容

91 篇文章 4 订阅

订阅专栏

客户的监控反馈有个监听无法连接，登录环境检查发现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