Wednesday 17 May 2017

Listener INTERMEDIATE status on CRSCTL STAT check | ORACLE RAC

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$

The Solution was easier and I got the same with the help of Google Uncle in a few minutes. Actually the problem was and you should always keep the same in mind. After Oracle 11gR2, listener resides in GRID_HOME and should be running from the same. In my case, exactly the same happened. I was also running the listener from ORACLE_HOME which I should not be doing. I rectified my mistake by following the below mentioned steps:

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$

I hope this helps you as well.

1 comment: