Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Grid Infrastructure Does Not Start Cluster Resources

Adhika WJul 1 2013 — edited Jul 3 2013

Hello Gurus,

I configured a 2 node RAC cluster using VirtualBox.It has been running fine all along and each time I started one of the nodes, I will definitely see all of other Cluster Resources will be started eventually.

However, after I left it untouched for a month (VM is stopped), I found out that after starting up the machine, only local resource which is ONLINE.

This is what I get:

[grid@oel6-112-rac1 bin]$ ./crsctl status resource -t

--------------------------------------------------------------------------------

NAME           TARGET  STATE        SERVER                   STATE_DETAILS      

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.CRS.dg

               ONLINE  ONLINE       oel6-112-rac1                               

ora.DATADG.dg

               ONLINE  ONLINE       oel6-112-rac1                               

ora.FRADG.dg

               ONLINE  ONLINE       oel6-112-rac1                               

ora.LISTENER.lsnr

               OFFLINE OFFLINE      oel6-112-rac1                               

ora.asm

               ONLINE  ONLINE       oel6-112-rac1            Started            

ora.gsd

               OFFLINE OFFLINE      oel6-112-rac1                               

ora.net1.network

               ONLINE  ONLINE       oel6-112-rac1                               

ora.ons

               ONLINE  ONLINE       oel6-112-rac1                               

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.LISTENER_SCAN1.lsnr

      1        OFFLINE OFFLINE                                                  

ora.LISTENER_SCAN2.lsnr

      1        OFFLINE OFFLINE                                                  

ora.LISTENER_SCAN3.lsnr

      1        OFFLINE OFFLINE                                                  

ora.cvu

      1        OFFLINE OFFLINE                                                  

ora.oc4j

      1        OFFLINE OFFLINE                                                  

ora.oel6-112-rac1.vip

      1        OFFLINE OFFLINE                                                  

ora.oel6-112-rac2.vip

      1        OFFLINE OFFLINE                                                  

ora.racdb.db

      1        OFFLINE OFFLINE                               Instance Shutdown  

      2        OFFLINE OFFLINE                                                  

ora.scan1.vip

      1        OFFLINE OFFLINE                                                  

ora.scan2.vip

      1        OFFLINE OFFLINE                                                  

ora.scan3.vip

      1        OFFLINE OFFLINE                                               

and these are my other resources

[grid@oel6-112-rac1 bin]$ ./crsctl status resource -t -init

--------------------------------------------------------------------------------

NAME           TARGET  STATE        SERVER                   STATE_DETAILS    

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.asm

      1        ONLINE  ONLINE       oel6-112-rac1            Started          

ora.cluster_interconnect.haip

      1        ONLINE  ONLINE       oel6-112-rac1                             

ora.crf

      1        ONLINE  ONLINE       oel6-112-rac1                             

ora.crsd

      1        ONLINE  ONLINE       oel6-112-rac1                             

ora.cssd

      1        ONLINE  ONLINE       oel6-112-rac1                             

ora.cssdmonitor

      1        ONLINE  ONLINE       oel6-112-rac1                             

ora.ctssd

      1        ONLINE  ONLINE       oel6-112-rac1            ACTIVE:0         

ora.diskmon

      1        OFFLINE OFFLINE                                                

ora.evmd

      1        ONLINE  ONLINE       oel6-112-rac1                             

ora.gipcd

      1        ONLINE  ONLINE       oel6-112-rac1                             

ora.gpnpd

      1        ONLINE  ONLINE       oel6-112-rac1                             

ora.mdnsd

      1        ONLINE  ONLINE       oel6-112-rac1                       

Where do I supposed to check to see why the Cluster Resource like SCAN Listener, Database and etc not running?

I've been checking on the logs but I haven't figured out what I should be looking at.

Can some body help me?

Thank you in advanced,

Adhika

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 31 2013
Added on Jul 1 2013
9 comments
10,918 views