HP Serviceguard Toolkit for SAP Sybase ASE and SAP Sybase Replication Server for Linux User Guide Version A.12.00.00 Abstract This guide describes instructions for integrating a Sybase Adaptive Server Enterprise, Sybase Replication Server, and Disaster Recovery Agent instances with HP Serviceguard to achieve high availability.
© Copyright 2014 Hewlett-Packard Development Company, L.P. Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor's standard commercial license. The information contained herein is subject to change without notice.
Contents 1 Overview..................................................................................................5 Advantages.............................................................................................................................6 Prerequisites.............................................................................................................................6 Related documentation...............................................................................................
A Example: Sybase ASE package attributes....................................................35 B Example: Sybase RS package attributes.......................................................37 C Example: Sybase DRA package attributes...................................................39 D Example: Combined RS and DRA package attributes....................................41 Index.........................................................................................................
1 Overview The HP Serviceguard Toolkit for SAP Sybase Adaptive Server Enterprise (ASE) and SAP Sybase Replication Server on Linux (Sybase toolkit) allows you to integrate standalone SAP Sybase ASE database instances with HP Serviceguard cluster environment. To achieve high availability to Replication Server instances and DR Agent, you can integrate SAP Sybase Replication Server instance and its associated Disaster Recovery (DR) Agent with HP Serviceguard cluster environment.
Advantages Following are the possible advantages when Sybase ASE and Sybase Replication Server is deployed in a Serviceguard cluster using the Sybase toolkit: • Enables easy integration of Sybase ASE and Sybase Replication Server applications in a highly available Serviceguard cluster on Linux. • Provides high availability for the SAP Sybase ASE, RS, and DR Agent. • Provides option to validate certain toolkit attribute values specified in the package configuration file.
ERROR: admin user does not exist • Verify if the following attributes are installed on a local disk: ◦ Install home directory: INSTALL_HOME ◦ Install path directory: INSTALL_PATH ◦ Open Client server install path: OCS_INSTALL_PATH ◦ Password file: PASSWD_FILE ◦ Run scripts: RUNSCRIPT ◦ Interactive SQL executable: {OCS_INSTALL_PATH}/bin/isql To verify Sybase toolkit package for RS and DRA modules: • Verify the HEALTHCHK_CMD and HEALTHCHK_RESULT attributes for RS and
• Improper configuration of health check command or expected health check result for RS and DRA modules. • Any of the server instance processes being monitored is not running. • Server instance health is not in expected state.
2 Installing and upgrading the Sybase toolkit Installing the Sybase toolkit You must install the toolkit RPM on all the package nodes to run the Sybase toolkit package. For example: To install the Sybase toolkit version A.12.00.00-00, run the following command: For RHEL: rpm -ivh serviceguard-sybase-toolkit-A.12.00.00-00.redhat.noarch.rpm For SLES: rpm -ivh serviceguard-sybase-toolkit-A.12.00.00-00.sles.noarch.
Table 3 Files created for Sybase toolkit (continued) File name Description Directory These process names are contained in the MONITOR_PROCESS package parameter. To include and monitor other required process, update the MONITOR_PROCESS package parameter. hadra.sh This script contains functions to start and stop DR Agent processes. Also, this script manages online package re-configurations and attribute validations.
RHEL: • ase -> /usr/local/cmcluster/conf/modules/tkit/sybase/ase.1 • rs -> /usr/local/cmcluster/conf/modules/tkit/sybase/rs.1 • dra -> /usr/local/cmcluster/conf/modules/tkit/sybase/dra.1 NOTE: You can find the soft links in the $SGCONF/modules/tkit/sybase/ directory. Upgrading the Sybase toolkit IMPORTANT: The cmupgrade command is a new tool introduced in HP Serviceguard for Linux A.12.00.
3 Configuring SAP Sybase ASE and SAP Sybase Replication Server This chapter provides information about supported configurations and describes the steps to configure Sybase software in a Serviceguard cluster. Supported configuration for standalone ASE server instance There are two supported configuration for standalone ASE server instance.
Figure 2 Cluster Node running Multiple ASE DB instances Cluster 1 Failover ASE1 ASE2 Database 1 Database 2 NOTE: Figure 1 (page 12) and Figure 2 (page 13) shows only two nodes. The cluster can contain two or more than two nodes. Supported configuration for SAP Sybase Replication Server A disaster recovery environment consists of two sites, the primary and the standby. Both sites contain the Adaptive Server data. Each site contains a Replication Server and a DR Agent.
Figure 3 Single ASE DB instance Cluster 1 Cluster 2 Failover Failover ASE-P ASE-S RS-P RS-S Primary DB ASE-P - ASE Primary Standby DB RS-P - RS Primary ASE-S - ASE Secondary RS-S - RS Secondary HA to Primary and HA to Standby - Multiple ASE DB instances on the same node The configuration shown in Figure 4 (page 15) is same as the configuration in Figure 3 (page 14).
Figure 4 Multiple ASE DB instances on the same node Cluster 1 Cluster 2 Failover Failover ASE1-P ASE1-S RS1-P RS1-S ASE2-P ASE2-S RS2-P RS2-S PDB1 SDB1 PDB2 SDB2 ASE-P - ASE Primary RS-P - RS Primary ASE-S - ASE Secondary RS-S - RS Secondary Configuring Sybase software This section explains different Sybase software configurations. Sybase software binaries must be accessible from the INSTALL_HOME directory on all the nodes in a cluster that runs the package.
Shared configuration The Sybase ASE/RS software is installed on the shared storage (LVM), which is shared across all the package nodes of a cluster. NOTE: • In both the configurations, shared and Non-shared, the database must be configured on the shared storage and must be visible on all the package nodes of a cluster. • HP recommends that you install the software on the local disks for easy software upgrade, and to eliminate the Single Point Of Failure of the software installation disk.
For a re-locatable IP-address, you must edit this interface entry as follows: RS1 master tcp ether 192.168.10.1 4904 query tcp ether 192.168.10.1 4904 The re-locatable or virtual IP-address might be added in to the /etc/hosts directory and the alias name can be mentioned as package name. For example, /etc/hosts entry: 192.168.10.1 rs1 Here, rs1 is the package name.
4 Creating the Sybase toolkit package You can create a Serviceguard toolkit package to manage the Sybase server instances. After installing the Sybase toolkit, you can use the toolkit to: • Create Sybase ASE package • Create Sybase RS package • Create DRA package Creating a Serviceguard toolkit package To create a Serviceguard toolkit package: 1. Create a directory to hold all the package related files. 2. Run the cd command to change to the package directory. 3.
NOTE: The disk or storage device must be available to all the cluster nodes that are configured to run the Sybase ASE database instances. For more information about Sybase ASE package attributes, see Table 5 (page 19). Table 5 Sybase ASE package attributes Attribute Description INSTALL_HOME This attribute defines the Sybase root directory location where the Sybase ASE products are installed. This attribute must be set for sourcing SYBASE ENV variables and Sybase ASE instance to start.
Table 5 Sybase ASE package attributes (continued) Attribute Description For example: tkit/sybase/ase/RUNSCRIPT /opt/sybase/ASE-15_0/install/RUN_ASESERVER1 PASSWD_FILE This attribute defines the input file for password of Sybase ASE. This attribute specifies the full path and name of a file consisting password of Sybase ASE user for shutting down ASE instance, using shutdown command of Open Client server through TDS protocol, and health check of Sybase ASE.
Creating Sybase RS package (Replication Server environment) To create Sybase RS package, run the cmmakepkg -m tkit/sybase/rs rs1_pkg.ascii command. This command creates a package configuration template file (rs1_pkg.ascii). Edit the template file created and specify appropriate values for all the required attributes to create a Serviceguard package to manage Sybase RS instance. For additional information about the Sybase RS package attributes, see Table 6 (page 21).
Table 6 Sybase RS package attributes (continued) Attribute Description ADMIN_NAME This attribute defines the Linux user name of the Sybase RS administrator to start, stop, and verify health check of Replication Server using /bin/su command. This attribute cannot be modified online. For example: tkit/sybase/rs/ADMIN_NAME USER_NAME sybaseadmin This attribute specifies the login name of a Sybase RS user to connect to the Replication Server instance through an Open Client server's TDS protocol.
Table 6 Sybase RS package attributes (continued) Attribute Description node when there is failure in Sybase RS processes and exit. You must provide atleast one process to monitor the service monitors. For example: tkit/sybase/rs/MONITOR_PROCESS repserver tkit/sybase/rs/MONITOR_PROCESS dbsrv12 See “Example: Sybase RS package attributes” (page 37) for the sample configuration file of Sybase RS package.
Table 7 Sybase DRA package attributes (continued) Attribute Description For example: tkit/sybase/dra/RETRY_TIME INSTALL_HOME 3 This is the installation directory path for the Sybase RS product. You must set this attribute for sourcing SYBASE environment variables and Sybase DRA process to start. This attribute cannot be modified online.
Table 7 Sybase DRA package attributes (continued) Attribute Description PASSWD_FILE This attribute defines the full path and name of a file containing password for DRA user. First line of this file contains a password for a Sybase DRA user. This password is used to connect to DR Agent process associated with particular RS. For example: tkit/sybase/dra/PASSWD_FILE /sybase/SRS_REP/DRA-passwd.file UNIQ_MONITOR_LABEL This is the unique label to match the DR Agent process with correct Sybase RS instance.
1. 2. If you want to include RS and DRA modules in a single package run the cmmakepkg -m tkit/sybase/rs -m tkit/sybase/dra rs1_dra1_pkg.ascii command. If you want to include ASE, RS, and DRA in one package, then you must include all the three modules while executing the cmmakepkg command. For example: cmmakepkg -m tkit/sybase/ase -m tkit/sybase/rs -m tkit/sybase/dra ase1_rs1_dra1_pkg.ascii NOTE: HP recommends that you create a separate package for ASE and one single package for RS and DRA.
5 Managing the Sybase toolkit package This section provides information about managing the Sybase toolkit package. The following steps are applicable for all Sybase toolkit packages. Running a package After adding the package to a Serviceguard cluster, start the package using the cmrunpkg command. For example: # cmrunpkg rs1 This command starts the rs1 package and the associated application instances.
# cmgetconf -p <> <> 2. Back up this latest configuration file using a copy utility. This allows the user to refer to the previous configuration values. For example: # cp -p <> <> 3. 4. Edit the <> configuration file to modify the required attribute values. Run the cmcheckconf command to verify the package configuration file.
Table 8 Modules affected during online addition (continued) Activate the disk: #vgchange -a y vg_dd1 Run the following commands: #e2fsck -y /dev/vg_dd1/lvol1 #mount -t ext3 /dev/vg_dd1/lvol2 /mnt1 Adding an IP sg/package_ip to the package (package_ip.sh) If an IP address which is added to the package configuration failed to add or not attempted, use the cmmodnet command to add the IP address. To add the IP to the package 10.149.2.5: #cmmodnet -a -I 10.149.2.5 10.149.2.
This command deletes the package rs1 after user confirmation.
6 Troubleshooting This section explains some of the problem scenarios that you might encounter while working with the Sybase toolkit. Problem scenario Possible cause Recommended action "ERROR: <> admin user <> does not exist" The Linux user, <> specified as Administrative user for ASE/RS/DRA module does not exist on a package node. Verify the user you have specified is correct. If it is incorrect, add user into the Linux server by using the useradd command.
7 Removing the Sybase toolkit This section describes the procedure to remove the Sybase toolkit. NOTE: Before remove the Sybase toolkit, delete all the packages that were created by using the Sybase toolkit. To retrieve the version of the Sybase toolkit, run the following command: # rpm –qa | grep sybase-toolkit To remove the Sybase toolkit, run the following command: # rpm -e <> For example: # rpm -e serviceguard-sybase-toolkit-A.12.00.00-00.
8 Support and other resources Information to collect before contacting HP Ensure that the following information is available before you contact HP: • Software product name • Hardware product model number • Operating system type and version • Applicable error message • Third-party hardware or software • Technical support registration number (if applicable) How to contact HP Use the following methods to contact HP technical support: • In the United States, see the Customer Service or Contact HP U
Computer output Information displayed by the computer. Ctrl+x or Ctrl-x A key sequence that indicates you must hold down the keyboard key labeled Ctrl while you press the letter x. ENVIRONMENT VARIABLE The name of an environment variable, for example, PATH. Key The name of a keyboard key. Return and Enter both refer to the same key. Term A term or phrase that is defined in the body text of the document, not in a glossary. User input Indicates commands and text that you type exactly as shown.
A Example: Sybase ASE package attributes The following is an example of specifying Sybase ASE Package attributes: package_name ase_1 package_description "Serviceguard Package" module_name sg/basic module_version 1 module_name tkit/sybase/ase module_version 1 module_name sg/service module_version 1 module_name sg/email module_version 1 module_name sg/all module_version 2 module_name sg/failover module_version 1 module_name sg/priority module_version 1 module_name sg/dependency module_version 1 module_name sg
tkit/sybase/ase/CONSOLE_LOGFILE /opt/sybase/ASE-15_0/install/log tkit/sybase/ase/ADMIN_NAME sybadmin tkit/sybase/ase/USER_NAME sa tkit/sybase/ase/INSTANCE_NAME ASE1 tkit/sybase/ase/RUNSCRIPT /opt/sybase/ASE-15_0/install/RUN_ASE1 tkit/sybase/ase/SHUTDOWN_IN_FILE /opt/sybase/ASE-15_0/shutdown-file tkit/sybase/ase/MONITOR_PROCESSES dataserver tkit/sybase/ase/MONITOR_INTERVAL 30 tkit/sybase/ase/TIME_OUT 30 tkit/sybase/ase/RECOVERY_TIMEOUT 30 service_name ase_service2 service_cmd "$SGROOT/sybasetoolkit/haase.
B Example: Sybase RS package attributes The following is an example for specifying Sybase RS package attributes, when the package includes only RS module.
tkit/sybase/rs/CONSOLE_LOGFILE /opt/SYBASE_RS/REP-15_5/install/log tkit/sybase/rs/ADMIN_NAME sybadmin tkit/sybase/rs/USER_NAME sa tkit/sybase/rs/LISTENER_PORT 4904 tkit/sybase/rs/HEALTHCHK_CMD "admin health" tkit/sybase/rs/HEALTHCHK_RESULT NORMAL tkit/sybase/rs/PASSWD_FILE /opt/SYBASE_RS/REP-15_5/shutdown-file.
C Example: Sybase DRA package attributes The following is an example for specifying Sybase DRA package attributes, when the package includes only DRA module.
tkit/sybase/dra/UNIQ_MONITOR_LABEL "/opt/SYBASE_RS/SCC-3_2" tkit/sybase/dra/RUNSCRIPT /opt/SYBASE_RS/SCC-3_2/bin/scc.sh tkit/sybase/dra/MONITOR_PROCESS com.sybase.ua.startup service_name dra1_service service_cmd "$SGROOT/sybasetoolkit/hadra.sh dra_monitor" service_restart none service_fail_fast_enabled no service_halt_timeout 300 email_id root@ipl3.sgblr.
D Example: Combined RS and DRA package attributes The following is an example for specifying Sybase RS and DRA package attributes, when the package includes both RS and DRA modules.
tkit/sybase/rs/RS_INSTALL_PATH /sybase/REP-15_5 tkit/sybase/rs/OCS_INSTALL_PATH /sybase/OCS-15_0 tkit/sybase/rs/CONSOLE_LOGFILE /sybase/REP-15_5/install/RS-console.
Index A ADMIN_NAME, 19 ASE_INSTALL_PATH, 19 C Cluster verification, 6 CONSOLE_LOGFILE, 19 D Deleting a package, 29 H HA, 13 I INSTALL_HOME, 19 Installing and upgrading the Sybase toolkit, 9 INSTANCE_NAME, 19 L LVM, 16 M MONITOR_INTERVAL, 20 MONITOR_PROCESSES, 20 N Non-shared configuration, 15 O OCS_INSTALL_PATH, 19 Online modification, 27 P PASSWD_FILE, 20 R RECOVERY_TIMEOUT, 20 RETRY_TIME, 20 RUNSCRIPT, 19 S SAP Sybase SAP Sybase ASE SAP Sybase RS, 5 Shared configuration, 16 T TIME_OUT, 20 Trou
