SUNW.oracle_rac_server

, oracle_rac_server

- legacy resource type implementation for the Oracle Real Application Clusters (RAC) server managed by Oracle Solaris Cluster

Description

The SUNW.oracle_rac_server resource type represents the Oracle RAC server in a Sun Cluster 3.2 configuration. Each instance of the Oracle RAC server is represented by a single SUNW.oracle_rac_server resource, and is uniquely identified by its Oracle_Sid property.

Each resource belongs to a failover resource group. The resource group is restricted to run on only one node. Therefore, the Oracle RAC server resource in the resource group is also restricted to run on only one node. This restriction is enforced by specifying a single node in the node list when the resource group is created.

The resource group manager (RGM) performs only automated startup and shutdown of Oracle RAC server instances. The RGM does not restart or fail over Oracle RAC server instances. The RGM monitors Oracle RAC server resources only to enable the status of these resources to be obtained by using Oracle Solaris Cluster utilities.

Oracle RAC server instances should be started only after the RAC framework is enabled on the cluster node. To ensure that this requirement is met, configure Oracle RAC server resources and the RAC framework as follows:

• Create a strong positive affinity between the Oracle RAC server resource groups and the RAC framework resource group.

• Create a dependency between the Oracle RAC server resource and the RAC framework resource.

Standard properties and extension properties that are defined for the SUNW.oracle_rac_server resource type are described in the subsections that follow. To set these properties for an instance of the SUNW.oracle_rac_server resource type, use the scrgadm(1M) command.

Standard Properties

The standard resource property Failover is set for all failover resource types.

Standard resource properties are overridden for this resource type as follows:

Failover_mode

Default: NONE

Tunable: Any time.

Thorough_probe_interval

Minimum: 1

Maximum: 2592000

Default: 30

Tunable: Any time.

For a description of standard resource properties, see the r_properties(5) man page.

Extension Properties

Auto_End_Bkp

Type Boolean; defaults to False. This property specifies whether the Oracle RAC server resource automatically recovers the database if an Oracle relational database management system (RDBMS) hot backup is interrupted. When a hot backup is interrupted, the database fails to open because of files that remain in hot backup mode. During the startup of the Oracle RAC server resource, the resource tests for the interruption of a hot backup by testing for an occurrence the following RDBMS error:

ORA-01113 file file needs media recovery

To recover the database automatically, the Oracle RAC server resource performs the following actions:

• Releasing all files that remain in hot backup mode. The sys.v$backup view indicates which files remain in hot backup mode.

• Opening the database for use.

The permitted values for this property are as follows:

False

Specifies that the Oracle RAC server resource does not automatically recover the database. If a hot backup is interrupted, you must recover the database manually. In this situation, the status of the Oracle RAC server resource is set to FAULTED. The default value of this property is False.

True

Specifies that the Oracle RAC server resource automatically recovers the database.

You can modify this property at any time.

Debug_level

Type integer; defaults to 1, which logs syslog messages. Maximum value is 100. This property indicates the level to which debug messages from the Oracle RAC server component are logged. When the debug level is increased, more debug messages are written to the log files. You can modify this property at any time.

Oracle_Home

Type string. This property is set to the path to the Oracle home directory. The Oracle home directory contains the binary files, log files, and parameter files for the Oracle software. You can modify this property only when the resource is disabled.

Oracle_Sid

Type string. This property is set to the Oracle system identifier. This identifier is the name of the Oracle database instance. You can modify this property only when the resource is disabled.

Parameter_file

Type string. This property is set to the Oracle parameter file, which starts the database. If this property is not set, it defaults to NULL. When this property is NULL, the default Oracle mechanism is used to locate the parameter file. You can modify this property at any time.

User_env

Type string; defaults to NULL. This property is set to the name of the file that contains the environment variables to be set before database startup or shutdown. All environment variables that have values that differ from Oracle defaults must be defined in this file.

For example, a user's listener.ora file might not reside under the /var/opt/oracle directory or the $ORACLE_HOME/network/admin directory. In this situation, the TNS_ADMIN environment variable should be defined.

The definition of each environment variable that is defined must follow the format variable-name=value. Each definition must start on a new line in the environment file.

You can modify this property at any time.

Wait_for_online

Type Boolean; defaults to True. This property specifies whether the START method of the Oracle RAC server resource waits for the database to be online before the START method exits. The permitted values for this property are as follows:

True

Specifies that the START method of the Oracle RAC server resource waits for the database to be online before the START method exits. The default value of this property is True.

False

Specifies that the START method runs the commands to start the database but does not wait for the database to come online before the START method exits.

You can modify this property at any time.

Examples

Example 1 Creating oracle_rac_server Resources and Resource Groups

The following example creates two oracle_rac_server resources and two oracle_rac_server resource groups on a two-node cluster. One oracle_rac_server resource group is created for each oracle_rac_server resource. Each resource and its corresponding resource group are named as shown in the following table.

The example assumes that a SUNW.rac_framework resource group named rac-framework-rg has been created. The example also assumes that the constituent resources of this resource group have been created. These resources are instances of resource types as shown in the following table.

example# scrgadm -a -t SUNW.oracle_rac_server
example# scrgadm -a -g RAC1-rg -h node1 \
         -y RG_AFFINITIES=++rac-framework-rg
example# scrgadm -a -g RAC2-rg -h node2 \
         -y RG_AFFINITIES=++rac-framework-rg
example# scrgadm -a -j RAC1-rs -g RAC1-rg \
         -t SUNW.oracle_rac_server \
         -y RESOURCE_DEPENDENCIES=rac_framework \
         -x ORACLE_SID=RAC1 \
         -x ORACLE_HOME=/oracle
example# scrgadm -a -j RAC2-rs -g  RAC2-rg \
         -t SUNW.oracle_rac_server \
         -y RESOURCE_DEPENDENCIES=rac_framework \
         -x ORACLE_SID=RAC2 \
         -x ORACLE_HOME=/oracle

The preceding commands create two oracle_rac_server resources and two oracle_rac_server resource groups on a two-node cluster by performing the following operations:

1. Registering the SUNW.oracle_rac_server resource type

2. Creating the RAC1-rg resource group for node node1

3. Creating the RAC2-rg resource group for node node2

4. Creating the RAC1-rs resource in the RAC1-rg resource group for node node1

5. Creating the RAC2-rs resource in the RAC2-rg resource group for node node2

Attributes

See attributes(5) for descriptions of the following attributes:

See Also

scrgadm(1M), scswitch(1M), attributes(5), SUNW.oracle_listener(5), SUNW.rac_cvm(5), SUNW.rac_framework(5), SUNW.rac_svm(5), SUNW.rac_udlm(5), SUNW.scalable_rac_server(5)

Oracle Solaris Cluster Data Service for Oracle Real Application Clusters Guide, Oracle Solaris Cluster Data Services Planning and Administration Guide