Sun Cluster Data Service for Oracle RAC Guide for Solaris OS

SUNW.scalable_rac_server Extension Properties

alert_log_file

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

  • When the RAC server fault monitor is started

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

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

Preset actions for logged alerts are listed in Appendix B, Preset Actions for DBMS Errors and Logged Alerts. To change the action that the RAC server fault monitor performs, customize the server fault monitor as explained in Customizing the Oracle 9i RAC Server Fault Monitor.

You can specify a different value of the alert_log_file extension property for each node that can master the resource.

Data Type: String

Range: Not applicable

Default: NULL

Tunable: Any time

connect_cycle

This property specifies the number of fault monitor probe cycles that are performed before the fault monitor disconnects from the database.

You can specify a different value of the connect_cycle extension property for each node that can master the resource.

Data Type: Integer

Range: 0–99999

Default: 5

Tunable: Any time

connect_string

This property specifies the Oracle database user ID and password that the fault monitor uses to connect to the Oracle database. This property is specified as follows:

userid/password
userid

Specifies the Oracle database user ID that the fault monitor uses to connect to the Oracle database.

password

Specifies the password that is set for the Oracle database user userid.

The system administrator must define the database user ID and password for the fault monitor during the setup of Oracle RAC. To use Solaris authentication, type a slash (/) instead of a user ID and password.

You can specify a different value of the connect_string extension property for each node that can master the resource.

Data Type: String

Range: Not applicable

Default: NULL

Tunable: Any time

custom_action_file

This property specifies the absolute path of the file that defines the custom behavior of the Oracle RAC server fault monitor.

You can specify a different value of the custom_action_file extension property for each node that can master the resource.

Data Type: String

Range: Not applicable

Default: Empty string

Tunable: Any time

debug_level

This property indicates the level to which debug messages from the monitor for the Oracle RAC proxy server are logged. When the debug level is increased, more debug messages are written to the log files.

The messages are logged to files in the directory /var/opt/SUNWscor/oracle_server/proxyrs. Messages for server-side components and client-side components of the proxy server resource are written to separate files:

  • Messages for server-side components are written to the file message_log.rs.

  • Messages for client-side components are written to the file message_log.client.rs.

In these file names and directory names, rs is the name of the resource that represents the Oracle RAC server component.

You can specify a different value of the debug_level extension property for each node that can master the resource.

Data Type: Integer

Range: 0–100

Default: 1, which logs syslog messages

Tunable: Any time

oracle_home

This property specifies the full path to the Oracle home directory. The Oracle home directory contains the binary files, log files, and parameter files for the Oracle software.

Data Type: String

Range: Not applicable

Default: No default defined

Tunable: When disabled

oracle_sid

This property specifies the Oracle System Identifier (SID). The Oracle SID uniquely identifies the Oracle Real Application Cluster database instance on the node where the instance is running.

You must specify a different value of the oracle_sid extension property for each node that can master the resource. The value for each node must correctly identify the instance that is running on the node.

Data Type: String

Range: Not applicable

Default: NULL

Tunable: When disabled

parameter_file

This property specifies the full path to the Oracle parameter file. This file contains parameters that are to be set when the Oracle database is started. This property is optional. If you do not set this property, the default parameter file that is specified by Oracle is used, namely: oracle-home/dbs/initoracle-sid.ora.

oracle-home

Specifies the Oracle home directory.

oracle-sid

Specifies the Oracle system identifier of the database instance for which the file is to be used.

You can specify a different value of the parameter_file extension property for each node that can master the resource.

Data Type: String

Range: Not applicable

Default: No default defined

Tunable: Any time

probe_timeout

This property specifies the timeout value, in seconds, that the fault monitor uses when checking the status of an Oracle RAC server.

Data Type: Integer

Range: 1–99999

Default: 300

Tunable: Any time

user_env

This property specifies the name of the file that contains the environment variables that are to be set before the database starts up or shuts down. You must define all environment variables whose values differ from Oracle defaults in this file.

For example, a user's listener.ora file might not be located under the /var/opt/oracle directory or the oracle-home/network/admin directory. In this situation, the TNS_ADMIN environment variable must 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 specify a different value of the user_env extension property for each node that can master the resource.

Data Type: String

Range: Not applicable

Default: No default defined

Tunable: Any time

wait_for_online

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.

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.

Data Type: Boolean

Range: Not applicable

Default: True

Tunable: Any time