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
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
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
Specifies the Oracle database user ID that the fault monitor uses to connect to the Oracle database.
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
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
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
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
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
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.
Specifies the Oracle home directory.
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
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
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
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:
Specifies that the START method of the Oracle RAC server resource waits for the database to be online before the START method exits.
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