HP Serviceguard Toolkit for Oracle Data Guard manual

following procedure should be used:

NOTE: The example assumes that the package name is SYBASE0, the package directory is /opt/cmcluster/pkg/SYBASE0, and the SYBASE_HOME is configured as /SYBASE0.

•Disable the failover of the package through cmmodpkg command: $ cmmodpkg -d SYBASE0

•Pause the monitor script.

Create an empty file <TKIT_DIR>/sybase.debug as shown below: $ touch <TKIT_DIR>/sybase.debug

The toolkit monitors script, that continuously checks the Sybase ASE process, would now stop monitoring this process. A message, "Sybase ASE toolkit pausing monitoring and entering maintenance mode" appears in the Serviceguard Package Control script log.

•If required, stop the Sybase ASE database instance as shown below:

$ export SG_PACKAGE=SYBASE0

$ $SGCONF/scripts/ecmt/sybase/tkit_module.sh stop

•Perform maintenance actions (for example, changing the configuration parameters in the parameter file of the Sybase ASE instance. If this file is changed, remember to distribute the new file to all cluster nodes).

•Start the Sybase ASE database instance again if it has been stopped:

$ export SG_PACKAGE=SYBASE0

$ SGCONF/scripts/ecmt/sybase/tkit_module.sh start

•Allow monitoring scripts to continue normally as shown below: $ rm -f /opt/cmcluster/pkg/SYBASE0/sybase.debug

A message "Starting Sybase ASE toolkit monitoring again after maintenance" appears in the Serviceguard Package Control script log.

•Enable the package failover: $ cmmodpkg -e SYBASE0

NOTE: 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. See the manual Managing ServiceGuard manual available at http://www.hp.com/go/hpux-serviceguard-docs —>HP Serviceguard for more details.

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

70 Using the Sybase ASE Toolkit in a Serviceguard Cluster on HP-UX

Image 70

HP Serviceguard Toolkit for Oracle Data Guard manual Following procedure should be used

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 Using Samba Toolkit in a Serviceguard Cluster 125 Using Tomcat Toolkit in a HP Serviceguard Cluster 110Support and other resources 138 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 Available to the new shell Serviceguard ManagerValue is no 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 Case of an ASM database instance package ASM Package Configuration ExampleManager 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 Error Handling Node-specific ConfigurationNetwork Configuration 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 Set up additional database logical volumes Multiple Instance ConfigurationsToolkit Overview 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 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 Creating Serviceguard package using Modular method Applying the Configuration and Running the Package 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 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 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 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 is Are running. The default value will be 5 secondsValue will be 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 Information to collect before contacting HP How to contact HPSupport and other resources Related information HP authorized resellersDocumentation feedback Typographic conventions Replaceable