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.
BASH[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 (0)
Please sign in to leave a comment.
No comments yet. Be the first to share your thoughts!