HP Serviceguard Toolkit for Oracle Data Guard instruction

HP Serviceguard Enterprise Cluster Master Toolkit User Guide

HP Part Number: 5900-1606

Published: April 2011

Edition: J06.03 and subsequent J-series RVUs, H06.03 and subsequent

Edition: H-series RVUs, and G06.24 and subsequent G-series RVUs

Image 1

HP Serviceguard Toolkit for Oracle Data Guard manual HP Serviceguard Enterprise Cluster Master Toolkit User Guide

Contents

HP Serviceguard Enterprise Cluster Master Toolkit User Guide Page Contents Using an Apache Toolkit in a HP Serviceguard Cluster Using MySQL Toolkit in a HP Serviceguard Cluster Using Samba Toolkit in a Serviceguard Cluster 125 Using Tomcat Toolkit in a HP Serviceguard Cluster 110Support and other resources 138 Introduction Overview Toolkit Name/Application Extension and Application Name Serviceguard Extension for SAP SGeSAP Supported versions Using the Oracle Toolkit in an HP Serviceguard Cluster Support For Oracle Database without ASM Setting Up The ApplicationSupport For Oracle Database without ASM Using the Oracle Toolkit in an HP Serviceguard Cluster For VxVM Or for use with Asynchronous disk access and file systems Legacy Package Scripts Setting Up the Toolkit Variable or Parameter Name in haoracle.conf file Haltscripttimeout is not defined then, it is the sum of all Instance is running. Default value is 30 secondsPackage Package failover times Available to the new shell Serviceguard ManagerValue is no Modular Package Scripts Toolkit Configuration File GeneratorGenerator Script described below Script tkitgen.sh Cluster Verification for Ecmt Oracle Toolkit Oracle Package Configuration Example If you are using CFS If you are using LVM or VxVM Volume Groups If you are using LVM Disk Groups If you are using VxVM Cmmodpkg -v -n nodename -R -s servicename packagename Packagename Sidname Packagename ORACLETEST0 ORACLEHOME=/ORACLETEST0 Files in ORACLETEST0 Supporting Oracle ASM instance and Oracle database with ASM What is Automatic Storage Management ASM? Supporting Oracle ASM instance and Oracle database with ASM Configuring LVM Volume Groups for ASM Disk Groups Why ASM over LVM? Sample Command Sequence for Configuring LVM Volume Groups Using the Oracle Toolkit in an HP Serviceguard Cluster Framework for ASM support with Serviceguard Serviceguard support for ASM on HP-UX 11i v3 onwards How Toolkit Starts, Stops and Monitors the Database instance Serviceguard Toolkit Internal File Structure Internal file structure for legacy packages ASM File Descriptor Release Installing, Configuring, and Troubleshooting Setting up DB instance and ASM instance Variables or Parameters in haoracle.conf file Setting Up the Toolkit From the Oracle configuration directory $ORACLEHOME/dbs or By defaultASM and the ASM database instance packages For both ASM instance and ASM database instance packages Be set in the ASM and database instance package Its package will not be failed over to the standby nodeASM and database instance packages ASM and database instance package Case of an ASM database instance package ASM Package Configuration ExampleManager Add in the customerdefinedhaltcmds function ASM Package Configuration Example LISTENERNAME=LSNRTEST0 LISTENERPASS= Configure the service parameters Servicefailfastenabled no servicehalttimeout Dependencylocation Samenode Using the Oracle Toolkit in an HP Serviceguard Cluster Support ASMHOME=/ASMTEST0 ORACLEADMIN, SIDNAME, LISTENER, Listenername Adding the Package to the Cluster Adding the Package to the Cluster Error Handling Node-specific ConfigurationNetwork Configuration Database Maintenance Database Maintenance $ cd /etc/cmcluster/pkg/ORACLETEST0/ $ $PWD/toolkit.sh stop Packages in a coexistence environment Attributes newly added to Ecmt Oracle toolkit Create the modular package configuration file pkg2.conf Asmsid +ASM Dependencylocationsamenode Supporting EBS database Tier Ecmt Oracle Toolkit Maintenance ModeSupporting EBS database Tier Oracle ASM Support for EBS DB Tier Sybase Information Setting up the Application Etc/passwd file Setting up the Application Sybase ASE attributes ASE Password for Login with system administrator capability ASE Login with system administrator capabilityDetails on configuring Role Based Access RBA Using the nowait option. The default value is wait Sybase Package Configuration Example Vg /dev/vg00SYBASE0 vg /dev/vg01SYBASE0 Nodename -R -s servicename packagename Creating the Serviceguard package using Modular method Parameters in Userrole Configuring Access RolesUser Role Description Allowed to perform cluster and package view operations Error-Handling MIG29 Following procedure should be used DB2 Information DB2 Information Root@hp46t191/home/rootkctune maxuprc=256 Node2 0 node2 Node2 1 node2 On other cluster nodes catalog the already created database Set up additional database logical volumes Multiple Instance ConfigurationsToolkit Overview Variables in hadb2.conf File Assuming DB2 is already installed DB2 Package Configuration ExamplePage Creating Serviceguard package using Modular method Edit the package configuration file Set theipaddress to a valid package IP. For example Creating Serviceguard package using legacy method Define the file systems which are used by the DB2 instance Nodename DB2 Package Files $ cmmodpkg -e db2payroll Main shell script Files in Legacy Packages in MySQLScript to monitor MySQL to ensure it is running Modular packages Using MySQL Toolkit in a HP Serviceguard Cluster MySQL Package Configuration OverviewADF File in Modular Package in MySQL Script Files Setting Up The Database Server Application Setting Up The Database Server Application Files in MySQL toolkit Setting Up MySQL with the ToolkitScripts used in Modular Method of Packaging Toolkit Configuration File hamysql.conf MySQL Configuration File my.cnfParameters in MySQL Configuration File my.cnf Package Configuration File Parameters Package Configuration File and Control ScriptUser Variables in hamysql.conf file Package Control Script Parameters Applying the Configuration and Running the Package Creating Serviceguard package using Modular method Cmmakepkg -s MySQL1.cntl control template Dos Dos and Dont with MySQL ToolkitDonts Files in Apache Toolkit Content of this Readme has been moved to this user guideScript that monitors the health of the Server application Files in Modular Method Packaging Local Configuration Apache Package Configuration OverviewShared Configuration Multiple Apache Instances Configuration Configuring the Apache Web Server with Serviceguard Configuring the Apache Web Server with Serviceguard Using an Apache Toolkit in a HP Serviceguard Cluster Setting up the package Setting up the package Dependencylocation Samenode Scripts in Legacy Packages Configuration Variables Toolkit User Configuration Creating Serviceguard package using Modular method Touch/etc/cmcluster/pkg/httppkg1/apache.debug Apache Web Server Maintenance Apache Web Server Maintenance Files in Tomcat Toolkit Using Tomcat Toolkit in a HP Serviceguard ClusterShell script Files For Modular Method of Packaging ADF File for Modular Method of Packaging111 Tomcat Package Configuration Overview Configuring the Tomcat server with Serviceguard Multiple Tomcat Instances ConfigurationShared Configuration Multiple Tomcat Instances Configuration Using Tomcat Toolkit in a HP Serviceguard Cluster Setting Up The Package For Example LVM Example 1 For example #mkdir /etc/cmcluster/pkg/tomcatpkg Legal Package Scripts User Configuration Variables Value is Are running. The default value will be 5 secondsValue will be Error Handling Tomcat Server Maintenance Hatomcat.conf FSUMOUNTOPT0= FSFSCKOPT0= Using Tomcat Toolkit in a HP Serviceguard Cluster 125 Scripts in Samba Directory Using Samba Toolkit in a Serviceguard Cluster HP Cifs Server Package Configuration OverviewAttribute Definition File ADF Scripts name Global Workgroup = hadomain Using Samba Toolkit in a Serviceguard Cluster $ mkdir /etc/cmcluster/smb1 Function customerdefinedruncmds # Start the HP Cifs Server Main script hasmb.sh Script Name DescriptionInterface script toolkit.sh to do the following Monitor process by calling hasmb.mon Creating Serviceguard package using Modular method NetBIOS ame can be found in /etc/opt/samba For example, NETBIOSNAME=smb1Smb.conf. If you are configuring multiple HP Cifs LOGDIRECTORY=/var/opt/samba/$NETBIOSNAME/logs Should be set to no. When Samba needs to be MAINTENANCEFLAG=yesProperly running after the maintenance phase Mode. Serviceguard A.11.19 release has a new Cifs Server Maintenance Mode Cifs Server Maintenance Mode Special Notes Special Notes Information to collect before contacting HP How to contact HPSupport and other resources Documentation feedback HP authorized resellersRelated information Typographic conventions Replaceable