ORACLE 11.2.0.4 RAC启动CRS之后查看集群状态，有监听状态为：Not All Endpoints Registered
[root@hisdb1 ~]# crsctl status res -t
NAME TARGET STATE SERVER STATE_DETAILS
Local Resources
ora.DATA.dg
ONLINE ONLINE hisdb1
ONLINE ONLINE hisdb2
ora.GRID.dg
ONLINE ONLINE hisdb1
ONLINE ONLINE hisdb2
ora.LISTENER.lsnr
ONLINE INTERMEDIATE hisdb1 Not All Endpoints R
egistered
ONLINE INTERMEDIATE hisdb2 Not All Endpoints R
egistered
ora.LISTENER_ADG.lsnr
ONLINE ONLINE hisdb1
ONLINE ONLINE hisdb2
ora.SYSTEM.dg
ONLINE ONLINE hisdb1
ONLINE ONLINE hisdb2
ora.asm
ONLINE ONLINE hisdb1 Started
ONLINE ONLINE hisdb2 Started
ora.gsd
OFFLINE OFFLINE hisdb1
OFFLINE OFFLINE hisdb2
ora.net1.network
ONLINE ONLINE hisdb1
ONLINE ONLINE hisdb2
ora.ons
ONLINE ONLINE hisdb1
ONLINE ONLINE hisdb2
Cluster Resources
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE hisdb2
ora.cvu
1 ONLINE ONLINE hisdb1
ora.hisdb.db
1 OFFLINE OFFLINE Instance Shutdown
2 OFFLINE OFFLINE Instance Shutdown
ora.hisdb1.vip
1 ONLINE ONLINE hisdb1
ora.hisdb2.vip
1 ONLINE ONLINE hisdb2
ora.oc4j
1 ONLINE ONLINE hisdb1
ora.scan1.vip
1 ONLINE ONLINE hisdb2
ora.LISTENER_ADG.lsnr这个LISTENER_ADG是为了配置RAC+RAC+ADG手动添加的静态监听，状态却是ONLINE，用如下命令进行添加的：
srvctl add listener -l LISTENER_ADG -o $ORACLE_HOME -p “TCP:1521”
grid用户和oracle用户下的监听状态分别如下：
[grid@hisdb1:/home/grid]$lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 07-MAY-2021 20:38:14
Copyright © 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 07-MAY-2021 20:29:57
Uptime 0 days 0 hr. 8 min. 17 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /oracle/app/grid/diag/tnslsnr/hisdb1/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
The listener supports no services
The command completed successfully
[grid@hisdb1:/home/grid]$lsnrctl status LISTENER_ADG
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 07-MAY-2021 20:46:48
Copyright © 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_ADG)))
STATUS of the LISTENER
Alias LISTENER_ADG
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 07-MAY-2021 20:29:57
Uptime 0 days 0 hr. 16 min. 51 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /oracle/app/11.2.0/grid/log/diag/tnslsnr/hisdb1/listener_adg/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_ADG)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.100)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.102)(PORT=1521)))
Services Summary…
Service “+ASM” has 1 instance(s).
Instance “+ASM1”, status READY, has 1 handler(s) for this service…
Service “hisdb” has 1 instance(s).
Instance “hisdb1”, status UNKNOWN, has 1 handler(s) for this service…
The command completed successfully
[oracle@hisdb1:/home/oracle]$lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 07-MAY-2021 20:38:47
Copyright © 1991, 2013, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
Alias LISTENER_ADG
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 07-MAY-2021 20:29:57
Uptime 0 days 0 hr. 8 min. 50 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oracle/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /oracle/app/11.2.0/grid/log/diag/tnslsnr/hisdb1/listener_adg/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_ADG)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.100)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.102)(PORT=1521)))
Services Summary…
Service “+ASM” has 1 instance(s).
Instance “+ASM1”, status READY, has 1 handler(s) for this service…
Service “hisdb” has 1 instance(s).
Instance “hisdb1”, status UNKNOWN, has 1 handler(s) for this service…
The command completed successfully
listener.ora的配置文件如下：
[oracle@hisdb1:/home/oracle]$cat /oracle/app/11.2.0/grid/network/admin/listener.ora
LISTENER_ADG=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_ADG)))) # line added by Agent
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_ADG=ON # line added by Agent
SID_LIST_LISTENER_ADG =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = hisdb)
(ORACLE_HOME = /oracle/app/11.2.0/grid)
(SID_NAME=hisdb1)
)
)
主机名配置文件如下：
[grid@hisdb1:/home/grid]$cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.2.100 hisdb1
192.168.2.102 hisdb1-vip
1.1.1.1 hisdb1-priv
192.168.2.101 hisdb2
192.168.2.103 hisdb2-vip
1.1.1.2 hisdb2-priv
192.168.2.104 hisdb-scan
请问各位，crsctl status res -t里面，监听listener状态为什么是Not All Endpoints Registered呢？这个是什么意思，如何排查问题
ora.LISTENER.lsnr
ONLINE INTERMEDIATE hisdb1 Not All Endpoints R
egistered
ONLINE INTERMEDIATE hisdb2 Not All Endpoints R
egistered
见附件，看看跟你的情况相符不相符：
Listener in INTERMEDIATE status with “Not All Endpoints Registered” (Doc ID 1454439.1)
评论
有用 0你好，@你好我是李白
根据文档里的说明：原因可能是在listener.ora文件里手动添加了一个相同IP、相同端口的另一个监听，解决方法是停掉ORACLE目录下面的监听、停掉GRID下面的监听、删除listener.ora文件里手动添加的内容、重启监听
但是，删除了手动添加的内容之后，静态监听怎么配置呢？用netmgr吗？
准备试试之后看看结果
评论 有用 0李白的文档中有说明：
From 11.2 on wards, all listeners should be running from GRID_HOME, listener and listener_scan
entry should be
added automatically into listener.ora, no manual editing is required for TCP definition.
所以在11.2及以后的版本中，不需要再手动设置。
静态监听直接在客户端配置即可。
评论 有用 0静态监听也可以添加呀，添加静态监听不需要写LISTENER条目，只需要写SID_LIST_LISTENER条目就可以啦。例如我的测试环境监听：
[grid@db1 ~]$ cat /u01/app/11.2/grid/network/admin/listener.ora LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))) # line added by Agent LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))) # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON # line added by Agent ENABLE_GLOBAL_DYNAMIC_ENDPOINT_DUP_LISTENER=ON # line added by Agent DIAG_ADR_ENABLED_LISTENER = OFF TRACE_LEVEL_LISTENER = 16 TRACE_FILELEN_LISTENER = 512000 TRACE_FILENO_LISTENER = 2 SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = dup) (ORACLE_HOME = /u01/app/oracle/product/11.2/db_1) (SID_NAME = dup) ) )
我的测试环境监听状态
[grid@db1 ~]$ crsctl status res ora.LISTENER.lsnr -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr ONLINE ONLINE db-oracle-node1 [grid@db-oracle-node1 ~]$ lsnrctl status LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 08-MAY-2021 13:08:15 ..省略部分输出 Listener Parameter File /u01/app/11.2/grid/network/admin/listener.ora ..省略部分输出 Service "dup" has 1 instance(s). Instance "dup", status UNKNOWN, has 1 handler(s) ..省略部分输出
评论 有用 0补充一下，如果要静态监听多个实例，只需要添加增加多个SID_DESC即可：
SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = test1) (GLOBAL_DBNAME = test2) (ORACLE_HOME =/u01/app/oracle/product/11.2/db_1) ) (SID_DESC = (SID_NAME = test2) (GLOBAL_DBNAME = test2) (ORACLE_HOME =/u01/app/oracle/product/11.2/db_1) ) )
评论 有用 0
墨值悬赏