Sun Cluster Data Service for Oracle Real Application Clusters Guide for Solaris OS

Verifying the Status of Sun Cluster Support for Oracle Real Application Clusters

The status of the SUNW.rac_framework resource indicates the status of Sun Cluster Support for Oracle Real Application Clusters. The Sun Cluster system administration tool scstat(1M) enables you to obtain the status of this resource.

ProcedureHow to Verify the Status of Sun Cluster Support for Oracle Real Application Clusters

Steps
  1. Become superuser.

  2. Type the following command:


    # scstat -g
    

Examples of the Status of Sun Cluster Support for Oracle Real Application Clusters

The following examples show the status of the resources for a two-node configuration of Sun Cluster Support for Oracle Real Application Clusters. This configuration uses Solaris Volume Manager for Sun Cluster to store the Oracle Real Application Clusters database.

Each node contains a RAC framework resource group that is named rac-framework-rg. The resource type and resource name of each resource in these resource groups is shown in the following table.

Resource Type 

Resource Instance Name 

SUNW.rac_framework

rac_framework

SUNW.rac_udlm

rac_udlm

SUNW.rac_svm

rac_svm

Each node contains a resource group for an Oracle RAC server resource on as shown in the following table. The table also shows the resource type and the name of the resource in each resource group.

Node 

Resource Group 

Resource Type  

Resource Name 

node1

RAC1-rg

SUNW.oracle_rac_server

RAC1

node1

RAC2-rg

SUNW.oracle_rac_server

RAC2

Oracle listener resources are configured in their own resource groups. The status of these resource groups is not shown in the examples that follow.


Example 5–1 Status of a Faulty RAC Framework Resource Group


-- Resource Groups and Resources --

           Group Name        Resources
           ----------        ---------
Resources: rac-framework-rg  rac_framework rac_udlm rac_svm
Resources: RAC1-rg             RAC1
Resources: RAC2-rg             RAC2


-- Resource Groups --

            Group Name        Node Name  State
            ----------        ---------  -----
     Group: rac-framework-rg  node1      Online faulted
     Group: rac-framework-rg  node2      Online

     Group: RAC1-rg           node1       Online

     Group: RAC2-rg           node2     Online


-- Resources --

            Resource Name    Node Name  State     Status Message
            -------------    ---------  -----     --------------
  Resource: rac_framework    node1      Start failed Degraded - reconfiguration in progress
  Resource: rac_framework    node2      Online    Online

  Resource: rac_udlm         node1      Offline   Unknown - RAC framework is running
  Resource: rac_udlm         node2      Online    Online

  Resource: rac_svm          node1      Offline   Unknown - RAC framework is running
  Resource: rac_svm          node2      Online    Online

  Resource: RAC1             node1      Online    Online

  Resource: RAC2             node2      Online    Faulted

This example provides the following status information for a RAC framework resource group that is faulty.



Example 5–2 Status of a Faulty RAC Server Resource Group


-- Resource Groups and Resources --

             Group Name          Resources
             ----------          ---------
  Resources: rac-framework-rg    rac_framework rac_udlm rac_svm
  Resources: RAC1-rg             RAC1    
  Resources: RAC2-rg             RAC2    


-- Resource Groups --

             Group Name          Node Name      State
             ----------          ---------      -----
      Group: rac-framework-rg    node1          Online
      Group: rac-framework-rg    node2          Online

      Group: RAC1-rg             node1          Online

      Group: RAC2-rg             node2          Online faulted


-- Resources --

             Resource Name      Node Name      State     Status Message
             -------------      ---------      -----     --------------
   Resource: rac_framework      node1          Online    Online
   Resource: rac_framework      node2          Online    Online

   Resource: rac_udlm           node1          Online    Online
   Resource: rac_udlm           node2          Online    Online

   Resource: rac_svm            node1          Online    Online
   Resource: rac_svm            node2          Online    Online

   Resource: RAC1               node1          Online    Online

   Resource: RAC2               node2          Online    Faulted - RAC instance not running

This example provides the following status information for a RAC server resource group that is faulty:



Example 5–3 Status of an Operational Oracle Real Application Clusters Configuration


-- Resource Groups and Resources --

             Group Name          Resources
             ----------          ---------
  Resources: rac-framework-rg    rac_framework rac_udlm rac_svm
  Resources: RAC1-rg             RAC1    
  Resources: RAC2-rg             RAC2    


-- Resource Groups --

             Group Name          Node Name           State
             ----------          ---------           -----
      Group: rac-framework-rg    node1               Online
      Group: rac-framework-rg    node2               Online

      Group: RAC1-rg             node1               Online

      Group: RAC2-rg             node2               Online


-- Resources --

             Resource Name       Node Name           State     Status Message
             -------------       ---------           -----     --------------
   Resource: rac_framework       node1               Online    Online
   Resource: rac_framework       node2               Online    Online

   Resource: rac_udlm            node1               Online    Online
   Resource: rac_udlm            node2               Online    Online

   Resource: rac_svm             node1               Online    Online
   Resource: rac_svm             node2               Online    Online

   Resource: RAC1                node1               Online    Online

   Resource: RAC2                node2               Online    Online

This example shows the status of an Oracle Real Application Clusters configuration that is operating correctly. The example indicates that all resources and resource groups in this configuration are online.