Sun Cluster Data Service for Oracle RAC Guide for Solaris OS

Tuning Sun Cluster Support for Oracle RAC

To tune the Sun Cluster Support for Oracle RAC data service, you modify the extension properties of the resources for this data service. For details about these extension properties, see Appendix C, Sun Cluster Support for Oracle RAC Extension Properties. Typically, you use the option -p property=value of the clresource(1CL) command to set extension properties of Sun Cluster Support for Oracle RAC resources. You can also use the procedures in Chapter 2, Administering Data Service Resources, in Sun Cluster Data Services Planning and Administration Guide for Solaris OS to configure the resources later.

Guidelines for Setting Timeouts

Many of the extension properties for Sun Cluster Support for Oracle RAC specify timeouts for steps in reconfiguration processes. The optimum values for most of these timeouts are independent of your cluster configuration. Therefore, you should not need to change the timeouts from their default values.

Timeouts that depend on your cluster configuration are described in the subsections that follow. If timeouts occur during reconfiguration processes, increase the values of these timeout properties to accommodate your cluster configuration.

SPARC: VxVM Component Reconfiguration Step 4 Timeout

The time that is required for step 4 of a reconfiguration of the VxVM component of Sun Cluster Support for Oracle RAC is affected by the size and complexity of your VERITAS shared-disk group configuration. If your VERITAS shared-disk group configuration is large or complex and the reconfiguration of the VxVM component times out, increase the timeout for step 4 of a reconfiguration of the VxVM component.

To increase the timeout for step 4 of a reconfiguration of the VxVM component, increase the value of the Cvm_step4_timeout extension property of the SUNW.rac_cvm resource.

For more information, see SPARC: SUNW.rac_cvm Extension Properties.


Example 4–1 Setting the VxVM Component Reconfiguration Step 4 Timeout


# clresource set -p cvm_step4_timeout=1200 rac-cvm-rs

This example sets the timeout for step 4 of a reconfiguration of the VxVM component to 1200 seconds. This example assumes that the VxVM component is represented by an instance of the SUNW.rac_cvm resource type that is named rac-cvm-rs.


Reservation Step Timeout

The time that is required for reservation commands to run is affected by the following factors:

If the number of shared physical disks in the cluster is large, or if your cluster is heavily loaded, the reconfiguration of Sun Cluster Support for Oracle RAC might time out. If such a timeout occurs, increase the reservation step timeout.

To increase the reservation step timeout, increase the Reservation_timeout extension property of the SUNW.rac_framework resource.

For more information, see SUNW.rac_framework Extension Properties.


Example 4–2 Setting the Reservation Step Timeout


# clresource set -p reservation_timeout=350 rac-framework-rs

This example sets the timeout for the reservation step of a reconfiguration of Sun Cluster Support for Oracle RAC to 350 seconds. This example assumes that RAC framework component is represented by an instance of the SUNW.rac_framework resource type that is named rac-frameowrk-rs.


SPARC: Guidelines for Setting the Communications Port Range for the Oracle UDLM

An application other than the Oracle UDLM on a cluster node might use a range of communications ports that conflicts with the range for the Oracle UDLM. If such a conflict occurs, modify the range of communications ports that the Oracle UDLM uses.

The range of communications ports that the Oracle UDLM uses is determined by the values of the following extension properties of the SUNW.rac_udlm resource type:

For more information, see SPARC: SUNW.rac_udlm Extension Properties.


Example 4–3 Setting the Communications Port Number for the Oracle UDLM


# clresource set -p port=7000 rac-udlm-rs

This example sets the communications port number that the Oracle UDLM uses to 7000. The following assumptions apply to this example:


ProcedureHow to Modify an Extension Property That Is Tunable Only When a Resource Is Disabled

Restrictions apply to the circumstances in which you can modify an extension property that is tunable only when a resource is disabled. Those circumstances depend on the resource type as follows:

This procedure provides the long forms of the Sun Cluster maintenance commands. Most commands also have short forms. Except for the forms of the command names, the commands are identical. For a list of the commands and their short forms, see Appendix A, Sun Cluster Object-Oriented Commands, in Sun Cluster Data Services Planning and Administration Guide for Solaris OS.

  1. Disable each resource that the RAC framework resource group contains and bring the RAC framework resource group into the UNMANAGED state.

    Disable the instance of the SUNW.rac_framework resource only after you have disabled all other resources that the RAC framework resource group contains. The other resources in the RAC framework resource group depend on the SUNW.rac_framework resource.

    For detailed instructions, see Disabling Resources and Moving Their Resource Group Into the UNMANAGED State in Sun Cluster Data Services Planning and Administration Guide for Solaris OS.

  2. Reboot all the nodes that are in the node list of the RAC framework resource group.

  3. Use the clresource command to set the property to its new value.


    # clresource set -p property=value resource
    
    property

    Specifies the name of the property that you are changing.

    value

    The new value of the property.

    resource

    Specifies the name of the resource for which you are modifying an extension property. If this resource was created by using the clsetup utility, the name depends on the resource type, as shown in Automatically Generated Names for Sun Cluster Objects.

  4. Bring the RAC framework resource group and its resources online.


    # clresourcegroup online resource-group
    
    resource-group

    Specifies the name of the RAC framework resource group that is to be moved to the MANAGED state and brought online. If this resource group was created by using the clsetup utility, the name of the resource group is rac-framework-rg.