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
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
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
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
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
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
The path to the Oracle home directory.
Default: None
Range: Minimum = 1
Tunable: When disabled
The Oracle system identifier.
Default: None
Range: Minimum = 1
Tunable: When disabled
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
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
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:
Specifies that only this resource is restarted
Specifies that all resources in the resource group that contains this resource are restarted
Default: RESOURCE_RESTART
Range: None
Tunable: Any time
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 in the START method until the database is online.
Default: True
Range: None
Tunable: Any time