Administering Oracle RAC Databases From Oracle Solaris Cluster Software

Administering Oracle RAC databases from Oracle Solaris Cluster software involves using Oracle Solaris Cluster administration tools to modify the states of Oracle Solaris Cluster resources for Oracle RAC database instances. For information about how to create these resources, see Configuring Resources for Oracle RAC Database Instances.

In an Oracle Solaris Cluster configuration, with one exception, there are no general restrictions on the use of the Oracle database software command line interface (CLI) to manage Oracle Clusterware or on the Oracle srvctl command to manage the Oracle database and its services. The exception is that, with Oracle 11g release 2 or 12c, autostart must remain disabled in an Oracle Solaris Cluster configuration. Otherwise, you can use Oracle database software commands as you would in a configuration that does not include Oracle Solaris Cluster. The Oracle Solaris Cluster software detects the changes made by the Oracle database CLI and reacts appropriately.

The software architectures of Oracle 9i, Oracle 10g release 1, and Oracle 10g release 2, 11g, or 12c are different. As a result of these differences, the resources for Oracle RAC database instances that Oracle Solaris Cluster software requires depend on the version of Oracle that you are using. Consequently, the administration of Oracle RAC databases from Oracle Solaris Cluster software also depends on the version of Oracle that you are using.

Note - If you are using Oracle 10g release 1, you cannot administer Oracle RAC databases from Oracle Solaris Cluster software. Instead, use Oracle Clusterware utilities to start and shut down Oracle RAC database instances.

Each cluster, such as the global cluster or a specific zone cluster, constitutes an independent name space for resource groups and resources. Thus, there is no name collision between names in these different name spaces. You register resource types independently for each cluster.

You can administer the resource groups and resources belonging to the global cluster only from the global-cluster voting node. You can administer the resource groups and resources belonging to a zone cluster from that zone cluster. In the global-cluster voting node, you can also administer the resource groups and resources in a zone cluster by using the -Z option to specify the zone cluster. You can set up inter-cluster resource dependencies or affinities only from the global-cluster voting node. The examples in the following sections typically explain the situations when the command is issued in the cluster where the resource group or resource resides.

The effects of changes to the states of Oracle Solaris Cluster resources on Oracle database components are explained in the subsections that follow:

Effects of State Changes to Oracle Solaris Cluster Resources for Oracle 10g Release 2, 11g, or 12c RAC Database Instances
Effects of State Changes to Oracle Solaris Cluster Resources for Oracle 9i RAC Database Instances

Effects of State Changes to Oracle Solaris Cluster Resources for Oracle 10`g` Release 2, 11`g`, or 12`c` RAC Database Instances

In Oracle 10g, 11g, or 12c, Oracle Clusterware manages the startup and shutdown of Oracle database instances, listeners, and other components that are configured in the Oracle Clusterware. Oracle Clusterware is a mandatory component of Oracle 10g, 11g, or 12c. Oracle Clusterware also monitors components that are started by Oracle Clusterware and, if failures are detected, perform actions to recover from failures.

Because Oracle Clusterware manages the startup and shutdown of Oracle database components, these components cannot be stopped and started exclusively under the control of the Oracle Solaris Cluster RGM. Instead, Oracle Clusterware and the RGM interoperate so that when Oracle RAC database instances are started and stopped by Oracle Clusterware, the state of the database instances is propagated to Oracle Solaris Cluster resources.

The following table describes the state changes that occur between Oracle Solaris Cluster resources and Oracle Clusterware resources.

Table 5-2 Propagation of State Changes Between Oracle Solaris Cluster Resources and Oracle Clusterware Resources

Trigger	Initial State		Resulting State
Trigger	Oracle Solaris Cluster Resource	Oracle Clusterware Resource	Oracle Solaris Cluster Resource	Oracle Clusterware Resource
Oracle Solaris Cluster command to take offline a resource	Enabled and online	Enabled and online	Enabled and offline	Enabled and offline
Oracle Clusterware command to stop a resource	Enabled and online	Enabled and online	Enabled and offline	Enabled and offline
Oracle Solaris Cluster command to bring online a resource	Enabled and offline	Enabled and offline	Enabled and online	Enabled and online
Oracle Clusterware command to start a resource	Enabled and offline	Enabled and offline	Enabled and online	Enabled and online
Oracle Solaris Cluster command to disable a resource	Enabled and online	Enabled and online	Disabled and offline	Disabled and offline
Oracle Clusterware command to disable a resource	Enabled and online	Enabled and online	Enabled and online	Disabled and online
Oracle `SQLPLUS` command to shut down the database	Enabled and online	Enabled and online	Enabled and offline	Enabled and offline
Oracle Solaris Cluster command to enable a resource	Disabled and offline	Disabled and offline	Enabled and online or offline	Enabled and online or offline
Oracle Clusterware command to enable a resource	Disabled and offline	Disabled and offline	Disabled and offline	Enabled and offline

The names of the states of Oracle Solaris Cluster resources and Oracle Clusterware resources are identical. However, the meaning of each state name is different for Oracle Solaris Cluster resources and Oracle Clusterware resources. For more information, see the following table.

Table 5-3 Comparisons of States for Oracle Solaris Cluster Resources and Oracle Clusterware Resources

State	Meaning for Oracle Solaris Cluster Resources	Meaning for Oracle Clusterware Resources
Enabled	The resource is available to the Oracle Solaris Cluster RGM for automatic startup, failover, or restart. A resource that is enabled can also be in either the online state or the offline state.	The resource is available to run under Oracle Clusterware for automatic startup, failover, or restart. A resource that is enabled can also be in either the online state or the offline state.
Disabled	The resource is unavailable to the Oracle Solaris Cluster RGM for automatic startup, failover, or restart. A resource that is disabled is also offline.	The resource is unavailable to run under the Oracle Clusterware for automatic startup, failover, or restart. A resource that is disabled can also be in either the online state or the offline state.
Online	The resource is running and providing service.	The resource is running and providing service. A resource that is online must also be enabled.
Offline	The resource is stopped and not providing service.	The resource is stopped and not providing service. A resource that is offline can also be in either the disabled state or the enabled state.

For detailed information about the state of Oracle Solaris Cluster resources, see Resource and Resource Group States and Settings in Oracle Solaris Cluster Concepts Guide.

For detailed information about the state of Oracle Clusterware resources, see your Oracle documentation.

Effects of State Changes to Oracle Solaris Cluster Resources for Oracle 9`i` RAC Database Instances

In Oracle 9i, Oracle database components can be stopped and started exclusively under the control of the Oracle Solaris Cluster RGM. The effects of state changes to Oracle Solaris Cluster resources for Oracle 9i RAC database instances are as follows:

Bringing online a resource for an Oracle 9i RAC database component starts the component on the nodes where the resource is brought online.
Taking offline a resource for an Oracle 9i RAC database component stops the component on the nodes where the resource is taken offline.

Skip Navigation Links
Exit Print View
	Oracle Solaris Cluster Data Service for Oracle Real Application Clusters Guide Oracle Solaris Cluster