1. Installing and Configuring HA for MaxDB
Overview of the Installation and Configuration Process for HA for MaxDB
Planning the HA for MaxDB Installation and Configuration
MaxDB Software Version Requirements
HA for MaxDB Configuration Requirements
SAP xserver Configuration Requirements
Supported Configurations of This Data Service
Device Group for the MaxDB Application
Dependencies of the MaxDB Application on SAP xserver
Administration of SAP xserver by a User Other Than Root
Configuration Planning Questions
Installing and Configuring MaxDB
How to Install and Configure MaxDB
How to Enable MaxDB to Run in a Cluster
Verifying the MaxDB Installation and Configuration
How to Verify MaxDB Installation and Configuration on Each Node
Installing the HA for MaxDB Packages
How to Install the HA for MaxDB Packages
Configuring the HAStoragePlus Resource Type to Work With HA for MaxDB
How to Register and Configure an HAStoragePlus Resource
Registering and Configuring HA for MaxDB
Setting HA for MaxDB Extension Properties
Administering SAP xserver as a User Other Than Root
Tuning the HA for MaxDB Fault Monitors
Factors That Affect the Interval Between Fault Monitor Probes
Operations by the HA for MaxDB Fault Monitors During a Probe
Operations by the MaxDB Fault Monitor During a Probe
Operations by the SAP xserver Fault Monitor During a Probe
Faults Detected by the HA for MaxDB Fault Monitors
Faults Detected by the MaxDB Fault Monitor
Faults Detected by the SAP xserver Fault Monitor
Recovery Actions in Response to Detected Faults
Forcing the MaxDB Database Instance to Be Restarted if the Parent Kernel Process Is Terminated
Verifying the HA for MaxDB Installation and Configuration
How to Verify the Operation of the MaxDB Fault Monitor
How to Verify the Operation of the SAP xserver Fault Monitor
Upgrading the SUNW.sap_xserver Resource Type
Information for Registering the New Resource Type Version
Information for Migrating Existing Instances of the Resource Type
To enable HA for MaxDB to make MaxDB highly available, configure Oracle Solaris Cluster data services as follows:
Configure SAP xserver as a scalable data service.
Configure HA for MaxDB as a failover data service.
Before you perform this procedure, ensure that the HA for MaxDB data service packages are installed.
The sections that follow contain instructions for registering and configuring resources. These instructions explain how to set only extension properties that HA for MaxDB requires you to set. For information about all HA for MaxDB extension properties, see Appendix A, HA for MaxDB Extension Properties. You can update some extension properties dynamically. You can update other properties, however, only when you create or disable a resource. The Tunable entry indicates when you can update a property.
To set an extension property of a resource, include the following option to modify the resource:
-p property=value
Identifies the extension property that you are setting
Specifies the value to which you are setting the extension property
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 resources after the resources are created.
You might be required to administer SAP xserver as a user other than root. In this situation, you must create and define that user as follows:
You must create that user on all cluster nodes or zones that master SAP xserver.
You must define that user when you register and configure an SAP xserver resource. To define the user who administers SAP xserver, set the Xserver_User extension property when you create an SAP xserver resource. For more information about the Xserver_User extension property, see SUNW.sap_xserver Extension Properties.
# clresourcetype register SUNW.sap_xserver
Configure SAP xserver so that SAP xserver starts on all nodes to which the MaxDB resource can fail over. To implement this configuration, ensure that the node list of the SAP xserver resource group contains all nodes that are in the node list of the MaxDB resource group. This resource group is created when the procedure How to Enable MaxDB to Run in a Cluster is performed.
# clresourcegroup create -n node-zone-list \ -p Maximum_primaries=nodes-in-sapdb-rg \ -p Desired_primaries=nodes-in-sapdb-rg xserver-rg
Specifies a comma-separated, ordered list of zones that can master this resource group. The format of each entry in the list is node. In this format, node specifies the node name and zone specifies the name of a non-global Solaris zone. To specify the global zone, or to specify a node without non-global zones, specify only node.
This list is optional. If you omit this list, the global zone of each cluster node can master the resource group.
Specifies the maximum number of nodes on which the SAP xserver resource can start. This number is equal to the number of nodes that are in the node list of the MaxDB resource group. You must specify the same number as the value of the Desired_primaries property.
Specifies the desired number of nodes on which the SAP xserver resource can start. This number is equal to the number of nodes that are in the node list of the MaxDB resource group. You must specify the same number as the value of the Maximum_primaries property.
Specifies that the resource group that you are creating is named xserver-rg.
# clresource create -g xserver-rg \ -t SUNW.HAStoragePlus \ -p filesystemmountpoints=mountpoints \ -p affinityon=false xserver-storage-resource
Specifies that the resource that you are creating is added to the resource group xserver-rg.
Specifies that the resource type of the resource you are creating is SUNW.HAStoragePlus.
Specifies the mount points for the resource group you are creating.
Indicates that the SAP xserver resource does not have to be colocated with the device group.
Specifies that the resource that you are creating is named xserver-storage-resource.
The resource is created in the enabled state.
For more details on how to set up an HAStoragePlus resource, see Enabling Highly Available Local File Systems in Oracle Solaris Cluster Data Services Planning and Administration Guide.
# clresource create -d -g xserver-rg \ -t SUNW.sap_xserver \ -p resource_dependencies=xserver-storage-resource xserver-resource
Specifies that the resource is to be added to the resource group that you created in Step 3
Specifies that the resource is an instance of the SUNW.sap_xserver resource type
Sets a resource dependency between xserver-storage-resource and the HAStoragePlus resource we created in Step 4.
Specifies that the resource that you are creating is named xserver-resource.
The resource is created in the enabled state.
# clresourcegroup online -emM xserver-rg
Enables the resource group and moves it to the MANAGED state.
Specifies the name of the resource group.
Example 1-7 Configuring a SUNW.sap_xserver Resource
This example shows the sequence of commands that are required to configure an SAP xserver resource. The commands are run on only one cluster node.
The following command creates a scalable resource group to contain an SAP xserver resource for a four-node cluster. The resource group is named xsrvrrg. The xsrvrrg resource group can be brought online on all cluster nodes.
# clresourcegroup create \ -p Maximum_primaries=4 \ -p Desired_primaries=4 xsrvrrg
The following command adds the HAStoragePlus resource to the SAP xserver resource group. The xserver-storage-resource is called xsstorrs and the mount point, mtp1.
# clresource create -d -g xsrvrrg \ -t SUNW.HAStoragePlus \ -p filesystemmountpoints=mtp1 \ -p affinityon=false xsstorrs
The resource is created in the enabled state.
The following command creates an SAP xserver resource that is named xsrvrrs in the xsrvrrg resource group. The SAP xserver resource is an instance of the SUNW.sap_xserver resource type. The xserver-storage-resource is xsstorrs. The registration of this resource type is not shown in this example.
# clresource create -d -g xsrvrrg -t SUNW.sap_xserver \ -p resource_dependencies=xsstorrs xsrvrrs
The resource is created in the enabled state.
The following command moves the xsrvrrg resource group to the MANAGED state and brings the resource group online.
# clresourcegroup online -emM xsrvrrg
# clresourcetype register SUNW.sapdb
Ensure that the MaxDB resource depends on the following resources:
The HAStoragePlus resource for the global device group on which MaxDB is installed.
The SAP xserver resource.
When you create this resource, specify the following information about the MaxDB database instance. This information is created when MaxDB is installed and configured as explained in Installing and Configuring MaxDB.
The name of the MaxDB database.
The UNIX user identity of the OS user who administers the MaxDB database instance. If you are using MaxDB 7.5 or MaxDB 7.6, the UNIX user identity of the OS user who administers the MaxDB database is sdb.
The user key of the database user who administers the MaxDB database instance.
# clresource create -d -g sapdb-rg \ -t SUNW.sapdb \ -p DB_Name=db-name \ -p DB_User=os-sapdb-adm-user \ -p User_Key=sapdb-adm-key \ -p resource_dependencies=hsp-resource,xserver-resource sapdb-rs
Specifies that the resource that you are creating is not immediately enabled.
Specifies that the resource is to be added to the MaxDB resource group.
Specifies that the resource is an instance of the SUNW.sapdb resource type.
Specifies the name of the MaxDB database instance in uppercase.
Specifies the UNIX user identity of the OS user who administers the MaxDB database. This user's home directory contains the .XUSER.62 file that was created during the installation and configuration of MaxDB. For more information, see Installing and Configuring MaxDB.
Specifies the user key of the database user who administers the MaxDB database instance. This user key is created during the installation and configuration of MaxDB. For more information, see Installing and Configuring MaxDB.
Specifies that the MaxDB resource depends on the following resources.
The HAStoragePlus resource for the global device group on which MaxDB is installed
The SAP xserver resource
Specifies that the resource that you are creating is named sapdb-rs.
The resource is created in the enabled state.
To meet this requirement, create on the MaxDB resource group a strong positive affinity for the SAP xserver resource group.
# clresourcegroup set -p rg_affinities=++xserver-rg sapdb-rg
Specifies that the MaxDB resource group declares a strong positive affinity for the SAP xserver resource group.
Specifies that theMaxDB resource group is to be modified.
#clresourcegroup online -emM sapdb-rg
Enables the MaxDB resource group and moves it to the MANAGED state.
Specifies the name of the MaxDB resource group to be brought online.
You might plan to run lower-priority services on a node to which the MaxDB resource can fail over. In this situation, consider using resource group affinities to shut down the noncritical services when the MaxDB resource fails over to the node.
To specify this behavior, declare on the resource group for each noncritical service a strong negative affinity for the MaxDB resource group.
# clresourcegroup set -p rg_affinities=--sapdb-rg noncritical-rg
Sets the resource group property to the specified value.
Specifies the name of the noncritical resource group.
Example 1-8 Creating a SUNW.sapdb Resource
# clresource create -d -g sapdbrg -t SUNW.sapdb \ -p DB_Name=TST -p DB_User=dbadmin \ -p User_Key=DEFAULT -p resource_dependencies=hsprs,xsrvrrs sapdbrs
The resource is created in the enabled state.
This example shows the creation of a SUNW.sapdb resource that has the following characteristics:
The resource is named sapdbrs.
The resource is a member of a resource group that is named sapdbrg. The creation of this resource group is shown in Example 1-5.
The resource is an instance of the SUNW.sapdb resource type. The registration of this resource type is not shown in this example.
The MaxDB database instance that is associated with this resource is named TST.
The UNIX user identity of the OS user who administers the MaxDB database is dbadmin.
The user key of the database user who administers the MaxDB database is DEFAULT.
The MaxDB resource depends on the following resources:
An HAStoragePlus resource that is named hsprs. The creation of the hsprs resource is shown in Example 1-6.
A SUNW.sap_xserver resource that is named xsrvrrs. The creation of the xsrvrrs resource is shown in Example 1-7.