This section describes the Sun Cluster HA for Oracle extension properties. Typically, you use the command line scrgadm -x parameter=value to configure the extension properties when you create the Oracle server and listener resources. You can also use the procedures described in Chapter 13, Administering Data Service Resources to configure them later. See Appendix A, Standard Properties for details on all of the Sun Cluster properties.
Table 2-2 describes the extension properties that you can set for the Oracle listener resource. The required extension property for creating an Oracle listener resource is the ORACLE_HOME property. You can update some extension properties dynamically. You can update others, however, only when you create the resource. The Tunable entries indicate when you can update each property.
Table 2-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 2-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 2-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 |
Connect_cycle (integer) |
The number of fault monitor probe cycles before disconnecting from the database.
Default: 5 Range: 0 - 99,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
|
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
|