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 configuration in this example uses a StorageTek 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.
|
This example provides the following status information for a Support for 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_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
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 7 Status of a Faulty Support for Oracle RAC Database Resource Group
This example provides the following status information for a Support for Oracle RAC database resource group that is faulty:
The Support for 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
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 8 Status of an Operational Support for Oracle RAC Configuration
This example shows the status of a Support for 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
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