test

Sun Cluster 3.1 Data Service for Oracle Guide

Sun Cluster HA for Oracle Extension Properties

Use the extension properties in Table 1–2 to create your resources. Use the command scrgadm -x parameter=value to configure extension properties when you create your resource. Use the procedure in “Administering Data Service Resources” in Sun Cluster 3.1 Data Service Planning and Administration Guide to configure the extension properties if you have already created your resources. You can update some extension properties dynamically. You can update others, however, only when you create or disable a resource. The Tunable entries indicate when you can update each property. See “Standard Properties” in Sun Cluster 3.1 Data Service Planning and Administration Guide for details about all Sun Cluster properties.

Table 1–2 Sun Cluster HA for Oracle Listener Extension Properties

Name/Data Type 

Description 

LISTENER_NAME (string)

The name of the Oracle listener. 

 

Default: LISTENER

Range: None

Tunable: When disabled

 

ORACLE_HOME (string)

The path to the Oracle home directory. 

 

Default: None

Range: Minimum = 1

Tunable: When disabled

User_env (string)

A file that contains environment variables to be set before listener startup and shutdown. Those 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=VARIABLE_VALUE. Each of these environment variables must be specified, one per line in the environment file.

 

Default: ““

Range: None

Tunable: Any time

Table 1–3 describes the extension properties that you can set for the Oracle server. For the Oracle server, you are required to set only the following extension properties:

Table 1–3 Sun Cluster HA for Oracle Server Extension Properties

Name/Data Type 

Description 

Alert_log_file (string)

Oracle alert log file. 

 

Default: None

Range: Minimum = 1

Tunable: Any time

Auto_End_Bkp (Boolean)

Specifies whether the following recovery actions are performed if an Oracle relational database management system (RDBMS) hot backup is interrupted.

  • Recognizing when a database fails to open because of files that remain in hot backup mode. This verification process occurs when Sun Cluster HA for Oracle starts.

  • Identifying and releasing all files that remain in hot backup mode.

  • Opening the database for use.

The permitted values for this property are as follows:  

  • False – Specifies that the recovery actions are not performed. This value is the default.

  • True – Specifies that the recovery actions are performed.

Default: False

Range: None

Tunable: Any time

Connect_cycle (integer)

The number of probe cycles that the server fault monitor performs before disconnecting from the database. 

 

Default: 5

Range: 0 – 99,999

Tunable: Any time

Connect_string (string)

The Oracle user and password that the server fault monitor uses to connect to the database. 

 

Default: None

Range: Minimum = 1

Tunable: Any time

Custom_action_file (string)

The absolute path of the file that defines the custom behavior of the Sun Cluster HA for Oracle server fault monitor. 

 

Default: ““

Range: None

Tunable: Any time

Introduced in release: 3.1 10/03

Debug_level (integer)

The level to which Sun Cluster HA for Oracle debug messages are logged. 

 

Default: 1

Range: 1– 100

Tunable: Any time

ORACLE_HOME (string)

The path to the Oracle home directory. 

 

Default: None

Range: Minimum = 1

Tunable: When disabled

ORACLE_SID (string)

The Oracle system identifier. 

 

Default: None

Range: Minimum = 1

Tunable: When disabled

Parameter_file (string)

The Oracle parameter file. If the Oracle parameter file is not specified, this property defaults to Oracle's default. 

 

Default: ““

Range: Minimum = 0

Tunable: Any time

Probe_timeout (integer)

The time-out value (in seconds) that the server fault monitor uses to probe an Oracle server instance. 

 

Default: 60

Range: 0 – 99,999

Tunable: Any time

Restart_type (string)

Specifies the entity that the server fault monitor restarts when the response to a fault is restart. The permitted values for this property are as follows: 

  • RESOURCE_GROUP_RESTART – Specifies that all resources in the resource group that contains this resource are restarted

  • RESOURCE_RESTART – Specifies that only this resource is restarted

Default: RESOURCE_GROUP_RESTART

Range: None

Tunable: Any time

User_env (string)

A file that contains environment variables to be set before server startup and shutdown. Those 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=VARIABLE_VALUE. Each of these environment variables must be specified, one per line in the environment file.

 

Default: NULL

Range: None

Tunable: Any time

Wait_for_online (Boolean)

Wait in the START method until the database is online.

 

Default: True

Range: None

Tunable: Any time