HP Serviceguard Toolkit for Oracle Data Guard instruction

$ cd /etc/cmcluster/pkg/db2_pkg/ $ $PWD/toolkit.sh start

•Enable monitoring scripts to continue monitoring by removing db2.debug file: $ rm -f /etc/cmcluster/pkg/db2_pkg/db2.debug

The message "Starting DB2 toolkit monitoring again after maintenance" appears in the Serviceguard Package Control script log.

•Enable the package failover:

$ cmmodpkg -e db2_payroll

If the package fails during maintenance (for example, the node crashes) the package will not automatically fail over to an adoptive node. It is the responsibility of the user to start the package up on an adoptive node. For more information, see Managing ServiceGuard manual available at http://www.hp.com/go/hpux-serviceguard-docs —>HP Serviceguard .

This feature is enabled only when the configuration variable MAINTENANCE_FLAG is set to "yes" in the DB2 toolkit configuration file.

86 Using the DB2 database Toolkit in a Serviceguard Cluster in HP-UX

Image 86

HP Serviceguard Toolkit for Oracle Data Guard manual $ cmmodpkg -e db2payroll

Contents

HP Serviceguard Enterprise Cluster Master Toolkit User Guide Page Contents Using MySQL Toolkit in a HP Serviceguard Cluster Using an Apache Toolkit in a HP Serviceguard Cluster Support and other resources 138 Using Tomcat Toolkit in a HP Serviceguard Cluster 110Using Samba Toolkit in a Serviceguard Cluster 125 Overview Introduction Serviceguard Extension for SAP SGeSAP Toolkit Name/Application Extension and Application Name Using the Oracle Toolkit in an HP Serviceguard Cluster Supported versions 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 Setting Up the Toolkit Legacy Package Scripts Variable or Parameter Name in haoracle.conf file Package Instance is running. Default value is 30 secondsHaltscripttimeout is not defined then, it is the sum of all Package failover times Value is no Serviceguard ManagerAvailable to the new shell Generator Script described below Toolkit Configuration File GeneratorModular Package Scripts Script tkitgen.sh Oracle Package Configuration Example Cluster Verification for Ecmt Oracle Toolkit If you are using LVM or VxVM If you are using CFS If you are using LVM Volume Groups If you are using VxVM Disk Groups Cmmodpkg -v -n nodename -R -s servicename packagename Packagename Sidname Packagename ORACLETEST0 ORACLEHOME=/ORACLETEST0 Files in ORACLETEST0 What is Automatic Storage Management ASM? Supporting Oracle ASM instance and Oracle database with ASM Supporting Oracle ASM instance and Oracle database with ASM Why ASM over LVM? Configuring LVM Volume Groups for ASM Disk Groups Sample Command Sequence for Configuring LVM Volume Groups Using the Oracle Toolkit in an HP Serviceguard Cluster Serviceguard support for ASM on HP-UX 11i v3 onwards Framework for ASM support with Serviceguard How Toolkit Starts, Stops and Monitors the Database instance Serviceguard Toolkit Internal File Structure Internal file structure for legacy packages Installing, Configuring, and Troubleshooting ASM File Descriptor Release Setting up DB instance and ASM instance Setting Up the Toolkit Variables or Parameters in haoracle.conf file ASM and the ASM database instance packages By defaultFrom the Oracle configuration directory $ORACLEHOME/dbs or For both ASM instance and ASM database instance packages ASM and database instance packages Its package will not be failed over to the standby nodeBe set in the ASM and database instance package ASM and database instance package Manager ASM Package Configuration ExampleCase of an ASM database instance package ASM Package Configuration Example Add in the customerdefinedhaltcmds function LISTENERNAME=LSNRTEST0 LISTENERPASS= Configure the service parameters Servicefailfastenabled no servicehalttimeout Dependencylocation Samenode Using the Oracle Toolkit in an HP Serviceguard Cluster ASMHOME=/ASMTEST0 Support ORACLEADMIN, SIDNAME, LISTENER, Listenername Adding the Package to the Cluster Adding the Package to the Cluster Network Configuration Node-specific ConfigurationError Handling Database Maintenance Database Maintenance $ cd /etc/cmcluster/pkg/ORACLETEST0/ $ $PWD/toolkit.sh stop Attributes newly added to Ecmt Oracle toolkit Packages in a coexistence environment 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 Setting up the Application Etc/passwd file Sybase ASE attributes Details on configuring Role Based Access RBA ASE Login with system administrator capabilityASE Password for Login with system administrator capability Using the nowait option. The default value is wait Sybase Package Configuration Example Vg /dev/vg00SYBASE0 vg /dev/vg01SYBASE0 Creating the Serviceguard package using Modular method Nodename -R -s servicename packagename User Role Description Configuring Access RolesParameters in Userrole 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 Toolkit Overview Multiple Instance ConfigurationsSet up additional database logical volumes Variables in hadb2.conf File DB2 Package Configuration Example Assuming DB2 is already installedPage 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 Script to monitor MySQL to ensure it is running Files in Legacy Packages in MySQLMain shell script Modular packages ADF File in Modular Package in MySQL MySQL Package Configuration OverviewUsing MySQL Toolkit in a HP Serviceguard Cluster Script Files Setting Up The Database Server Application Setting Up The Database Server Application Scripts used in Modular Method of Packaging Setting Up MySQL with the ToolkitFiles in MySQL toolkit Parameters in MySQL Configuration File my.cnf MySQL Configuration File my.cnfToolkit Configuration File hamysql.conf User Variables in hamysql.conf file Package Configuration File and Control ScriptPackage Configuration File Parameters Package Control Script Parameters Creating Serviceguard package using Modular method Applying the Configuration and Running the Package Cmmakepkg -s MySQL1.cntl control template Donts Dos and Dont with MySQL ToolkitDos Script that monitors the health of the Server application Content of this Readme has been moved to this user guideFiles in Apache Toolkit Files in Modular Method Packaging Shared Configuration Apache Package Configuration OverviewLocal 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 Toolkit User Configuration Configuration Variables Creating Serviceguard package using Modular method Apache Web Server Maintenance Touch/etc/cmcluster/pkg/httppkg1/apache.debug Apache Web Server Maintenance Shell script Using Tomcat Toolkit in a HP Serviceguard ClusterFiles in Tomcat Toolkit 111 ADF File for Modular Method of PackagingFiles For Modular Method of Packaging Tomcat Package Configuration Overview Shared Configuration Multiple Tomcat Instances ConfigurationConfiguring the Tomcat server with Serviceguard Multiple Tomcat Instances Configuration Using Tomcat Toolkit in a HP Serviceguard Cluster Setting Up The Package For Example Example 1 For example LVM #mkdir /etc/cmcluster/pkg/tomcatpkg User Configuration Variables Legal Package Scripts Value will be Are running. The default value will be 5 secondsValue is Tomcat Server Maintenance Error Handling Hatomcat.conf FSUMOUNTOPT0= FSFSCKOPT0= Using Tomcat Toolkit in a HP Serviceguard Cluster Scripts in Samba Directory 125 Attribute Definition File ADF HP Cifs Server Package Configuration OverviewUsing Samba Toolkit in a Serviceguard Cluster Scripts name Global Workgroup = hadomain Using Samba Toolkit in a Serviceguard Cluster $ mkdir /etc/cmcluster/smb1 Function customerdefinedruncmds # Start the HP Cifs Server Interface script toolkit.sh to do the following Script Name DescriptionMain script hasmb.sh Monitor process by calling hasmb.mon Creating Serviceguard package using Modular method Smb.conf. If you are configuring multiple HP Cifs For example, NETBIOSNAME=smb1NetBIOS ame can be found in /etc/opt/samba LOGDIRECTORY=/var/opt/samba/$NETBIOSNAME/logs Properly running after the maintenance phase MAINTENANCEFLAG=yesShould be set to no. When Samba needs to be Mode. Serviceguard A.11.19 release has a new Cifs Server Maintenance Mode Cifs Server Maintenance Mode Special Notes Special Notes Support and other resources How to contact HPInformation to collect before contacting HP Related information HP authorized resellersDocumentation feedback Typographic conventions Replaceable