Skip Navigation Links | |
Exit Print View | |
Oracle Solaris Cluster Data Service for SAP MaxDB Guide Oracle Solaris Cluster 4.1 |
1. Installing and Configuring HA for SAP MaxDB
Overview of the Installation and Configuration Process for HA for SAP MaxDB
Planning the HA for SAP MaxDB Installation and Configuration
SAP MaxDB Software Version Requirements
HA for SAP MaxDB Configuration Requirements
SAP xserver Configuration Requirements
Supported Configurations of This Data Service
Device Group for the SAP MaxDB Application
Dependencies of the SAP MaxDB Application on SAP xserver
Administration of SAP xserver by a User Other Than Root
Configuration Planning Questions
Installing and Configuring SAP MaxDB
How to Install and Configure SAP MaxDB
How to Enable SAP MaxDB to Run in a Cluster
Verifying the SAP MaxDB Installation and Configuration
How to Verify SAP MaxDB Installation and Configuration on Each Node
Installing the HA for SAP MaxDB Package
How to Install the HA for SAP MaxDB Package
Configuring the HAStoragePlus Resource Type to Work With HA for SAP MaxDB
How to Register and Configure an HAStoragePlus Resource
Registering and Configuring HA for SAP MaxDB
Setting HA for SAP MaxDB Extension Properties
Administering SAP xserver as a User Other Than Root
How to Register and Configure an SAP xserver Resource
How to Register and Configure a SAP MaxDB Resource
Tuning the HA for SAP MaxDB Fault Monitors
Factors That Affect the Interval Between Fault Monitor Probes
Operations by the HA for SAP MaxDB Fault Monitors During a Probe
Operations by the SAP MaxDB Fault Monitor During a Probe
Operations by the SAP xserver Fault Monitor During a Probe
Faults Detected by the HA for SAP MaxDB Fault Monitors
Faults Detected by the SAP MaxDB Fault Monitor
Faults Detected by the SAP xserver Fault Monitor
Recovery Actions in Response to Detected Faults
Forcing the SAP MaxDB Database Instance to Be Restarted if the Parent Kernel Process Is Terminated
Verifying the HA for SAP MaxDB Installation and Configuration
How to Verify the Operation of the SAP MaxDB Fault Monitor
How to Verify the Operation of the SAP xserver Fault Monitor
Fault monitoring for the HA for SAP MaxDB data service is provided by the following fault monitors:
The SAP MaxDB fault monitor
The SAP xserver fault monitor
Each fault monitor is contained in a resource whose resource type is shown in the following table.
Table 1-3 Resource Types for HA for SAP MaxDB Fault Monitors
|
System properties and extension properties of these resources control the behavior of the fault monitors. The default values of these properties determine the preset behavior of the fault monitors. The preset behavior should be suitable for most Oracle Solaris Cluster installations. Therefore, you should tune the HA for SAP MaxDB fault monitors only if you need to modify this preset behavior.
Tuning the HA for SAP MaxDB fault monitors involves the following tasks:
Setting the interval between fault monitor probes
Setting the timeout for fault monitor probes
Defining the criteria for persistent faults
Specifying the failover behavior of a resource
For more information, see Tuning Fault Monitors for Oracle Solaris Cluster Data Services in Oracle Solaris Cluster Data Services Planning and Administration Guide. Information about the HA for SAP MaxDB fault monitors that you need to perform these tasks is provided in the subsections that follow.
HA for SAP MaxDB also enables you to control how the fault monitor responds if the SAP MaxDB parent kernel process is not running. For more information, see Forcing the SAP MaxDB Database Instance to Be Restarted if the Parent Kernel Process Is Terminated.
Tune the HA for SAP MaxDB fault monitors when you register and configure HA for SAP MaxDB. For more information, see Registering and Configuring HA for SAP MaxDB.
To determine whether SAP xserver and the SAP MaxDB database instance are operating correctly, the HA for SAP MaxDB fault monitors probe these resources periodically. The optimum interval between fault monitor probes depends on the time that is required to respond to a fault in a resource. This time depends on how the complexity of the resource affects the time that is required for operations such as restarting the resource.
For example, SAP xserver is a much simpler resource and can be restarted much quicker than SAP MaxDB. Therefore, the optimum interval between fault monitor probes of SAP xserver is shorter than the optimum interval between probes of SAP MaxDB.
The optimum timeout for fault monitor probes depends on the operations that a fault monitor performs to probe the resource.
During a probe, the SAP MaxDB fault monitor performs the following operations:
The SAP MaxDB fault monitor determines whether the SAP MaxDB database instance is online.
If the SAP MaxDB database instance is online, the SAP MaxDB fault monitor determines whether the parent kernel process of the SAP MaxDB database instance is running. You can control how the fault monitor responds if the parent kernel process is not running. For more information, see Forcing the SAP MaxDB Database Instance to Be Restarted if the Parent Kernel Process Is Terminated.
The SAP MaxDB fault monitor determines whether SAP xserver is available. This fault monitoring supplements the fault monitoring that the SAP xserver fault monitor provides.
During a probe, the SAP xserver fault monitor determines whether SAP xserver is available.
Faults that each HA for SAP MaxDB fault monitor detects are described in the subsections that follow.
The SAP MaxDB fault monitor detects the following faults in SAP MaxDB:
A status of the SAP MaxDB database instance that is not ONLINE, for example, OFFLINE or ADMIN
Unexpected termination of the parent kernel process of the SAP MaxDB database instance
The SAP MaxDB fault monitor also detects the unavailability of SAP xserver. This fault monitoring supplements the fault monitoring that the SAP xserver fault monitor provides.
Note - If the SAP MaxDB fault monitor detects that SAP xserver is unavailable twice within the retry interval, the SAP MaxDB fault monitor restarts SAP MaxDB. By restarting SAP MaxDB, the fault monitor ensures that the SAP MaxDB database fails over to another node when SAP xserver is persistently unavailable.
The SAP xserver fault monitor detects following faults:
Unavailability of SAP xserver. Unavailability of SAP xserver is also detected by the SAP MaxDB fault monitor.
Persistent system errors. A persistent system error is a system error that occurs four times within the retry interval. If a persistent system error occurs, the fault monitor restarts SAP xserver.
To minimize the disruption that transient faults in a resource cause, a fault monitor restarts the resource in response to such faults. For persistent faults, more disruptive action than restarting the resource is required:
For the SAP MaxDB resource, the fault monitor fails over the resource to another node. The SAP MaxDB resource is a failover resource.
For the SAP xserver resource, the fault monitor takes the resource offline. The SAP xserver is a multiple master resource.
By default, unexpected termination of the parent kernel process does not cause the SAP MaxDB fault monitor to restart the SAP MaxDB database instance. The SAP MaxDB database instance can continue to function without the parent kernel process. Restarting the SAP MaxDB database instance in this situation might cause unnecessary unavailability of the SAP MaxDB database instance. Therefore, you should force the SAP MaxDB database instance to be restarted only if you require a feature that the parent kernel process provides. An example of such a feature is maintaining the integrity of the log history.
To force the SAP MaxDB database instance to be restarted if the parent kernel process is terminated, set the Restart_if_Parent_Terminated extension property of the SUNW.sapdb resource to True.