SUNW.oracle_server Extension Properties

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 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

Custom_action_file (string)

The absolute path of the file that defines the custom behavior of the HA for Oracle server fault monitor.

Default: “”

Range: None

Tunable: Any time

Dataguard_role (string)

The role of the database. The permitted values for this property are as follows:

NONE

Specifies that no standby database instances configured for the database instance

PRIMARY

Specifies that the database is a primary database instance for which standby database instances are configured

STANDBY

Specifies that the database role is standby

IN_TRANSITION

Specifies that the database is undergoing a role reversal process

Default: NONE

Range: None

Tunable: Any time

Db_unique_name (string)

The unique name of the single-instance Oracle database that is being deployed.

Default: NONE

Range: None

Tunable: Any time

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

Standby_mode (string)

The mode of the standby database. The permitted values for this property are as follows:

LOGICAL

Specifies a logical standby database

PHYSICAL

Specifies a physical standby database

SNAPSHOT

Specifies a snapshot standby database

Default: LOGICAL

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