Listener INTERMEDIATE status on CRSCTL STAT check | ORACLE RAC
It was the time when I was trying installing 2 nodes Oracle RAC architecture and was done installing the clusterware and Oracle Database. After running CRSCTL command for resource status check, I was surprised to see that the status for Listener was showing INTERMEDIATE for one of the nodes.
bash-3.2$ crsctl stat res -t
--------------------------------------------------------------------------------------------------------
NAME
TARGET STATE SERVER STATE_DETAILS Local Resources
---------------------------------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.FRA.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.LISTENER.lsnr
ONLINE INTERMEDIATE rac1 Not All Endpoints Registered
ONLINE ONLINE rac2
ora.asm
ONLINE ONLINE rac1 Started
ONLINE ONLINE rac2 Started
ora.gsd
OFFLINE OFFLINE rac1
OFFLINE OFFLINE rac2
ora.net1.network
ONLINE
ONLINE rac1
ONLINE ONLINE rac2
ora.ons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.registry.acfs
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.LISTENER_SCAN1.lsnr
1 ONLINE
ONLINE rac2
ora.cvu
1 ONLINE
ONLINE rac2
ora.rac1.vip
1 ONLINE
ONLINE rac1
ora.rac2.vip
1 ONLINE
ONLINE rac2
ora.racdb.db
1 ONLINE
ONLINE rac1 Open
2 ONLINE
ONLINE rac2 Open
ora.oc4j
1 ONLINE
ONLINE rac2
ora.scan1.vip
1 ONLINE
ONLINE rac2
bash-3.2$
1.Stopped the listener running from ORACLE_HOME (RDBMS)
$/bin/lsnrctl stop
2. Stopped the listener from GRID_HOME
$/bin/srvctl stop listener -n node_name
$/bin/srvctl stop scan_listener -i scan#
3. Restarted the LISTENER and LISTENER_SCAN1 from GRID_HOME
$/bin/srvctl start listener -n node_name
$/bin/srvctl start scan_listener -i scan#
4. checked crsctl stat res -t output and they both displayed ONLINE this time
bash-3.2$
bash-3.2$ crsctl stat res -t
--------------------------------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS Local Resources
---------------------------------------------------------------------------------------------------------
ora.DATA.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.FRA.dg
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.LISTENER.lsnr
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.asm
ONLINE ONLINE rac1 Started
ONLINE ONLINE rac2 Started
ora.gsd
OFFLINE OFFLINE rac1
OFFLINE OFFLINE rac2
ora.net1.network
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.ons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.registry.acfs
ONLINE ONLINE rac1
ONLINE ONLINE rac2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac2
ora.cvu
1 ONLINE ONLINE rac2
ora.rac1.vip
1 ONLINE ONLINE rac1
ora.rac2.vip
1 ONLINE ONLINE rac2
ora.racdb.db
1 ONLINE ONLINE rac1 Open
2 ONLINE ONLINE rac2 Open
ora.oc4j
1 ONLINE ONLINE rac2
ora.scan1.vip
1 ONLINE ONLINE rac2
bash-3.2$
bash-3.2$
bash-3.2$
bash-3.2$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): rac2,rac1
bash-3.2$
thank u so much,
ReplyDeleteproblem resolved