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

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

• How to Automate the Startup and Shutdown of Oracle 9i RAC Database Instances

• Registering and Configuring Sun Cluster Resources for Interoperation With Oracle 9i by Using Sun Cluster Maintenance Commands

This procedure provides the long forms of the Sun Cluster maintenance commands. Most commands also have short forms. Except for the forms of the command names, the commands are identical. For a list of the commands and their short forms, see Appendix A, Sun Cluster Object-Oriented Commands, in Sun Cluster Data Services Planning and Administration Guide for Solaris OS.

1. Become superuser on a cluster node, or assume a role that provides solaris.cluster.read and solaris.cluster.admin RBAC authorizations.

2. Verify that the RAC database resource group and the resource groups for logical hostname resources are correctly configured.

   # clresourcegroup show rac-db-rg,lhrg-list

   rac-db-rg

   Specifies the name of the RAC database resource group.

   lhrg-list

   Specifies a comma-separated list of resource groups for logical hostname resources.

3. Take offline the RAC database resource group.

   # clresourcegroup offline rac-db-rg

   rac-db-rg

   Specifies the name of the RAC database resource group.

4. Verify that the RAC database resource group is offline.

   # clresourcegroup status rac-db-rg

   rac-db-rg

   Specifies the name of the RAC database resource group.

5. Verify that the resources in the RAC database resource group are offline on all nodes.

   The RAC database resource group contains the following resources:

   • The scalable RAC server resource

   • The scalable RAC listener resource

   # clresource status -t SUNW.scalable_rac_server,SUNW.scalable_rac_listener +

6. Bring online again the RAC database resource group.

   # clresourcegroup online rac-db-rg

   rac-db-rg

   Specifies the name of the RAC database resource group.

7. Verify that the RAC database resource group is online.

   # clresourcegroup status rac-db-rg

   rac-db-rg

   Specifies the name of the RAC database resource group.

8. Verify that the resources in the RAC database resource group are online on all nodes.

   The RAC database resource group contains the following resources:

   • The scalable RAC server resource

   • The scalable RAC listener resource

   # clresource status -t SUNW.scalable_rac_server,SUNW.scalable_rac_listener +