HP Serviceguard Toolkit for Oracle Data Guard specification

NOTE: This setup is not supported if Oracle 10g Release 1 is configured with LVM or VxVM. If Oracle 10g Release 1 is configured with LVM or VxVM then local configuration is recommended. The above configuration is supported in Oracle 10g Release 2 and Oracle 11g, but subject to a condition that Oracle's Automatic Storage Management (ASM) is not configured on that node.

◦If you are using CFS:

In this setup, Oracle can be optionally installed on a CFS mounted file system (/ORACLE_TEST0, in our example) with all Oracle binaries and configuration files in a CFS mounted file system.

NOTE: An Oracle license must be installed on every node that might potentially run Oracle in the cluster.

•Set up additional database logical volumes, with LVM

It is possible to have the database reside on the same volume group or logical volume as $ORACLE_HOME/dbs, but more commonly, the database will probably reside on several volume groups and logical volumes, which all need to be shared among the nodes that are able to run the Oracle instances. Again, using a naming convention for the volume group(s) that includes the instance name (${SID_NAME}) could be used to associate a volume group with a unique instance.

For example:

Raw disk access for Oracle data:

/dev/vg01_ORACLE_TEST0/rlvol1	# Raw logical volume Oracle data
/dev/vg02_ORACLE_TEST0/rlvol1	#	Raw logical volume Oracle data
/dev/vg02_ORACLE_TEST0/rlvol2	#	Raw logical volume Oracle data

or for use with Asynchronous disk access and file systems:

/dev/vg01_ORACLE_TEST0/lvol1	# Logical volume Oracle data
/dev/vg02_ORACLE_TEST0/lvol1	#	Logical	volume	Oracle	data
/dev/vg02_ORACLE_TEST0/lvol2	#	Logical	volume	Oracle	data

See the Oracle documentation to determine which format is more appropriate for your environment.

All data belonging to the database must reside on shared logical volumes (raw or file system), space needs to be allocated and shared for the following data:

◦Oracle tablespaces

◦Oracle rollback segments

◦Oracle logfiles

After defining the shared volume groups/logical volumes/file systems for these entities, see the Oracle documentation for creating the database.

12 Using the Oracle Toolkit in an HP Serviceguard Cluster

Image 12

HP Serviceguard Toolkit for Oracle Data Guard manual Or for use with Asynchronous disk access and file systems

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 Tomcat Toolkit in a HP Serviceguard Cluster 110 Using Samba Toolkit in a Serviceguard Cluster 125Support 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 Setting Up The Application Support For Oracle Database without ASMSupport 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 Instance is running. Default value is 30 seconds Haltscripttimeout is not defined then, it is the sum of allPackage Package failover times Serviceguard Manager Available to the new shellValue is no Toolkit Configuration File Generator Modular Package ScriptsGenerator Script described below 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 By default From the Oracle configuration directory $ORACLEHOME/dbs orASM and the ASM database instance packages For both ASM instance and ASM database instance packages Its package will not be failed over to the standby node Be set in the ASM and database instance packageASM and database instance packages ASM and database instance package ASM Package Configuration Example Case of an ASM database instance packageManager 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 Node-specific Configuration Error HandlingNetwork 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 Ecmt Oracle Toolkit Maintenance Mode Supporting EBS database TierSupporting 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 ASE Login with system administrator capability ASE Password for 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 Creating the Serviceguard package using Modular method Nodename -R -s servicename packagename Configuring Access Roles Parameters in UserroleUser 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 Multiple Instance Configurations Set up additional database logical volumesToolkit 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 Files in Legacy Packages in MySQL Main shell scriptScript to monitor MySQL to ensure it is running Modular packages MySQL Package Configuration Overview Using MySQL Toolkit in a HP Serviceguard ClusterADF File in Modular Package in MySQL Script Files Setting Up The Database Server Application Setting Up The Database Server Application Setting Up MySQL with the Toolkit Files in MySQL toolkitScripts used in Modular Method of Packaging MySQL Configuration File my.cnf Toolkit Configuration File hamysql.confParameters in MySQL Configuration File my.cnf Package Configuration File and Control Script Package Configuration File ParametersUser 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 and Dont with MySQL Toolkit DosDonts Content of this Readme has been moved to this user guide Files in Apache ToolkitScript that monitors the health of the Server application Files in Modular Method Packaging Apache Package Configuration Overview Local ConfigurationShared 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 Using Tomcat Toolkit in a HP Serviceguard Cluster Files in Tomcat ToolkitShell script ADF File for Modular Method of Packaging Files For Modular Method of Packaging111 Tomcat Package Configuration Overview Multiple Tomcat Instances Configuration Configuring the Tomcat server with ServiceguardShared Configuration 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 Are running. The default value will be 5 seconds Value isValue will be Tomcat Server Maintenance Error Handling Hatomcat.conf FSUMOUNTOPT0= FSFSCKOPT0= Using Tomcat Toolkit in a HP Serviceguard Cluster Scripts in Samba Directory 125 HP Cifs Server Package Configuration Overview Using Samba Toolkit in a Serviceguard ClusterAttribute 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 Script Name Description Main script hasmb.shInterface script toolkit.sh to do the following Monitor process by calling hasmb.mon Creating Serviceguard package using Modular method For example, NETBIOSNAME=smb1 NetBIOS ame can be found in /etc/opt/sambaSmb.conf. If you are configuring multiple HP Cifs LOGDIRECTORY=/var/opt/samba/$NETBIOSNAME/logs MAINTENANCEFLAG=yes Should be set to no. When Samba needs to beProperly 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 How to contact HP Information to collect before contacting HPSupport and other resources HP authorized resellers Documentation feedbackRelated information Typographic conventions Replaceable