Oracle Basic commands

Check satus of cluster resources:

crsctl stat res -t
crsctl status resource -t

Check status of local RAC Background Processes:

crsctl stat res -t -init

Check the status of the OCR:
[root@Rac1 ~]# cd /u01/app/11.2.0/grid/bin/
[root@Rac1 bin]# ./orcrcheck

[root@Rac1 bin]# cat /etc/oracle/ocr.loc

 Get information about the voting disk:
 [root@Rac1 bin]# ./crsctl query css votedisk

 Find the active and software version of the Grid Install:
[root@Rac1 bin]# ./crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [11.2.0.1.0]
[root@Rac1 bin]# ./crsctl query crs softwareversion
Oracle Clusterware version on node [rac1] is [11.2.0.1.0]

Check nodes in cluster:
[root@Rac1 bin]# olsnodes -n
rac1 1
rac2 2

CRS Status:
cd $ORA_CRS_HOME/bin
./crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online

Add database:
srvctl add database -d <DBNAME> -o <ORACLE_HOME>

Add instance:
srvctl add instance -d <DBNAME> -i INSTANCE1 -n <NODE1>
srvctl add instance -d <DBNAME> -i INSTANCE2 -n <NODE2>

Add Spfile:
srvctl modify database -d <DBNAME> -spfile +DATA/<DBNAME>/PARAMETERFILE/spfile<DBNAME>.ora

Add Listener:
srvctl add listener -l <LISTENER_NAME> -p <PORT> -o <ORACLE_HOME>

Config database:
srvctl config database -d <DBNAME>