Not All Endpoints Registered

If issuing “crsctl status resource” command show the status of listener as “Not All Endpoints Registered”, it is usually because of contradictions in the Listener settings. It means that probably you have a manually setup listener (by editing listener.ora file) with different settings than registered with the CRS/HAS. Or, there could be multiple listeners configured from multiple oracle homes – one from Grid Infrastructure home, and other listener with same configuration running from other home and started manually (using lsnrctl command).

I faced this issue because I had a listener “Listener” configured with CRS on port 1522, whereas same “Listener” was also statically defined in the listener.ora of same GI (Grid Infrastructure) home with port 1521.

[grid]$ crsctl stat res -t -------------------------------------------------------------------------------- NAME           TARGET  STATE        SERVER                   STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr                ONLINE  INTERMEDIATE my_db_host           Not All Endpoints Registered ora.ORADATA.dg                ONLINE  OFFLINE      my_db_host ora.ORAFRA.dg                ONLINE  OFFLINE      my_db_host ora.asm                ONLINE  ONLINE       my_db_host                   Started ora.ons                OFFLINE OFFLINE     my_db_host -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.cssd       1        ONLINE  ONLINE       my_db_host ora.diskmon       1        OFFLINE OFFLINE ora.evmd       1        ONLINE  ONLINE      my_db_host ora.opera.db 1              OFFLINE OFFLINE [grid]$ srvctl config listener Name: LISTENER Home: /u01/app/11204/grid End points: TCP:1522

As you can see above, the port of listener is set to 1522, however, my listener.ora file was configured with port 1521. To fix this, I changed the port of my listener back to 1521 in CRS configuration. You may consider changing port in listener.ora file to match with the CRS configuration.

[grid]$ srvctl modify listener -l listener -p 1521 [grid]$ srvctl config listener Name: LISTENER Home: /u01/app/11204/grid End points: TCP:1521

Once done, restart of listener solved the problem permanently.

[grid]$ srvctl stop listener [grid]$ srvctl start listener [grid]$ crsctl stat res -t -------------------------------------------------------------------------------- NAME           TARGET  STATE        SERVER                   STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr                ONLINE  ONLINE       my_db_host ora.ORADATA.dg                ONLINE  OFFLINE      my_db_host ora.ORAFRA.dg                ONLINE  OFFLINE      my_db_host ora.asm                ONLINE  ONLINE       my_db_host Started ora.ons … … …

 Always make sure that listener configuration is consistent between listener.ora file and CRS configuration.