Listener in INTERMEDIATE status with “Not All Endpoints Registered”

Hello,
In 2 node RAC cluster, below command shows the listeners are in INTERMEDIATE status.
$crsctl stat res -t

b1

b2

You can not query the status of listener also:

b4

The problem is caused by another listener defined statically in listener.ora, using the same port and IP is running from the RDBMS ORACLE_HOME, started manually causing the default listener starting from GRID_HOME can not register its endpoint. Hence the error reported in dbca.  Another possible cause is the listener or scan listener being defined manually in listener.ora.

From 11.2 on wards, all listeners should be running from GRID_HOME, listener and listener_scan<n> entry should be added automatically into listener.ora, no manual editing is required for TCP definition.

1- Stop the listener running from RDBMS ORACLE_HOME

$<RDBMS ORACLE_HOME>/bin/lsnrctl stop LISTENER

2- stop the listener from GRID_HOME

$<GRID_HOME>/bin/srvctl stop listener -n host1
$<GRID_HOME>/bin/srvctl stop scan_listener -i 1

If above command fails to stop the tnslsnr process, please use “kill -9 <pid of tnslsnr>” to stop the LISTENER and LISTENER_SCAN1 process.

3- remove any manually added LISTENER definition from listener.ora if it exists

4- restart the LISTENER and LISTENER_SCAN1  from GRID_HOME

$<GRID_HOME>/bin/srvctl start listener -n <node name>
$<GRID_HOME>/bin/srvctl start scan_listener -i <scan#>

5- check crsctl stat res -t output, they both should show ONLINE status now.

b3

Leave a comment