Go to main content

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

Exit Print View

Updated: April 2016
 
 

Tuning Support for Oracle RAC

To tune the 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, Support for Oracle RAC Extension Properties. Typically, you use the option -p property=value of the clresource command to set extension properties of Support for Oracle RAC resources. You can also use the procedures in Chapter 2, Administering Data Service Resources, in Oracle Solaris Cluster 4.3 Data Services Planning and Administration Guide to configure the resources later.

This section contains the following information about tuning the Support for Oracle RAC data service:

Guidelines for Setting Timeouts

Many of the extension properties for 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.

If timeouts occur during reconfiguration processes, increase the values of the appropriate timeout property to accommodate your cluster configuration.

Reservation Step Timeout

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

  • The number of shared physical disks in the cluster

  • The load on the cluster

If the number of shared physical disks in the cluster is large, or if your cluster is heavily loaded, the reconfiguration of 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  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 Support for Oracle RAC to 350 seconds. This example assumes that the Support for Oracle RAC framework component is represented by an instance of the SUNW.rac_framework resource type that is named rac-framework-rs.

Oracle Clusterware Framework Resource Method Timeouts

The start and stop timing of the Oracle Clusterware framework resource SUNW.crs_framework is dependent on a number of factors, including things such as the following:

  • The number of shared physical devices

  • The Oracle ASM storage configuration

  • The number of Oracle Clusterware resources

  • The use of an Administrative Database and its configuration

If you see that the Oracle Clusterware framework resource start or stop method execution time is getting close to the timeout value, or if an actual timeout occurs, increase the timeout for that method.

Example 5  Setting the Oracle Clusterware Framework Resource Start Timeout
# clresource set -p Start_timeout=600 crs-framework-rs

This example sets the timeout for the start method of the crs-framework-rs resource to 600 seconds.

If a stop method timeout occurs, you first need to clear the STOP_FAILED condition before you start the resource with the new timeout value. See the clresource(1CL) man page for instuctions on clearing this condition.

If a start method timeout occurs, first take the resource offline to clear this condition, then start the resource with the new timeout value.