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.
-- 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.
A configuration error has prevented the rac_framework resource on cluster node node1 from starting.
The effects of this configuration error on other entities on cluster node node1 are as follows:
The rac-framework-rg resource group is online, but faulted.
The rac_udlm resource and the rac_svm resource are offline.
The rac-framework-rg resource group and all resources on cluster node node2 are online.
-- 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:
The Real Application Clusters database on node2 has failed to start. As a result of this failure, the RAC2-rg resource group and the RAC2 resource are online, but faulted
All other resource groups and resources are online.
-- 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.