Sun Cluster Data Service for Oracle RAC Guide for Solaris OS

Effects of State Changes to Sun Cluster Resources for Oracle 10g R2 RAC Database Instances

In Oracle 10g, the Oracle CRS manage the startup and shutdown of Oracle database instances, listeners, and other components that are configured in the CRS. Oracle CRS are a mandatory component of Oracle 10g. CRS also monitor components that are started by CRS and, if failures are detected, perform actions to recover from failures.

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

Table 4–2 Propagation of State Changes Between Sun Cluster Resources and Oracle CRS Resources

Trigger 

Initial State 

Resulting State 

Sun Cluster Resource 

Oracle CRS Resource  

Sun Cluster Resource 

Oracle CRS Resource  

Sun Cluster command to take offline a resource 

Enabled and online 

Enabled and online 

Enabled and offline 

Enabled and offline 

Oracle CRS command to stop a resource 

Enabled and online 

Enabled and online 

Enabled and offline 

Enabled and offline 

Sun Cluster command to bring online a resource 

Enabled and offline 

Enabled and offline 

Enabled and online 

Enabled and online 

Oracle CRS command to start a resource 

Enabled and offline 

Enabled and offline 

Enabled and online 

Enabled and online 

Sun Cluster command to disable a resource 

Enabled and online 

Enabled and online 

Disabled and offline 

Disabled and offline 

Oracle CRS 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 

Sun Cluster command to enable a resource 

Disabled and offline 

Disabled and offline 

Enabled and online or offline 

Enabled and online or offline 

Oracle CRS command to enable a resource 

Disabled and offline 

Disabled and offline 

Disabled and offline 

Enabled and offline 

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

Table 4–3 Comparisons of States for Sun Cluster Resources and Oracle CRS Resources

State 

Meaning for Sun Cluster Resources 

Meaning for Oracle CRS Resources 

Enabled 

The resource is available to the Sun 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 CRS 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 Sun 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 CRS 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 Sun Cluster resources, see Resource and Resource Group States and Settings in Sun Cluster Concepts Guide for Solaris OS.

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