RAC and ASM Troubleshooting Part -1

Normal Commands to Maintain the RAC environment are as follows:

     In most of the cases and the recommended configuration, crsctl should be executed as a root  and the command srvctl should be executed as DB user.(For ease of administration, it is better to have 2 separate users for Grid and DB.Grid user will be responsible for the ASM ,Voting Disk(VD), Oracle Cluster Registry(OCR) and other Cluster Ready Services.)

i) To check the status of CRS (Cluster Ready Services)

           # crsctl check crs 

ii) To check the Status of services on all nodes
           
         $ srvctl status nodeapps
 or
         # crsctl status resource -t 
or
       # crsctl stat res -t

      # crsctl stat res -t -init
 
     #crsctl stat res -p

iii) To check the Clusterware servers:

# crsctl status server -f

iv) To check the status of the RAC High Availability Services

#crsctl status has

v) To check the status of Specific instance across the cluster nodes:

$srvctl status instance -d <rac_database> -i <rac_database_instance>

v) To check the status of all instances across the cluster nodes:

$srvctl status instance -d <rac_database> -i <rac_database_instance1>, <rac_database_instance2>,<rac_database_instance3>

vi) To check the Database status across all the cluster nodes:

$srvctl status database -d <rac_database> 

Maintaining the RAC Database:

i) To Stop the RAC Database 

# crsctl stop cluster -all

ii)  To stop crs on specific node

#crsctl stop has
or
# crsctl stop crs

iii) To stop the crs by force on specific node

# crsctl stop crs -f

iv) To start the crs on specific node

# crsctl start has
or
#crsctl start crs

v) To stop the specific instance across the cluster nodes:

$srvctl stop instance -d <rac_database> -i <rac_instance1>

vi) To start the specific instance across the cluster nodes:

$srvctl start instance -d <rac_database> -i <rac_instance1>

vii) To stop all the instances across the cluster nodes:

$srvctl stop instance -d <rac_database> -i <rac_instance1>, <rac_instance2>,<rac_instance3>

viii) To start all the instances across the cluster nodes:


$srvctl start instance -d <rac_database> -i <rac_instance1>, <rac_instance2>,<rac_instance3>

ix) To stop cluster Database

$srvctl stop database -d <rac_database>

x) To Start the Cluster Database

$srvctl start database -d <rac_database>