Skip Navigation Links | |
Exit Print View | |
Oracle Solaris Cluster Data Service for Oracle Real Application Clusters Guide Oracle Solaris Cluster |
1. Installing Support for Oracle RAC
2. Configuring Storage for Oracle Files
3. Registering and Configuring the Resource Groups
4. Enabling Oracle RAC to Run in a Cluster
5. Administering Support for Oracle RAC
Overview of Administration Tasks for Support for Oracle RAC
Automatically Generated Names for Oracle Solaris Cluster Objects
Administering Oracle RAC Databases From Oracle Solaris Cluster Software
Effects of State Changes to Oracle Solaris Cluster Resources for Oracle 9i RAC Database Instances
Guidelines for Setting Timeouts
SPARC: VxVM Component Reconfiguration Step 4 Timeout
SPARC: Guidelines for Setting the Communications Port Range for the UDLM
How to Modify an Extension Property That Is Tunable Only When a Resource Is Disabled
Tuning the Support for Oracle RAC Fault Monitors
Operation of the Fault Monitor for a Scalable Device Group
Operation of the Fault Monitor for Scalable File-System Mount Points
Operation of the Oracle 9i RAC Server Fault Monitor
Operation of the Main Fault Monitor
Operation of the Database Client Fault Probe
Operations to Monitor the Partition for Archived Redo Logs
Operations to Determine Whether the Database is Operational
Actions by the Server Fault Monitor in Response to a Database Transaction Failure
Scanning of Logged Alerts by the Server Fault Monitor
Operation of the Oracle 9i RAC Listener Fault Monitor
Obtaining Core Files for Troubleshooting DBMS Timeouts
Customizing the Oracle 9i RAC Server Fault Monitor
Defining Custom Behavior for Errors
Changing the Response to a DBMS Error
Responding to an Error Whose Effects Are Major
Ignoring an Error Whose Effects Are Minor
Changing the Response to Logged Alerts
Changing the Maximum Number of Consecutive Timed-Out Probes
Propagating a Custom Action File to All Nodes in a Cluster
Specifying the Custom Action File That a Server Fault Monitor Should Use
How to Specify the Custom Action File That a Server Fault Monitor Should Use
6. Troubleshooting Support for Oracle RAC
7. Modifying an Existing Configuration of Support for Oracle RAC
8. Upgrading Support for Oracle RAC
A. Sample Configurations of This Data Service
B. Preset Actions for DBMS Errors and Logged Alerts
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(1CL) 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 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:
SPARC: Guidelines for Setting the Communications Port Range for the UDLM
How to Modify an Extension Property That Is Tunable Only When a Resource Is Disabled
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.
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.
This section describes the following timeouts:
The time that is required for step 4 of a reconfiguration of the VxVM component of 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 5-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.
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 5-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 Support for Oracle RAC to 350 seconds. This example assumes that Oracle RAC framework component is represented by an instance of the SUNW.rac_framework resource type that is named rac-frameowrk-rs.
An application other than the UDLM on a cluster node might use a range of communications ports that conflicts with the range for the UDLM. If such a conflict occurs, modify the range of communications ports that the UDLM uses.
The range of communications ports that the UDLM uses is determined by the values of the following extension properties of the SUNW.rac_udlm resource type:
Port. Specifies the communications port number that the UDLM uses. The first number in the range of communications port numbers that the UDLM uses is the value of Port.
Num_ports. Specifies the number of communications ports that the UDLM uses. The last number in the range of communications port numbers that the UDLM uses is the sum of the values of Port and Num_ports.
For more information, see SPARC: SUNW.rac_udlm Extension Properties.
Example 5-3 Setting the Communications Port Number for the UDLM
# clresource set -p port=7000 rac-udlm-rs
This example sets the communications port number that the UDLM uses to 7000. The following assumptions apply to this example:
The UDLM component is represented by an instance of the SUNW.rac_udlm resource type that is named rac-udlm-rs.
The command in this example is run as part of the procedure for modifying an extension property that is tunable only when disabled. For more information, see How 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:
SPARC: SUNW.rac_udlm – Only when the UDLM is not running on any cluster node
SPARC: SUNW.rac_cvm – Only when VxVM is not running in cluster mode on any cluster node
Disable the instance of the SUNW.rac_framework resource only after you have disabled all other resources that the Oracle RAC framework resource group contains. The other resources in the Oracle 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 Oracle Solaris Cluster Data Services Planning and Administration Guide.
# clresource set -p property=value resource
Specifies the name of the property that you are changing.
The new value of the property.
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 Oracle Solaris Cluster Objects.
# clresourcegroup online resource-group
Specifies the name of the Oracle 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.