Sun Cluster 3.1 Data Service for Oracle

Sun Cluster HA for Oracle Extension Properties

Use the extension properties in Table 1–2 to create your resources. Use the command line 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 on 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, if the user does not have a listener.ora file under /var/opt/oracle or $ORACLE_HOME/network/admin, then the TNS_ADMIN environment variable should be defined). Also, the definition of each environment variable 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. The only extension properties that you are required to set for the Oracle server are the ORACLE_HOME, ORACLE_SID, Alert_log_file, and Connect_string 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)

A feature that performs the following recovery actions in the event of an interrupted Oracle RDRMS hot backup. 

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

  • Identifies and releases all files left in hot backup mode.

  • Opens the database for use.

You can turn this feature ON and OFF. The default state is OFF (False).  

Default: False

Range: None

Tunable: Any time

Connect_cycle (integer)

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

 

Default: 5

Range: 099,999

Tunable: Any time

Connect_string (string)

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

 

Default: None

Range:Minimum = 1

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 fault monitor uses to probe an Oracle server instance. 

 

Default: 60

Range:0 99,999

Tunable: Any time

Restart_type (string)

When a fault with this resource is detected, a value of RESOURCE_RESTART will ensure only this resource restarts. A value of RESOURCE_GROUP_RESTART will ensure all resources in the resource group restart.

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, if the user does not have a listener.ora file under /var/opt/oracle or $ORACLE_HOME/network/admin, then the TNS_ADMIN environment variable should be defined). Also, the definition of each environment variable 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

Wait_for_online (Boolean)

Wait in the START method until the database is online.

 

Default: True

Range: None

Tunable: Any time