How to Verify the Configuration of Resources for Support for Oracle RAC Database Instances

Language:

Resources for Support for Oracle RAC database instances are created when the tasks in one of the following sections are performed:

Verify that the database resource group is correctly configured.
```
# clresourcegroup show rac-db-rg
```
rac-db-rg

Specifies the name of the database resource group.
If required, verify that the Oracle Grid Infrastructure resources to represent Oracle Solaris Cluster storage resources are correctly configured.
```
# Grid_home/bin/crsctl stat res -t
```
Grid_home

Specifies the Oracle Grid Infrastructure home directory. This directory contains the Oracle Grid Infrastructure binary files and Oracle Grid Infrastructure configuration files.

Disable the Oracle Grid Infrastructure framework resource.
```
# clresource disable -t SUNW.crs_framework +
```
This step might require several minutes to complete.
Verify that the Oracle Grid Infrastructure resources are offline.
1. Attempt to obtain the status of Oracle Grid Infrastructure resources.
  Use the Oracle command crstat for this purpose.
```
# Grid_home/bin/crsctl stat res -t
CRS-0184: Cannot communicate with the CRS daemon.
```
  Grid_home
  
  Specifies the Oracle Grid Infrastructure home directory. This directory contains the Oracle Grid Infrastructure binary files and Oracle Grid Infrastructure configuration files.
2. Consult the system messages file to find messages to indicate that Oracle Grid Infrastructure resources are being shut down.

Verify that the following resources are offline on all nodes:
- The Oracle Grid Infrastructure framework resource
- The Oracle RAC database resource
```
# clresource status -t SUNW.crs_framework,SUNW.scalable_rac_server_proxy +
```
On each node, restart the Oracle Grid Infrastructure.
```
# Grid_home/bin/crsctl start crs
Startup will be queued to init within 30 seconds.
```
Grid_home

Specifies the Oracle Grid Infrastructure home directory. This directory contains the Oracle Grid Infrastructure binary files and Oracle Grid Infrastructure configuration files.

This step might require several minutes to complete.
On each node, verify that the Oracle Grid Infrastructure resources are online.
Use the Oracle command crstat for this purpose.
```
# Grid_home/bin/crsctl stat res -t
```
Note - The startup of Oracle Grid Infrastructure on all nodes might require several minutes to complete. If you perform this step before the Oracle Grid Infrastructure resources are online on all nodes, the status on some nodes might be offline. In this situation, repeat this step until the status of the Oracle Grid Infrastructure is online on all nodes.

Enable the Oracle Grid Infrastructure framework resource.
```
# clresource enable -t SUNW.crs_framework +
```
This step might require several minutes to complete.

Verify that the following resources are online on all nodes:
- The Oracle Grid Infrastructure framework resource
- The Oracle RAC database resource
```
# clresource status -t SUNW.crs_framework,SUNW.scalable_rac_server_proxy +
```
Note - Enabling the Oracle Grid Infrastructure framework resource also enable the Oracle RAC database resource. If you perform this step before the Oracle RAC database resource is enabled on all nodes, the status on some nodes might be offline. In this situation, repeat this step until the status of the Oracle RAC database resource is online on all nodes.