RAC cluster database does not start problem ___ Database

Reproduced in http://blog.itpub.net/23135684/viewspace-759569/

Some times after restarting the server in the 11GR2 RAC database environment, using the Crsctl tool to view the status of the resource, you will find that the target and state values for all instances of the database resource are offline, and that the instance of the databases does not automatically start correctly. Try to execute the following command to enable all instances to start automatically: [Root@rhel1 bin]#./crsctl stat res-t------------------------------------------------------- -------------------------NAME           TARGET  state        server &NB Sp                 state_details       ------------------------- -------------------------------------------------------Local Resources----------------------------------------- ---------------------------------------Ora. DBFILE1.DG                online  online       RHEL1   &N Bsp                                   &NB Sp                online  online       RHEL2                                      &NB Sp Ora. FRA1.DG                online  online       RHEL1   &NBSP ;                                   &NB Sp                online  online       RHEL2                                         or A.listener.lsnr                online  online       Rhel1 &nbs P                                   &NB Sp                  online  online       RHEL2     &nBsp                                   Ora . Listener2.lsnr                online  online       Rhel1 &nbsp ;                                   &NB Sp                  online  online       RHEL2                                       &N Bsp Ora. OCR.DG                online  online       RHEL1                                       &N Bsp                online  online       RHEL2     &NBSP                                   Ora . ASM                online  online       RHEL1     & nbsp                                   &NB Sp              online  online       RHEL2                                         ORA.GSD & nbsp              online  online       RHEL1                                           &N Bsp            online  online       RHEL2                                         Ora.net1.network                online  online       RHEL1     &NBSP ;                                   &NB Sp              online  online       RHEL2                                         Ora.net2. Network                online  online       RHEL1   &NBSP ;                                   &NB Sp                online  online       RHEL2         &NBSP                               ora.ons   &N Bsp            online  online       RHEL1                                             &N Bsp          online  online       RHEL2                                         ORA.REGISTRY.ACFS &nbsp ;              online  online       RHEL1                                           &N Bsp            online  online       RHEL2           &nbSp                            ------------------------ --------------------------------------------------------Cluster Resources-------------------------------------- ------------------------------------------Ora. Listener_scan1.lsnr       1        online  online       Rhel1 &nbsp ;                                   &NB Sp   Ora. Listener_scan2.lsnr       1        online  online       Rhel2 &nbsp ;                                   &NB Sp   Ora. Listener_scan3.lsnr       1        online  online       Rhel2 &nbsp ;                                       ORA.CVU       1        o nline  online       RHEL2                                         ora.oc4j       1       &NBSP ; ONLINE  online       RHEL2                     &NBS P                   ora.ractest.db       1        offline OFFLINE                             &N Bsp                            2       &N Bsp;offline OFFLINE                             &NBS P   &NBSP                  ora.ractest.rtser1.svc       1        offline OFFLINE                         &NBS P                          ORA.RHEL1.VIP     &NBS P 1        online  online       RHEL1             &NBS P                           ORA.RHEL2.VIP     &NB Sp 1        online  online       RHEL2             &NBS P                           ORA.RHELPUB21-VIP.VIP   &N Bsp   1        online  online       RHEL1           &NBSP                             ORA.RHELPUB22-VIP.VIP &N Bsp     1        online  online       RHEL2         &NBS P                               ORA.SCAN1.VIP &NB Sp     1        online  online       RHEL1         &NBS P                               ORA.SCAN2.VIP &NB Sp     1        online  online       RHEL2         &NBS P                               ORA.SCAN3.VIP &NB Sp     1        online  online       RHEL2                                        
As can be seen from the above state, both the target and the value of the Ractest1 and Ractest2 two instances of the Ractest database are offline. Try to change this state by doing the following:
[Oracle@rhel1 ~]$ Srvctl enable database-d ractest [Oracle@rhel1 ~]$ srvctl enable instance-d ractest-i Ractest1 [Oracl E@rhel1 ~]$ srvctl Enable instance-d ractest-i ractest2 [oracle@rhel1 ~]$ srvctl start database-d ractest
After you have done this, try restarting the server again to see if the database instance starts automatically.

Note: In a RAC environment, do not close the database instance by performing shutdown in Sqlplus, which may cause Clusterware to manage the database and instance resources normally.

In addition, you can also refer to the article: http://www.itpub.net/thread-1300493-1-1.html


If the above operations still do not enable the database resources to start automatically, then refer to the following article to modify the resource Auto_start property.
How to Set auto start on 11G RAC
changing Resource Attributes in 11GR2 Grid infrastructureIn 11GR2 grid infrastructure installations Certain, have auto start set to never and restore. This is observed both on environments where Clusterware is upgraded to 11.2 as as. Newly installed. Depending on the situation this May is desirable. Auto start attribute setting could be changed as follows.

1. Check the current auto start values

# crsctl stat res-p
Name=ora. FLASH.DG
type=ora.diskgroup.type
acl=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
ACTION_FAILURE_ template=
action_script=
agent_filename=%crs_home%/bin/oraagent%crs_exe_suffix%
ALIAS_NAME=
Auto_start=never      

Name=ora. DATA.DG
type=ora.diskgroup.type
acl=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
ACTION_FAILURE _template=
action_script=
agent_filename=%crs_home%/bin/oraagent%crs_exe_suffix%
ALIAS_NAME=
Auto_start=never     

Name=ora.clusdb.db
type=ora.database.type
acl=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
action_failure_template=
action_script=
active_placement=1
agent_filename=%crs_home%/bin/ oraagent%crs_exe_suffix%
Auto_start=restore

2. Since ASM diskgroup that database depend on would never auto start database would also be unavailable.

3. Change the resource start attribute with

# Crsctl Modify Resource ' Ora. FLASH.DG "-attr" Auto_start=always "
# Crsctl Modify Resource" Ora. DATA.DG "-attr" Auto_start=always "
# Crsctl Modify Resource ora.clusdb.db-attr" Auto_start=always "

Auto start must is upper case if not command'll fail

Crsctl Modify Resource Ora.clusdb.db-attr "Auto_start=always" crs-0160:the
attribute ' Auto_start ' is not supported I n this resource type.
Crs-4000:command Modify failed, or completed with errors.

4. Verify the status change with

# crsctl stat res-p
name=ora.clusdb.db
type=ora.database.type acl=owner:oracle:rwx,pgrp:oinstall:rwx
, other::r--
action_failure_template=
action_script=
active_placement=1
agent_filename=%crs_home %/bin/oraagent%crs_exe_suffix%
Auto_start=always

The above article reproduced from: http://oracleracdba1.wordpress.com/2013/01/29/how-to-set-auto-start-resources-in-11g-rac/

Oracle 10GR2 RAC references the following to modify resource Auto_start properties.

Use the command crs_register resource_name-update [option ...] [-o option,...] -Q
Such as: Modify the resource Ora.dbrac.dbrac2.inst Auto_start value 0, indicates: The state before the resource reboot
1, say: Start the resource
2, indicating: Do not start the resource
Modifying the property name is represented by the first letter, such as Auto_start = AS
#crs_register Resource_name-update-o as=2

./crs_register Ora.rkywk.db-update-o As=1
./crs_register Ora.rkcxk.db-update-o As=1

Crs_register Ora.rkywk.db-update-o As=always
Crs_register Ora.rkcxk.db-update-o As=always