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.
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 + |
Specifies the resource group that contains the resources whose status information you are displaying.
For information about options that you can specify to filter the status information that is displayed, see the following man pages:
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 StorageTekTM 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 StorageTek 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 |
# 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.
# 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.
# 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.