How to resolve Not All Endpoints Registered, STABLE in CRS?

How to resolve Not All Endpoints Registered, STABLE in CRS?
Advertisement
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:

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!

Share this article:
Advertisement

Comments (0)

No comments yet. Be the first to share your thoughts!