Oracle® Solaris Cluster Data Service for Oracle Real Application Clusters Guide

Exit Print View

Updated: July 2014, E39656–01
 
 

Support for Oracle RAC Extension Properties

The extension properties that you can set for each Support for Oracle RAC resource type are listed in the following sections:

You can update some extension properties dynamically. You can update others, however, only when you create or disable a resource. The Tunable entries indicate when you can update each property.

For information about all system-defined properties, see the r_properties (5) man page and the rg_properties (5) man page.

For information about SUNW.qfs extension properties, see SUNW.qfs(5) in Sun QFS and Sun Storage Archive Manager 5.3 Reference Manual .

SUNW.crs_framework Extension Properties

The SUNW.crs_framework resource type has no extension properties.

SUNW.rac_framework Extension Properties

reservation_timeout

This property specifies the timeout (in seconds) for the reservation step of a reconfiguration of Support for Oracle RAC.

Data Type: Integer

Default: 325

Range: 100 – 99999 seconds

Tunable: Any time

SUNW.scalable_acfs_proxy Extension Properties

acfs_mountpoint

This property specifies the mount point of an Oracle ACFS file system.

Data Type

String

Default

No default defined

Minimum length

1

Tunable

When disabled

debug_level

Note -  All SQL*Plus messages that the Oracle ACFS proxy resource issues are written to the log file /var/opt/SUNWscor/oracle_asm/message_log.${RESOURCE}.

This property indicates the level to which debug messages from the monitor for the Oracle ACFS proxy are logged. When the debug level is increased, more debug messages are written to the system log /var/adm/messages as follows:

0

No debug messages

1

Function Begin and End messages

2

All debug messages and function Begin/End messages

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

Default

0

Tunable

Any time

proxy_probe_interval

This property specifies the interval, in seconds, between probes of the Oracle ACFS resource for which this resource is acting as a proxy.

Data Type

Integer

Range

5–300

Default

30

Tunable

Any time

proxy_probe_timeout

This property specifies the timeout value, in seconds, that the proxy monitor uses when checking the status of the Oracle ACFS resource for which this resource is acting as a proxy.

Data Type

Integer

Range

5–120

Default

60

Tunable

Any time

SUNW.scalable_asm_diskgroup_proxy Extension Properties

asm_diskgroups

This property specifies the Oracle ASM disk group. If required, more than one Oracle ASM disk group can be specified as a comma separated list.

Data Type: String array

Default: Not applicable

Range: Not applicable

Tunable: When disabled

debug_level (integer)

Note -  All SQL*Plus and srvmgr messages that the Oracle ASM disk group resource issues are written to the log file /var/opt/SUNWscor/oracle_asm/message_log.${RESOURCE}.

This property indicates the level to which debug messages for the Oracle ASM disk group resources are logged. When the debug level is increased, more debug messages are written to the system log /var/adm/messages as follows:

0

No debug messages

1

Function Begin and End messages

2

All debug messages and function Begin/End messages

You can specify a different value of the debug_level extension property for each node that can master the resource.

Range: 0–2

Default: 0

Tunable: Any time

Proxy_probe_interval(integer)

Specifies the timeout value, in seconds, that the proxy monitor uses when checking the status of the clustered Oracle ASM disk group resource for which this resource is acting as a proxy.

Range: 5–120

Default: 30

Tunable: Any time

proxy_probe_timeout(integer)

This property specifies the timeout value, in seconds, for the probe command.

Range: 5–120

Default: 60

Tunable: Any time

SUNW.scalable_asm_instance_proxy Extension Properties

asm_diskgroups

This property specifies the Oracle ASM disk group. If required, more than one Oracle ASM disk group can be specified as a comma separated list.

Data Type: String array

Default: Not applicable

Range: Not applicable

Tunable: When disabled

crs_home

This property specifies the full path to the Oracle Grid Infrastructure home directory. The Oracle Grid Infrastructure home directory contains the binary files, log files and parameter files for the Oracle Grid Infrastructure software.

Data Type: String

Range: Not applicable

Default: No default defined

Tunable: When disabled

debug_level

Note -  All SQL*Plus and srvmgr messages that the clustered Oracle ASM instance proxy resource issues are written to the log file /var/opt/SUNWscor/oracle_asm/message_log.${RESOURCE}.

This property indicates the level to which debug messages from the monitor for the clustered Oracle ASM instance proxy are logged. When the debug level is increased, more debug messages are written to the system log /var/adm/messages as follows:

0

No debug messages

1

Function Begin and End messages

2

All debug messages and function Begin/End messages

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

Default: 0

Tunable: Any time

oracle_home

This property specifies the full path to the Oracle home directory. The Oracle Database 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

proxy_probe_timeout

This property specifies the timeout value, in seconds, that the proxy monitor uses when checking the status of the Oracle Grid Infrastructure resource for which this resource is acting as a proxy.

Data Type: Integer

Range: 5–120

Default: 60

Tunable: Any time

proxy_probe_interval

This property specifies the interval, in seconds, between probes of the Oracle Grid Infrastructure resource for which this resource is acting as a proxy.

Data Type: Integer

Range: 5–120

Default: 60

Tunable: Any time

SUNW.scalable_rac_server_proxy Extension Properties

client_retries

This property specifies the maximum number of attempts by the resource's remote procedure call (RPC) client to connect to the proxy daemon.

Data Type: Integer

Range: 1–25

Default: 3

Tunable: When disabled

client_retry_interval

This property specifies the interval, in seconds, between attempts by the resource's RPC client to connect to the proxy daemon.

Data Type: Integer

Range: 1–3600

Default: 5

Tunable: When disabled

crs_home

This property specifies the directory in which the Oracle Grid Infrastructure software is located.

Data Type: String

Range: Not applicable

Default: No default defined

Tunable: When disabled

db_name

This property specifies the name that uniquely identifies the specific Support for Oracle RAC database that is associated with this resource. This identifier distinguishes the database from other databases that might run simultaneously on your system. The name of the Support for Oracle RAC database is specified during the installation of Support for Oracle RAC.

Data Type: String

Range: Not applicable

Default: No default defined

Tunable: When disabled

debug_level

This property indicates the level to which debug messages from the component for the Support for Oracle RAC proxy server 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/scalable_rac_server_proxy/message_log.rs, where rs is the name of the resource that represents the Support for Oracle RAC proxy 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

monitor_probe_interval

This property specifies the interval, in seconds, between probes of the Oracle Grid Infrastructure resource for which this resource is acting as a proxy.

Data Type: Integer

Range: 10–3600

Default: 300

Tunable: Any time

oracle_home

This property specifies the full path to the Oracle Database home directory. The Oracle Database home directory contains the binary files, log files, and parameter files for the Oracle Database software.

Data Type: String

Range: Not applicable

Default: No default defined

Tunable: When disabled

proxy_probe_timeout

This property specifies the timeout value, in seconds, that the proxy monitor uses when checking the status of the Oracle Grid Infrastructure resource for which this resource is acting as a proxy.

Data Type: Integer

Range: 5–3600

Default: 120

Tunable: Any time

startup_wait_count

This property specifies the maximum number of attempts by this resource to confirm that the Oracle Grid Infrastructure software is started completely. The interval between attempts is twice the value of the proxy_probe_timeout extension property.

The resource requires confirmation that Oracle Grid Infrastructure software is started before attempting to start a Support for Oracle RAC database instance. If the maximum number of attempts is exceeded, the resource does not attempt to start the database instance.

Data Type: Integer

Range: 10–600

Default: 20

Tunable: When disabled

user_env

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

SUNW.ScalDeviceGroup Extension Properties

debug_level

This property specifies the level to which debug messages from the resource of this type are logged. When the debug level is increased, more debug messages are written to the log files.

Data type: Integer

Default: 0

Range: 0–10

Tunable: Any time

diskgroupname

This property specifies the name of the device group that the resource represents. You must set this property to the following item:

  • The name of an existing Solaris Volume Manager for Sun Cluster multi-owner disk set. This name was specified in the metaset (1M) command with which the disk set was created.

The requirements for the device group that you specify are as follows:

  • The device group must be a valid, existing multi-owner disk set or shared-disk group.

  • The device group must be hosted on all nodes that can master the resource.

  • The device group must be accessible from all nodes that can master the scalable device group resource.

  • The device group must contain at minimum one volume.

Data type: String

Default: No default defined

Range: Not applicable

Tunable: When disabled

logicaldevicelist

This property specifies a comma-separated list of logical volumes that the fault monitor of the resource is to monitor. If you are using Solaris Volume Manager for Sun Cluster in a zone cluster and are not using all the devices in the metaset, you must set this property. Otherwise, this property is optional. If you do not specify a value for this property, all logical volumes in the device group are to be monitored.

The status of the device group is derived from the statuses of the individual logical volumes that are monitored. If all monitored logical volumes are healthy, the device group is healthy. If any monitored logical volume is faulty, the device group is faulty.

The status of an individual logical volume is obtained by querying the volume's volume manager. If the status of a Solaris Volume Manager for Sun Cluster volume cannot be determined from a query, the fault monitor performs file input/output (I/O) operations to determine the status.

If a device group is discovered to be faulty, monitoring of the resource that represents the group is stopped and the resource is put into the disabled state.


Note -  For mirrored disks, if one submirror is faulty, the device group is still considered to be healthy.

The requirements for each logical volume that you specify are as follows:

  • The logical volume must exist.

  • The logical volume must be contained in the device group that the diskgroupname property specifies.

  • The logical volume must be accessible from all nodes that can master the scalable device group resource.

Data type: String array

Default: ""

Range: Not applicable

Tunable: Any time

monitor_retry_count

This property specifies the maximum number of restarts by the process monitor facility (PMF) that are allowed for the fault monitor.

Data type: Integer

Default: 4

Range: No range defined

Tunable: Any time

monitor_retry_interval

This property specifies the period of time in minutes during which the PMF counts restarts of the fault monitor.

Data type: Integer

Default: 2

Range: No range defined

Tunable: Any time

SUNW.ScalMountPoint Extension Properties

debug_level

This property specifies the level to which debug messages from the resource for a file-system mount point are logged. When the debug level is increased, more debug messages are written to the log files.

Data type: Integer

Default: 0

Range: 0–10

Tunable: Any time

filesystemtype

This property specifies the type of file system whose mount point the resource represents. You must specify this property. Set this property to one of the following values:

nas

Specifies that the file system is a file system on a qualified NAS device.

s-qfs

Specifies that the file system is a Sun QFS shared file system.

Data type: String

Default: No default defined

Range: Not applicable

Tunable: When disabled

iotimeout

This property specifies the timeout value in seconds that the fault monitor uses for file input/output (I/O) probes. To determine if the mounted file system is available, the fault monitor performs I/O operations such as opening, reading, and writing to a test file on the file system. If an I/O operation is not completed within the timeout period, the fault monitor reports an error.

Data type: Integer

Default: 300

Range: 5–300

Tunable: Any time

monitor_retry_count

This property specifies the maximum number of restarts by the process monitor facility (PMF) that are allowed for the fault monitor.

Data type: Integer

Default: 4

Range: No range defined

Tunable: Any time

monitor_retry_interval

This property specifies the period of time in minutes during which the PMF counts restarts of the fault monitor.

Data type: Integer

Default: 2

Range: No range defined

Tunable: Any time

mountoptions

This property specifies a comma-separated list of mount options that are to be used when the file system that the resource represents is mounted. This property is optional. If you do not specify a value for this property, mount options are obtained from the file system's table of defaults.

  • For a Sun QFS shared file system, these options are obtained from the /etc/opt/SUNWsamfs/samfs.cmd file.

  • For a file system on a qualified NAS device, these options are obtained from the /etc/vfstab file.

Mount options that you specify through this property override the mount options in the file system's table of defaults.

Data type: String

Default: ""

Range: Not applicable

Tunable: When disabled

mountpointdir

This property specifies the mount point of the file system that the resource represents. The mount point is the full path to the directory where the file system is attached to the file system hierarchy when the file system is mounted. You must specify this property.

The directory that you specify must already exist.

Data type: String

Default: No default defined

Range: Not applicable

Tunable: When disabled

targetfilesystem

This property specifies the file system that is to be mounted at the mount point that the mountpointdir extension property specifies. You must specify this property. The type of the file system must match the type that the filesystemtype property specifies. The format of this property depends on the type of the file system as follows:

  • For a Sun QFS shared file system, set this property to the name that was assigned to the file system when the file system was created. The file system must be correctly configured. For more information, see your Sun QFS shared file system documentation.

  • For a file system on a qualified NAS device, set this property to nas-device:path. The replaceable items in this format are as follows:

    nas-device

    Specifies the name of the qualified NAS device that is exporting the file system. You can optionally qualify this name with a domain.

    path

    Specifies the full path to the file system that the qualified NAS device is exporting.

    The qualified NAS device and the file system must already be configured for use with Sun Cluster. For more information, see Oracle Solaris Cluster With Network-Attached Storage Device Manual .

Data type: String

Default: No default defined

Range: Not applicable

Tunable: When disabled

SUNW.vucmm_framework Extension Properties

reservation_timeout

This property specifies the timeout (in seconds) for the reservation step of a reconfiguration of the framework.

Data Type: Integer

Default: 325

Range: 100 – 99999 seconds

Tunable: Any time

SUNW.vucmm_svm Extension Properties

debug_level

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

Data Type: Integer

Default: 1, which logs syslog messages

Range: 0 – 10

Tunable: Any time

svm_abort_step_timeout

This property specifies the timeout (in seconds) for the abort step of a reconfiguration of the Solaris Volume Manager for Sun Cluster module of the volume manager reconfiguration framework.

Data Type: Integer

Default: 120

Range: 30 – 99999 seconds

Tunable: Any time

svm_return_step_timeout

This property specifies the timeout (in seconds) for the return step of a reconfiguration of the Solaris Volume Manager for Sun Cluster module of the volume manager reconfiguration framework.

Data Type: Integer

Default: 120

Range: 30 – 99999 seconds

Tunable: Any time

svm_start_step_timeout

This property specifies the timeout (in seconds) for the start step of a reconfiguration of the Solaris Volume Manager for Sun Cluster module of the volume manager reconfiguration framework.

Data Type: Integer

Default: 120

Range: 30 – 99999 seconds

Tunable: Any time

svm_step1_timeout

This property specifies the timeout (in seconds) for step 1 of a reconfiguration of the Solaris Volume Manager for Sun Cluster module of the volume manager reconfiguration framework.

Data Type: Integer

Default: 120

Range: 30 – 99999 seconds

Tunable: Any time

svm_step2_timeout

This property specifies the timeout (in seconds) for step 2 of a reconfiguration of the Solaris Volume Manager for Sun Cluster module of the volume manager reconfiguration framework.

Data Type: Integer

Default: 120

Range: 30 – 99999 seconds

Tunable: Any time

svm_step3_timeout

This property specifies the timeout (in seconds) for step 3 of a reconfiguration of the Solaris Volume Manager for Sun Cluster module of the volume manager reconfiguration framework.

Data Type: Integer

Default: 120

Range: 30 – 99999 seconds

Tunable: Any time

svm_step4_timeout

This property specifies the timeout (in seconds) for step 4 of a reconfiguration of the Solaris Volume Manager for Sun Cluster module of the volume manager reconfiguration framework.

Data Type: Integer

Default: 120

Range: 100 – 99999 seconds

Tunable: Any time

svm_stop_step_timeout

This property specifies the timeout (in seconds) for the stop step of a reconfiguration of the Solaris Volume Manager for Sun Cluster module of the volume manager reconfiguration framework.

Data Type: Integer

Default: 40

Range: 30 – 99999 seconds

Tunable: Any time

SUNW.wait_zc_boot Extension Properties

zcname

This property specifies the name of the zone cluster that needs to be booted before the dependent resource.

Data type: String

Default: No default defined

Range: Not applicable

Tunable: When disabled