Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Not All Endpoints Registered --- What else could be the cause?

888 867-5309Jan 15 2017 — edited Jan 22 2017

I have a rac instance that's been running well for sometime.  I rebooted recently and since the reboot (at least) , crsctl shows the listener state=INTERMEDIATE and the message Not All Endpoints Registered for the listener and scan_listener.  I have not used the oracle home or the oracle user to start the listener.

I use srvctl as the grid user to start and stop the listener.

NODE1

ps -ef | grep tns

root       165     2  0 14:25 ?        00:00:00 [netns]

grid     18971     1  0 16:05 ?        00:00:00 /oracle/app/11.2.0/grid/bin/tnslsnr LISTENER -inherit

grid     19110     1  0 16:06 ?        00:00:00 /oracle/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN1 -inherit

grid     19129     1  0 16:06 ?        00:00:00 /oracle/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN2 -inherit

grid     20005 18760  0 16:15 pts/0    00:00:00 grep tns

NODE2

[grid@njw-devora2 ~]$ ps -ef | grep tns

root       165     2  0 14:21 ?        00:00:00 [netns]

grid     20114     1  0 16:05 ?        00:00:00 /oracle/app/11.2.0/grid/bin/tnslsnr LISTENER -inherit

grid     20187     1  0 16:06 ?        00:00:00 /oracle/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN3 -inherit

grid     21228 21202  0 16:16 pts/0    00:00:00 grep tns

cat listener.ora

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN3 = ON

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN2 = ON

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1 = ON

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_BACKUP_LISTENER = ON

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (GLOBAL_DBNAME = conv.cmawic.local)

      (ORACLE_HOME = /oracle/app/oracle/product/11.2.0/dbhome_1)

      (SID_NAME = conv2)

    )

    (SID_DESC =

      (GLOBAL_DBNAME = rcat.cmawic.local)

      (ORACLE_HOME = /oracle/app/oracle/product/11.2.0/dbhome_1)

      (SID_NAME = rcat2)

    )

    (SID_DESC =

      (GLOBAL_DBNAME = qa.cmawic.local)

      (ORACLE_HOME = /oracle/app/oracle/product/11.2.0/dbhome_1)

      (SID_NAME = qa2)

    )

    (SID_DESC =

      (GLOBAL_DBNAME = +ASM.cmawic.local)

      (ORACLE_HOME = /oracle/app/11.2.0/grid)

      (SID_NAME = +ASM2)

    )

  )

LISTENER =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST=njw-devora2.cmawic.local) (PORT=1521) )

      (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER))

    )

  )

ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER = ON

LISTENER_SCAN3 =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN3))

    )

  )

LISTENER_SCAN2 =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN2))

    )

  )

LISTENER_SCAN1 =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = LISTENER_SCAN1))

    )

  )

ADR_BASE_LISTENER=/oracle/app/grid

This post has been answered by Mark D Powell on Jan 19 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 19 2017
Added on Jan 15 2017
11 comments
4,530 views