In Oracle Real Application Clusters (RAC) environments, especially when using Automatic Storage Management (ASM), the Cluster Ready Services (CRS) and SCAN listeners play a crucial role in managing connectivity and service registration. The error message:
Typically appears when running crsctl stat res -t and indicates that one or more listeners (often SCAN listeners) have not successfully registered all expected endpoints. This doesn't always mean a failure, but it does signal that something is preventing full registration.
Oracle listeners dynamically register endpoints for services and instances. When the listener is in a STABLE state but still shows "Not All Endpoints Registered", it means:
That’s it.
If you would have any questions or concerns, please leave your comments. I would be glad to explain in more details. Thank you so much for all your feedback and support!
ERROR
"Not All Endpoints Registered, STABLE"
Typically appears when running crsctl stat res -t and indicates that one or more listeners (often SCAN listeners) have not successfully registered all expected endpoints. This doesn't always mean a failure, but it does signal that something is preventing full registration.
Common Causes Behind the Error:
- Database or ASM instance not auto-registering with the listener due to missing or incorrect LOCAL_LISTENER or REMOTE_LISTENER parameters.
- Listener not running under the correct Oracle Home or not started using srvctl, which can cause registration issues.
- Network misconfiguration, such as:
- Incorrect or duplicate entries in /etc/hosts
- DNS resolution failures for VIP or SCAN names
- Port conflicts where another process is already using the expected listener port.
- Firewall or SELinux restrictions blocking communication between the database instance and the listener.
- Listener.ora misconfiguration, especially missing ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER settings.
What It Means Technically?
Oracle listeners dynamically register endpoints for services and instances. When the listener is in a STABLE state but still shows "Not All Endpoints Registered", it means:
- The listener is up and running.
- However, some services or instances have not registered with it, either due to timing issues (e.g., the database hasn't started yet) or configuration problems.
[grid@dg1 admin]$ lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 03-JUL-2025 21:44:21
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.104)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 03-JUL-2025 21:14:17
Uptime 0 days 0 hr. 30 min. 4 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/grid/19.0.0/gridhome_1/network/admin/listener.ora
Listener Log File /u01/app/gridbase/diag/tnslsnr/dg1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.104)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=dg1.bracecoder)(PORT=5500))(Security=(my_wallet_directory=/u01/app/oracle/product/19.0.0/db_1/admin/oradb/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "oradb.bracecoder" has 1 instance(s).
Instance "oradb", status READY, has 1 handler(s) for this service...
Service "oradbXDB.bracecoder" has 1 instance(s).
Instance "oradb", status READY, has 1 handler(s) for this service...
The command completed successfully
[grid@dg1 admin]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE dg1 STABLE
ora.FRA.dg
ONLINE ONLINE dg1 STABLE
ora.LISTENER.lsnr
ONLINE INTERMEDIATE dg1 Not All Endpoints Re
gistered,STABLE
ora.asm
ONLINE ONLINE dg1 Started,STABLE
ora.ons
OFFLINE OFFLINE dg1 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE dg1 STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE dg1 STABLE
ora.oradb.db
1 ONLINE ONLINE dg1 Open,HOME=/u01/app/o
racle/product/19.0.0
/db_1,STABLE
--------------------------------------------------------------------------------
[grid@dg1 admin]$ cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.1.104 dg1.bracecoder dg1
[grid@dg1 admin]$
[grid@dg1 admin]$ crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'dg1'
CRS-2673: Attempting to stop 'ora.evmd' on 'dg1'
CRS-2673: Attempting to stop 'ora.oradb.db' on 'dg1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'dg1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'dg1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'dg1' succeeded
CRS-2677: Stop of 'ora.oradb.db' on 'dg1' succeeded
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'dg1'
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'dg1'
CRS-2677: Stop of 'ora.FRA.dg' on 'dg1' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'dg1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'dg1'
CRS-2677: Stop of 'ora.asm' on 'dg1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'dg1'
CRS-2677: Stop of 'ora.cssd' on 'dg1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'dg1' has completed
CRS-4133: Oracle High Availability Services has been stopped.
[grid@dg1 admin]$ crsctl start has
CRS-4123: Oracle High Availability Services has been started.
[grid@dg1 admin]$ crsctl stat res -t
[grid@dg1 admin]$ crsctl start has
CRS-4123: Oracle High Availability Services has been started.
[grid@dg1 admin]$
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE dg1 STABLE
ora.FRA.dg
ONLINE ONLINE dg1 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE dg1 STABLE
ora.asm
ONLINE ONLINE dg1 Started,STABLE
ora.ons
OFFLINE OFFLINE dg1 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE dg1 STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE dg1 STABLE
ora.oradb.db
1 ONLINE ONLINE dg1 Open,HOME=/u01/app/o
racle/product/19.0.0
/db_1,STABLE
--------------------------------------------------------------------------------
[grid@dg1 admin]$That’s it.
If you would have any questions or concerns, please leave your comments. I would be glad to explain in more details. Thank you so much for all your feedback and support!
Comments
0Please sign in to leave a comment.
No comments yet
Be the first to share your thoughts!