客户的监控反馈有个监听无法连接,登录环境检查发现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
Copyright (c) 1991, 2013, Oracle. All rights reserved.
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