Appendix A Sun Cluster Support for Oracle Real Application Clusters Extension Properties

The extension properties that you can set for each Sun Cluster Support for Oracle Real Application Clusters resource type are listed in the following sections:

• SPARC: SUNW.rac_udlm Extension Properties

• SUNW.rac_svm Extension Properties

• SPARC: SUNW.rac_cvm Extension Properties

• SUNW.rac_hwraid Extension Properties

• SUNW.oracle_rac_server Extension Properties

• SUNW.oracle_listener Extension Properties

The SUNW.rac_framework resource type has no extension properties.

You can update some extension properties dynamically. You can update others, however, only when you create or disable a resource. For more information, see How to Modify an Extension Property That Is Tunable Only When a Resource Is Disabled. The Tunable entries indicate when you can update each property.

See the r_properties(5) man page and the rg_properties(5) man page for details about all of the system-defined properties.

SPARC: SUNW.rac_udlm Extension Properties

Failfastmode (enum)

The failfast mode of the node on which the UNIX Distributed Lock Manager (Oracle UDLM) is running. The failfast mode determines the action that is performed in response to a critical problem with this node. The possible values of this property are as follows:

• off – Failfast mode is disabled.

• panic – The node is forced to panic.

Default: panic

Tunable: Any time

Num_ports (integer)

The number of communications ports that the Oracle UDLM uses.

Default: 32

Range: 16 – 64

Tunable: When disabled

Oracle_config_file (string)

The configuration file that the Oracle distributed lock manager (DLM) uses. This file must already exist. The file is installed when the Oracle software is installed. For more information, see the documentation for the Oracle software.

Default: /etc/opt/SUNWcluster/conf/udlm.conf

Tunable: Any time

Port (integer)

The communications port number that the Oracle UDLM uses.

Default: 6000

Range: 1024 – 65500

Tunable: When disabled

SchedclassSchedclass (enum)

The scheduling class of the Oracle UDLM that is passed to the priocntl(1) command. The possible values of this property are as follows:

• RT – Real-time

• TS – Time-sharing

• IA – Interactive

Default: RT

Tunable: When disabled

Schedpriority (integer)

This property specifies the scheduling priority of the Oracle UDLM that is passed to the priocntl command.

Default: 11

Range: 0 – 59

Tunable: When disabled

Udlm_abort_step_timeout (integer)

The timeout (in seconds) for the abort step of an Oracle UDLM reconfiguration.

Default: 325

Range: 30 – 99999 seconds

Tunable: Any time

Udlm_start_step_timeout (integer)

The timeout (in seconds) for the start step of an Oracle UDLM reconfiguration.

Default: 100

Range: 30 – 99999 seconds

Tunable: Any time

Udlm_step1_timeout (integer)

The timeout (in seconds) for step 1 of an Oracle UDLM reconfiguration.

Default: 100

Range: 30 – 99999 seconds

Tunable: Any time

Udlm_step2_timeout (integer)

The timeout (in seconds) for step 2 of an Oracle UDLM reconfiguration.

Default: 100

Range: 30 – 99999 seconds

Tunable: Any time

Udlm_step3_timeout (integer)

The timeout (in seconds) for step 3 of an Oracle UDLM reconfiguration.

Default: 100

Range: 30 – 99999 seconds

Tunable: Any time

Udlm_step4_timeout (integer)

The timeout (in seconds) for step 4 of an Oracle UDLM reconfiguration.

Default: 100

Range: 30 – 99999 seconds

Tunable: Any time

Udlm_step5_timeout (integer)

The timeout (in seconds) for step 5 of an Oracle UDLM reconfiguration.

Default: 100

Range: 30 – 99999 seconds

Tunable: Any time

SUNW.rac_svm Extension Properties

Debug_level (integer)

The level to which debug messages from the Solaris Volume Manager for Sun Cluster component are logged. When the debug level is increased, more messages are written to the log files during reconfiguration.

Default: 1, which logs syslog messages

Range: 0 – 10

Tunable: Any time

Reservation_timeout (integer)

The timeout (in seconds) for the reservation step of a reconfiguration of the Solaris Volume Manager for Sun Cluster module of Sun Cluster Support for Oracle Real Application Clusters.

Default: 325

Range: 100 – 99999 seconds

Tunable: Any time

Svm_abort_step_timeout (integer)

The timeout (in seconds) for the abort step of a reconfiguration of the Solaris Volume Manager for Sun Cluster module of Sun Cluster Support for Oracle Real Application Clusters.

Default: 120

Range: 30 – 99999 seconds

Tunable: Any time

Svm_return_step_timeout (integer)

The timeout (in seconds) for the return step of a reconfiguration of the Solaris Volume Manager for Sun Cluster module of Sun Cluster Support for Oracle Real Application Clusters.

Default: 120

Range: 30 – 99999 seconds

Tunable: Any time

Svm_start_step_timeout (integer)

The timeout (in seconds) for the start step of a reconfiguration of the Solaris Volume Manager for Sun Cluster module of Sun Cluster Support for Oracle Real Application Clusters.

Default: 120

Range: 30 – 99999 seconds

Tunable: Any time

Svm_step1_timeout (integer)

The timeout (in seconds) for step 1 of a reconfiguration of the Solaris Volume Manager for Sun Cluster module of Sun Cluster Support for Oracle Real Application Clusters.

Default: 120

Range: 30 – 99999 seconds

Tunable: Any time

Svm_step2_timeout (integer)

The timeout (in seconds) for step 2 of a reconfiguration of the Solaris Volume Manager for Sun Cluster module of Sun Cluster Support for Oracle Real Application Clusters.

Default: 120

Range: 30 – 99999 seconds

Tunable: Any time

Svm_step3_timeout (integer)

The timeout (in seconds) for step 3 of a reconfiguration of the Solaris Volume Manager for Sun Cluster module of Sun Cluster Support for Oracle Real Application Clusters.

Default: 120

Range: 30 – 99999 seconds

Tunable: Any time

Svm_step4_timeout (integer)

The timeout (in seconds) for step 4 of a reconfiguration of the Solaris Volume Manager for Sun Cluster module of Sun Cluster Support for Oracle Real Application Clusters.

Default: 120

Range: 100 – 99999 seconds

Tunable: Any time

Svm_stop_step_timeout (integer)

The timeout (in seconds) for the stop step of a reconfiguration of the Solaris Volume Manager for Sun Cluster module of Sun Cluster Support for Oracle Real Application Clusters.

Default: 40

Range: 30 – 99999 seconds

Tunable: Any time

SPARC: SUNW.rac_cvm Extension Properties

Cvm_abort_step_timeout (integer)

The timeout (in seconds) for the abort step of a reconfiguration of the VERITAS Volume Manager (VxVM) component of Sun Cluster Support for Oracle Real Application Clusters

Default: 40

Range: 30 – 99999 seconds

Tunable: Any time

Cvm_return_step_timeout (integer)

The timeout (in seconds) for the return step of a reconfiguration of the VxVM component of Sun Cluster Support for Oracle Real Application Clusters

Default: 40

Range: 30 – 99999 seconds

Tunable: Any time

Cvm_start_step_timeout (integer)

The timeout (in seconds) for the start step of a reconfiguration of the VxVM component of Sun Cluster Support for Oracle Real Application Clusters

Default: 120

Range: 30 – 99999 seconds

Tunable: Any time

Cvm_step1_timeout (integer)

The timeout (in seconds) for step 1 of a reconfiguration of the VxVM component of Sun Cluster Support for Oracle Real Application Clusters

Default: 100

Range: 30 – 99999 seconds

Tunable: Any time

Cvm_step2_timeout (integer)

The timeout (in seconds) for step 2 of a reconfiguration of the VxVM component of Sun Cluster Support for Oracle Real Application Clusters

Default: 100

Range: 30 – 99999 seconds

Tunable: Any time

Cvm_step3_timeout (integer)

The timeout (in seconds) for step 3 of a reconfiguration of the VxVM component of Sun Cluster Support for Oracle Real Application Clusters

Default: 240

Range: 30 – 99999 seconds

Tunable: Any time

Cvm_step4_timeout (integer)

The timeout (in seconds) for step 4 of a reconfiguration of the VxVM component of Sun Cluster Support for Oracle Real Application Clusters

Default: 320

Range: 100 – 99999 seconds

Tunable: Any time

Cvm_stop_step_timeout (integer)

The timeout (in seconds) for the stop step of a reconfiguration of the VxVM component of Sun Cluster Support for Oracle Real Application Clusters

Default: 40

Range: 30 – 99999 seconds

Tunable: Any time

Reservation_timeout (integer)

The timeout (in seconds) for the reservation step of a reconfiguration of Sun Cluster Support for Oracle Real Application Clusters

Default: 325

Range: 100 – 99999 seconds

Tunable: Any time

Vxclust_num_ports (integer)

The number of communications ports that the vxclust program uses

Default: 32

Range: 16 – 64

Tunable: When disabled

Vxclust_port (integer)

The communications port number that the vxclust program uses

Default: 5568

Range: 1024 – 65535

Tunable: When disabled

Vxconfigd_port (integer)

The communications port number that the VxVM component configuration daemon vxconfigd uses

Default: 5560

Range: 1024 – 65535

Tunable: When disabled

Vxkmsgd_port (integer)

The communications port number that the VxVM component messaging daemon vxkmsgd uses

Default: 5559

Range: 1024 – 65535

Tunable: When disabled

SUNW.rac_hwraid Extension Properties

Reservation_timeout (integer)

The timeout (in seconds) for the reservation step of a reconfiguration of Sun Cluster Support for Oracle Real Application Clusters

Default: 325

Range: 100 – 99999 seconds

Tunable: Any time

SUNW.oracle_rac_server Extension Properties

Auto_End_Bkp (Boolean)

Specifies whether the Oracle RAC server resource automatically recovers the database if an Oracle relational database management system (RDBMS) hot backup is interrupted. When a hot backup is interrupted, the database fails to open because of files that remain in hot backup mode. During the startup of the Oracle RAC server resource, the resource tests for the interruption of a hot backup by testing for an occurrence of the following RDBMS error:

ORA-01113 file file needs media recovery

To recover the database automatically, the Oracle RAC server resource performs the following actions:

• Releasing all files that remain in hot backup mode. The sys.v$backup view indicates which files remain in hot backup mode.

• Opening the database for use.

The permitted values for this property are as follows:

• False – Specifies that the Oracle RAC server resource does not automatically recover the database. If a hot backup is interrupted, you must recover the database manually. In this situation, the status of the Oracle RAC server resource is set to FAULTED. The default value of this property is False.

• True – Specifies that the Oracle RAC server resource automatically recovers the database.

Default: False

Range: Not applicable

Tunable: Any time

Debug_level (integer)

The level to which debug messages from the Oracle RAC server component are logged. When the debug level is increased, more debug messages are written to the log files.

Default: 1, which logs syslog messages

Range: 0 – 100

Tunable: Any time

Oracle_Home (string)

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

Default: No default defined

Range: Not applicable

Tunable: When disabled

Oracle_Sid (string)

The Oracle system identifier. This identifier is the name of the Oracle database instance.

Default: No default defined

Range: Not applicable

Tunable: When disabled

Parameter_file (string)

The Oracle parameter file, which starts the database. If this property is not set, it defaults to NULL. When this property is NULL, the default Oracle mechanism is used to locate the parameter file.

Default: NULL

Range: Not applicable

Tunable: Any time

User_env (string)

The name of the file that contains the environment variables to be set before database startup or shutdown. All 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=value. Each definition must start on a new line in the environment file.

Default: NULL

Range: Not applicable

Tunable: Any time

Wait_for_online (Boolean)

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. The default value of this property is True.

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

Default: True

Range: Not applicable

Tunable: Any time

SUNW.oracle_listener Extension Properties

Debug_level (integer)

The level to which debug messages from the Oracle listener component are logged. When the debug level is increased, more debug messages are written to the log files.

Default: 1, which logs syslog messages

Range: 0 – 100

Tunable: Any time

LISTENER_NAME (string)

The name of the Oracle listener. This name must match the corresponding entry in the listener.ora configuration file.

Default: LISTENER

Range: Not applicable

Tunable: When disabled

ORACLE_HOME (string)

The path to the Oracle home directory.

Default: No default defined

Range: Not applicable

Tunable: When disabled

Probe_timeout (integer)

The timeout value in seconds that the fault monitor uses to probe an Oracle listener.

Default: 180

Range: 1– 99,999

Tunable: Any time

Introduced in release: 3.1 4/04

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, 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: ““

Range: Not applicable

Tunable: Any time