Verify the RAC Cluster & Database Configuration
Status of all instances and services
$ srvctl status database -d prod
Instance prod1 is running on node rac1
Instance prod2 is running on node rac2
Status of a single instance
$ srvctl status instance -d prod -i prod1
Instance prod1 is running on node rac1
Status of node applications on a particular node
$ srvctl status nodeapps -n rac1
VIP is running on node: rac1
GSD is running on node: rac1
Listener is running on node: rac1
ONS daemon is running on node: rac1
Status of an ASM instance
$ srvctl status asm -n rac1
ASM instance +ASM1 is running on node rac1
List all configured databases
$ srvctl config database
Display configuration for RAC database
$ srvctl config database -d prod
rac1 prod1 /u01/app/oracle/product/10.2.0/db_1
rac2 prod2 /u01/app/oracle/product/10.2.0/db_1
Display all services for the specified cluster database
$ srvctl config service -d prod
orcltest PREF: prod2 prod1 AVAIL:
Display the configuration for node applications – (VIP, GSD, ONS, Listener)
$ srvctl config nodeapps -n rac1 -a -g -s -l
VIP exists.: /rac1-vip/192.168.1.200/255.255.255.0/eth0:eth1
GSD exists.ONS daemon exists.
Listener exists.
Display the configuration for the ASM instance(s)
$ srvctl config asm -n rac1
+ASM1 /u01/app/oracle/product/10.2.0/db_1
Check the status of application resources.
rac1-> crs_stat -t
Check the status of Oracle Clusterware.
rac1-> crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
rac2-> crsctl check crs
CSS appears healthy
CRS appears healthy
EVM appears healthy
Execute crsctl on the command line to check out all the available options.
List the RAC instances.
SQL> select instance_name, host_name, archiver, thread#, status from gv$instance;
Check connectivity.
Verify that you are able to connect to the instances and service on each node.
sqlplus system@devdb1
sqlplus system@devdb2
sqlplus system@devdb
Start and Stop Oracle 10g RAC application Resources
Stop application resources
First Stop Enterprise Manager Database console ->Stop the Oracle Instance -> Down the ASM Instance -> Down the node application (Virtual IP, GSD, TNS Listener, and ONS).
$ emctl stop dbconsole$ srvctl stop instance -d prod -i prod1
$ srvctl stop instance –d prod –i prod2
$ srvctl stop asm -n rac1
$ srvctl stop asm –n rac2
$ srvctl stop nodeapps -n rac1
$srvctl stop –nodeapps –n rac2
Start application resources
First start the node applications (Virtual IP, GSD, TNS Listener, and ONS) -> Start ASM instance – >Start the Oracle instance (and related services) -> Start Enterprise Manager Database console.
$ srvctl start nodeapps -n rac1
$ srvctl start nodeapps -n rac2
$ srvctl start asm -n rac1
$ srvctl start asm -n rac2
$ srvctl start instance -d prod -i prod1
$ srvctl start instance -d prod -i prod2
$ emctl start dbconsole
Responses