Verify the RAC Cluster & Database Configuration

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