HP Serviceguard Toolkit for Oracle Data Guard guide

Table 2 Legacy Package Scripts (continued)

Script Name

Description

Listener Monitor Script (halistener.mon) This script will be called by haoracle.sh to monitor the configured listeners. The script makes use of a command supplied by Oracle to check the status of the listener.

Database Hang Monitor Scripts	The hadbhang.mon script will be called by haOracle.sh to monitor the
(hadbhang.mon, hagetdbstatus.sh,	Oracle instance for possible 'hung' state. hadbhang.mon script inturn uses
hatimeoutdbhang.sh)	hagetdbstatus.sh and hatimeoutdb hang.sh to check the database status.
Alert Notification Scriptv(SGAlert.sh)	This script is used to send an e-mail to the e-mail address specified by the
	value of the ALERT_MAIL_ID package attribute, whenever there are critical
	problems with the package.
Interface Script (toolkit.sh)	This script is the interface between the Serviceguard package control script
	and the Oracle toolkit.

Table 3 Variable or Parameter Name in haoracle.conf file

Variable/Parameter Name	Description
INSTANCE_TYPE	This parameter determines whether the instance is an ASM instance or a database
	instance. Set this parameter to "database".
ORACLE_HOME	The home directory of Oracle.
ORACLE_ADMIN	User name of the Oracle database administrator. This will be used for starting and
	stopping of the database.
SID_NAME	The Oracle session name. This is sometimes called the session ID (SID). (for example,
	ORACLE_TEST0) and uniquely identifies an Oracle database instance.
START_MODE	This parameter defines the Oracle database startup mode. Valid options are "no
	mount", "mount" and "open". Default mode is "open".
LISTENER	Set to "yes" if you want this toolkit to start and stop the Oracle Listener.
LISTENER_NAME	The name(s) of the listener process(es) (typically the SID_NAME )
LISTENER_PASS	The password(s) of the listener process(es).
LISTENER_RESTART	This parameter defines the number of attempts to be made to restart the listener. If the
	listener does not restart after "LISTENER_RESTART" number of consecutive attempts,
	the package will be failed over. If the listener restart is successful, then the next time
	listener fails, the toolkit again tries "LISTENER_RESTART" number of times to restart the
	listener.
PFILE	Oracle database parameter file. If not specified, Oracle picks this up from the Oracle
	configuration directory $ORACLE_HOME/dbs. This parameter when configured
	overrides the default file/location. If both pfile and spfile are present and this parameter
	left unspecified, then ECM Oracle Toolkit will make use of pfile as the parameter file.
	To make use of spfile in the toolkit do not configure this parameter and remove the
	default pfile from its default location.
MONITOR_PROCESSES	The names of all processes that should be executing.

14 Using the Oracle Toolkit in an HP Serviceguard Cluster

Image 14

HP Serviceguard Toolkit for Oracle Data Guard manual Variable or Parameter Name in haoracle.conf file

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