Verifying the Status of Sun Cluster Support for Oracle RAC
The status of resource groups and resources for Sun Cluster Support for Oracle RAC indicates the status of Oracle RAC in your cluster. Use Sun Cluster maintenance commands to obtain this status information.
-
To obtain status information for resource groups, use the clresourcegroup(1CL) command.
-
To obtain status information for resources, use the clresource(1CL) command.
How to Verify the Status of Sun Cluster Support for Oracle RAC
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.
-
Become superuser or assume a role that provides solaris.cluster.read RBAC authorization.
-
Display status information for the Sun Cluster objects in which you are interested.
For example:
-
To display status information for all resource groups in your cluster, type the following command:
# clresourcegroup status +
-
To display status information for all resources in a resource group, type the following command:
# clresource status -g resource-group +
- resource-group
-
Specifies the resource group that contains the resources whose status information you are displaying.
-
See Also
For information about options that you can specify to filter the status information that is displayed, see the following man pages:
Examples of the Status of Sun Cluster Support for Oracle RAC
The following examples show the status of resource groups and resources for a configuration of Sun Cluster Support for Oracle RAC on a four-node cluster. Each node is a machine that uses the SPARC® processor.
The cluster in this example is running version 10g R2 of Oracle RAC. The configuration in this example uses Sun StorEdgeTM QFS shared file system on Solaris Volume Manager for Sun Cluster to store Oracle files.
The resource groups and resources for this configuration are shown in the following table.
|
Resource Group |
Purpose |
Resource Group Contents |
|
|---|---|---|---|
|
Resource Type |
Resource Instance Name |
||
|
rac-framework-rg |
RAC framework resource group |
SUNW.rac_framework |
rac-framework-rs |
|
SUNW.rac_udlm |
rac-udlm-rs |
||
|
SUNW.rac_svm |
rac-svm-rs |
||
|
SUNW.crs_framework |
crs_framework-rs |
||
|
scaldg-rg |
Resource group for scalable device-group resources |
SUNW.ScalDeviceGroup |
scaloradg-rs |
|
qfsmds-rg |
Resource group for Sun StorEdge QFS metadata server resources |
SUNW.qfs |
qfs-db_qfs-OraHome-rs qfs-db_qfs-OraData-rs |
|
scalmnt-rg |
Resource group for scalable file-system mount-point resources |
SUNW.ScalMountPoint |
scal-db_qfs-OraHome-rs scal-db_qfs-OraData-rs |
|
rac_server_proxy-rg |
RAC database resource group |
SUNW.scalable_rac_server_proxy |
rac_server_proxy-rs |
Example 5–1 Status of a Faulty RAC Framework Resource Group
# clresourcegroup status +
=== Cluster Resource Groups ===
Group Name Node Name Suspended Status
---------- --------- --------- ------
rac-framework-rg pclus1 No Online faulted
pclus2 No Online
pclus3 No Online
pclus4 No Online
scaldg-rg pclus1 No Pending online blocked
pclus2 No Online
pclus3 No Online
pclus4 No Online
qfsmds-rg pclus1 No Offline
pclus2 No Online
pclus3 No Offline
pclus4 No Offline
scalmnt-rg pclus1 No Pending online blocked
pclus2 No Online
pclus3 No Online
pclus4 No Online
rac_server_proxy-rg pclus1 No Pending online blocked
pclus2 No Online
pclus3 No Online
pclus4 No Online
# clresource status -g rac-framework-rg +
=== Cluster Resources ===
Resource Name Node Name State Status Message
------------- --------- ----- --------------
rac-framework-rs pclus1 Start failed Faulted - Error in previous reconfiguration.
pclus2 Online Online
pclus3 Online Online
pclus4 Online Online
rac-udlm-rs pclus1 Offline Offline
pclus2 Online Online
pclus3 Online Online
pclus4 Online Online
rac-svm-rs pclus1 Offline Offline
pclus2 Online Online
pclus3 Online Online
pclus4 Online Online
crs_framework-rs pclus1 Offline Offline
pclus2 Online Online
pclus3 Online Online
pclus4 Online Online
# clresource status -g scaldg-rg +
=== Cluster Resources ===
Resource Name Node Name State Status Message
------------- --------- ----- --------------
scaloradg-rs pclus1 Offline Offline
pclus2 Online Online - Diskgroup online
pclus3 Online Online - Diskgroup online
pclus4 Online Online - Diskgroup online
# clresource status -g qfsmds-rg +
=== Cluster Resources ===
Resource Name Node Name State Status Message
------------- --------- ----- --------------
qfs-db_qfs-OraHome-rs pclus1 Offline Offline
pclus2 Online Online - Service is online.
pclus3 Offline Offline
pclus4 Offline Offline
qfs-db_qfs-OraData-rs pclus1 Offline Offline
pclus2 Online Online - Service is online.
pclus3 Offline Offline
pclus4 Offline Offline
# clresource status -g scalmnt-rg +
=== Cluster Resources ===
Resource Name Node Name State Status Message
------------- --------- ----- --------------
scal-db_qfs-OraHome-rs pclus1 Offline Offline
pclus2 Online Online
pclus3 Online Online
pclus4 Online Online
scal-db_qfs-OraData-rs pclus1 Offline Offline
pclus2 Online Online
pclus3 Online Online
pclus4 Online Online
# clresource status -g rac_server_proxy-rg +
=== Cluster Resources ===
Resource Name Node Name State Status Message
------------- --------- ----- --------------
rac_server_proxy-rs pclus1 Offline Offline
pclus2 Online Online - Oracle instance UP
pclus3 Online Online - Oracle instance UP
pclus4 Online Online - Oracle instance UP
|
This example provides the following status information for a RAC framework resource group that is faulty.
-
A reconfiguration error has prevented the rac_framework resource from starting on cluster node pclus1.
-
The effects of this reconfiguration error on resource groups and other resources are as follows:
-
The rac-framework-rg resource group is offline and in the start failed state on cluster node pclus1.
-
The rac_udlm resource, the rac_svm resource, and the crs_framework resource are offline on cluster node pclus1.
-
All other multi-master resource groups and the resources that the groups contain are offline on cluster node pclus1.
-
All failover resource groups have failed over from cluster node pclus1 to a secondary node.
-
-
All multi-master resource groups and the resources that the groups contain are online on the remaining nodes.
Example 5–2 Status of a Faulty RAC Database Resource Group
# clresourcegroup status +
=== Cluster Resource Groups ===
Group Name Node Name Suspended Status
---------- --------- --------- ------
rac-framework-rg pclus1 No Online
pclus2 No Online
pclus3 No Online
pclus4 No Online
scaldg-rg pclus1 No Online
pclus2 No Online
pclus3 No Online
pclus4 No Online
qfsmds-rg pclus1 No Online
pclus2 No Offline
pclus3 No Offline
pclus4 No Offline
scalmnt-rg pclus1 No Online
pclus2 No Online
pclus3 No Online
pclus4 No Online
rac_server_proxy-rg pclus1 No Online faulted
pclus2 No Online
pclus3 No Online
pclus4 No Online
# clresource status -g rac_server_proxy-rg +
=== Cluster Resources ===
Resource Name Node Name State Status Message
------------- --------- ----- --------------
rac_server_proxy-rs pclus1 Offline Offline - Oracle instance DOWN
pclus2 Online Online - Oracle instance UP
pclus3 Online Online - Oracle instance UP
pclus4 Online Online - Oracle instance UP
# clresource status -g rac-framework-rg +
=== Cluster Resources ===
Resource Name Node Name State Status Message
------------- --------- ----- --------------
rac-framework-rs pclus1 Online Online
pclus2 Online Online
pclus3 Online Online
pclus4 Online Online
rac-udlm-rs pclus1 Online Online
pclus2 Online Online
pclus3 Online Online
pclus4 Online Online
rac-svm-rs pclus1 Online Online
pclus2 Online Online
pclus3 Online Online
pclus4 Online Online
crs_framework-rs pclus1 Online Online
pclus2 Online Online
pclus3 Online Online
pclus4 Online Online
# clresource status -g scaldg-rg +
=== Cluster Resources ===
Resource Name Node Name State Status Message
------------- --------- ----- --------------
scaloradg-rs pclus1 Online Online - Diskgroup online
pclus2 Online Online - Diskgroup online
pclus3 Online Online - Diskgroup online
pclus4 Online Online - Diskgroup online
# clresource status -g qfsmds-rg +
=== Cluster Resources ===
Resource Name Node Name State Status Message
------------- --------- ----- --------------
qfs-db_qfs-OraHome-rs pclus1 Online Online - Service is online.
pclus2 Offline Offline
pclus3 Offline Offline
pclus4 Offline Offline
qfs-db_qfs-OraData-rs pclus1 Online Online - Service is online.
pclus2 Offline Offline
pclus3 Offline Offline
pclus4 Offline Offline
# clresource status -g scalmnt-rg +
=== Cluster Resources ===
Resource Name Node Name State Status Message
------------- --------- ----- --------------
scal-db_qfs-OraHome-rs pclus1 Online Online
pclus2 Online Online
pclus3 Online Online
pclus4 Online Online
scal-db_qfs-OraData-rs pclus1 Online Online
pclus2 Online Online
pclus3 Online Online
pclus4 Online Online
|
This example provides the following status information for a RAC database resource group that is faulty:
-
The RAC database on pclus1 has failed to start. The effects of this failure are as follows:
-
The rac_server_proxy-rg resource group is online, but faulted on node pclus1.
-
The rac_server_proxy-rs resource is offline on node pclus1.
-
-
All other multi-master resource groups and the resources that the groups contain are online on all nodes.
-
All failover resource groups and the resources that the groups contain are online on their primary nodes and offline on the remaining nodes.
Example 5–3 Status of an Operational Oracle RAC Configuration
# clresourcegroup status +
=== Cluster Resource Groups ===
Group Name Node Name Suspended Status
---------- --------- --------- ------
rac-framework-rg pclus1 No Online
pclus2 No Online
pclus3 No Online
pclus4 No Online
scaldg-rg pclus1 No Online
pclus2 No Online
pclus3 No Online
pclus4 No Online
qfsmds-rg pclus1 No Online
pclus2 No Offline
pclus3 No Offline
pclus4 No Offline
scalmnt-rg pclus1 No Online
pclus2 No Online
pclus3 No Online
pclus4 No Online
rac_server_proxy-rg pclus1 No Online
pclus2 No Online
pclus3 No Online
pclus4 No Online
# clresource status -g rac-framework-rg +
=== Cluster Resources ===
Resource Name Node Name State Status Message
------------- --------- ----- --------------
rac-framework-rs pclus1 Online Online
pclus2 Online Online
pclus3 Online Online
pclus4 Online Online
rac-udlm-rs pclus1 Online Online
pclus2 Online Online
pclus3 Online Online
pclus4 Online Online
rac-svm-rs pclus1 Online Online
pclus2 Online Online
pclus3 Online Online
pclus4 Online Online
crs_framework-rs pclus1 Online Online
pclus2 Online Online
pclus3 Online Online
pclus4 Online Online
# clresource status -g scaldg-rg +
=== Cluster Resources ===
Resource Name Node Name State Status Message
------------- --------- ----- --------------
scaloradg-rs pclus1 Online Online - Diskgroup online
pclus2 Online Online - Diskgroup online
pclus3 Online Online - Diskgroup online
pclus4 Online Online - Diskgroup online
# clresource status -g qfsmds-rg +
=== Cluster Resources ===
Resource Name Node Name State Status Message
------------- --------- ----- --------------
qfs-db_qfs-OraHome-rs pclus1 Online Online - Service is online.
pclus2 Offline Offline
pclus3 Offline Offline
pclus4 Offline Offline
qfs-db_qfs-OraData-rs pclus1 Online Online - Service is online.
pclus2 Offline Offline
pclus3 Offline Offline
pclus4 Offline Offline
# clresource status -g scalmnt-rg +
=== Cluster Resources ===
Resource Name Node Name State Status Message
------------- --------- ----- --------------
scal-db_qfs-OraHome-rs pclus1 Online Online
pclus2 Online Online
pclus3 Online Online
pclus4 Online Online
scal-db_qfs-OraData-rs pclus1 Online Online
pclus2 Online Online
pclus3 Online Online
pclus4 Online Online
# clresource status -g rac_server_proxy-rg +
=== Cluster Resources ===
Resource Name Node Name State Status Message
------------- --------- ----- --------------
rac_server_proxy-rs pclus1 Online Online - Oracle instance UP
pclus2 Online Online - Oracle instance UP
pclus3 Online Online - Oracle instance UP
pclus4 Online Online - Oracle instance UP
|
This example shows the status of an Oracle RAC configuration that is operating correctly. The example indicates that the status of resource groups and resources in this configuration is as follows:
-
All multi-master resource groups and the resources that the groups contain are online on all nodes.
-
All failover resource groups and the resources that the groups contain are online on their primary nodes and offline on the remaining nodes.
- © 2010, Oracle Corporation and/or its affiliates