Problem:
$GRID_HOME/bin/crsctl stat res -t on one RAC node displays the error on node1
-----------------------------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
-----------------------------------------------------------------------------------------------------
Local Resources
-----------------------------------------------------------------------------------------------------
ora.LISTENER.lsnr ONLINE INTERMEDIATE node1 Not All Endpoints Registered
ONLINE ONLINE node2
Cause:
Listener was started from $ORACLE_HOME instead of $GRID_HOME
Solution:
1. Stop currently running local listener from $ORACLE_HOME.
$ORACLE_HOME/bin/lsnrctl stop
2. Stop SCAN listeners currently running on node1.
$GRID_HOME/bin/crsctl stop res ora.LISTENER.lsnr -n node1
$GRID_HOME/bin/crsctl stop res ora.LISTENER_SCAN1.lsnr -n node1
$GRID_HOME/bin/crsctl stop res ora.LISTENER_SCAN2.lsnr -n node1
3. Start local listener from $GRID_HOME of node1
$GRID_HOME/bin/crsctl start res ora.LISTENER.lsnr -n node1
4. Start listeners from GRID_HOME.
$GRID_HOME/bin/crsctl start res ora.LISTENER_SCAN1.lsnr -n node1
$GRID_HOME/bin/crsctl start res ora.LISTENER_SCAN2.lsnr -n node1
5. Check CRS status now.
$GRID_HOME/bin/crsctl stat res -t
Status should be online now.
-----------------------------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
-----------------------------------------------------------------------------------------------------
Local Resources
-----------------------------------------------------------------------------------------------------
ora.LISTENER.lsnr ONLINE ONLINE node1
ONLINE ONLINE node2
Nice one bro
ReplyDelete