Skip Navigation Links | |
Exit Print View | |
Oracle Solaris Cluster Data Service for Oracle Real Application Clusters Guide Oracle Solaris Cluster |
1. Installing Support for Oracle RAC
2. Configuring Storage for Oracle Files
3. Registering and Configuring the Resource Groups
4. Enabling Oracle RAC to Run in a Cluster
5. Administering Support for Oracle RAC
6. Troubleshooting Support for Oracle RAC
Sources of Diagnostic Information
Common Problems and Their Solutions
Failure of an Oracle RAC Framework Resource Group
Node Panic During Initialization of Support for Oracle RAC
Failure of the ucmmd Daemon to Start
How to Recover From a Failure of the ucmmd Daemon or a Related Component
Failure of a Multiple-Owner Volume-Manager Framework Resource Group
Node Panic During Initialization of the Multiple-Owner Volume-Manager Framework
Failure of the vucmmd Daemon to Start
How to Recover From a Failure of the vucmmd Daemon or a Related Component
SUNW.qfs Registration Fails Because the Registration File Is Not Found
Node Panic Caused by a Timeout
Failure of a SUNW.rac_framework or SUNW.vucmm_framework Resource to Start
SUNW.rac_framework Failure-to-Start Status Messages
SUNW.vucmm_framework Failure-to-Start Status Messages
How to Recover From the Timing Out of the START Method
7. Modifying an Existing Configuration of Support for Oracle RAC
8. Upgrading Support for Oracle RAC
A. Sample Configurations of This Data Service
B. Preset Actions for DBMS Errors and Logged Alerts
The status of resource groups and resources for Support for Oracle RAC indicates the status of Oracle RAC in your cluster. Use Oracle Solaris 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.
For example:
# clresourcegroup status +
# clresource status -g 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:
The following examples show the status of resource groups and resources for a configuration of 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 Release 2, 11g, or 12c of Oracle RAC. The configuration in this example uses a Sun QFS shared file system on Solaris Volume Manager for Sun Cluster to store Oracle files. The configuration includes a multiple-owner volume-manager framework resource group to contain the volume manager resource.
The resource groups and resources for this configuration are shown in the following table.
|
Example 6-1 Status of a Faulty Oracle RAC Framework Resource Group
This example provides the following status information for an Oracle 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 faulted pclus2 No Online pclus3 No Online pclus4 No Online vucmm-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 Offline pclus2 No Online 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 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 crs_framework-rs pclus1 Offline Offline pclus2 Online Online pclus3 Online Online pclus4 Online Online # clresource status -g vucmm-framework-rg + === Cluster Resources === Resource Name Node Name State Status Message ------------- --------- ----- -------------- vucmm-framework-rs pclus1 Online Online pclus2 Online Online pclus3 Online Online pclus4 Online Online vucmm-svm-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 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 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 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 Offline Offline pclus2 Online Online - Oracle instance UP pclus3 Online Online - Oracle instance UP pclus4 Online Online - Oracle instance UP
Example 6-2 Status of a Faulty Oracle RAC Database Resource Group
This example provides the following status information for an Oracle RAC database resource group that is faulty:
The Oracle 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 vucmm-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 crs_framework-rs pclus1 Online Online pclus2 Online Online pclus3 Online Online pclus4 Online Online # clresource status -g vucmm-framework-rg + === Cluster Resources === Resource Name Node Name State Status Message ------------- --------- ----- -------------- vucmm-framework-rs pclus1 Online Online pclus2 Online Online pclus3 Online Online pclus4 Online Online vucmm-svm-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
Example 6-3 Status of an Operational Oracle RAC Configuration
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.
# 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 vucmm-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 crs_framework-rs pclus1 Online Online pclus2 Online Online pclus3 Online Online pclus4 Online Online # clresource status -g vucmm-framework-rg + === Cluster Resources === Resource Name Node Name State Status Message ------------- --------- ----- -------------- vucmm-framework-rs pclus1 Online Online pclus2 Online Online pclus3 Online Online pclus4 Online Online vucmm-svm-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