Appendix A Sun Cluster HA for Oracle Extension Properties

The extension properties that you can set for each Sun Cluster HA for Oracle resource type are listed in the following sections:

• SUNW.oracle_server Extension Properties

• SUNW.oracle_listener Extension Properties

See the r_properties(5) man page and the rg_properties(5) man page for details about all of the system-defined properties.

SUNW.oracle_server Extension Properties

Alert_log_file (string)

Specifies the absolute path of the Oracle alert log file. The Oracle software logs alerts in this file. The Oracle server fault monitor scans the alert log file for new alerts at the following times:

• When the server fault monitor is started

• Each time that the server fault monitor queries the health of the server

If an action is defined for a logged alert that the server fault monitor detects, the server fault monitor performs the action in response to the alert.

Preset actions for logged alerts are listed in Appendix B, Preset Actions for Database Management System (DBMS) Errors and Logged Alerts. To change the action that the server fault monitor performs, customize the server fault monitor as explained in Customizing the Sun Cluster HA for Oracle Server Fault Monitor.

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 database user ID and password that the server fault monitor uses to connect to the database.

Specify this property as follows:

userid/password

As part of the setup of Sun Cluster HA for Oracle, you must define the database user ID and password before enabling the server resource and its fault monitor. To use Solaris authentication, type a slash (/) instead of a user ID and password.

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 debug messages from the Oracle server component are logged. When the debug level is increased, more debug messages are written to the log files. These messages are logged to the file /var/opt/SUNWscor/oracle_server/message_log.rs, where rs is the name of the resource that represents the Oracle server component.

Default: 1, which logs syslog messages

Range: 0– 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 timeout value (in seconds) that the server fault monitor uses to probe an Oracle server instance.

Default: 300

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_RESTART

Specifies that only this resource is restarted

RESOURCE_GROUP_RESTART

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

Default: RESOURCE_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

SUNW.oracle_listener Extension Properties

Debug_level (integer)

The level to which debug messages from the Oracle listener component are logged. When the debug level is increased, more debug messages are written to the log files.

Default: 1, which logs syslog messages

Range: 0 – 100

Tunable: Any time

LISTENER_NAME (string)

The name of the Oracle listener. This name must match the corresponding entry in the listener.ora configuration file.

Default: LISTENER

Range: Not applicable

Tunable: When disabled

ORACLE_HOME (string)

The path to the Oracle home directory.

Default: No default defined

Range: Not applicable

Tunable: When disabled

Probe_timeout (integer)

The timeout value in seconds that the fault monitor uses to probe an Oracle listener.

Default: 180

Range: 1– 99,999

Tunable: Any time

Introduced in release: 3.1 4/04

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: Not applicable

Tunable: Any time