HP Serviceguard Toolkit for Oracle Data Guard manual

If you need help creating, importing, or managing the volume group or disk group and filesystem, see Building an HA Cluster Configuration in the Serviceguard user manual available at http://www.hp.com/go/hpux-serviceguard-docs-> HP Serviceguard.

•Configuring shared file system using CFS

The shared file system can be a CFS mounted file system.

To configure an Oracle package in a CFS environment, the Serviceguard CFS packages need to be running in order for the Oracle package to access CFS mounted file systems. Create a directory /ORACLE_TEST0 on all cluster nodes. Mount the CFS file system on /ORACLE_TEST0 using the Serviceguard CFS packages. Use /ORACLE_TEST0 to hold the necessary configuration information and symbolic links to the Oracle executables.

NOTE: For information on other Volume Managers, see the Managing ServiceGuard manual available at http://www.hp.com/go/hpux-serviceguard-docs —>HP Serviceguard manual.

4.The control files, table spaces, and redo-log files must be located in the file system

/ORACLE_TEST0 during the initial creation of the database. It is also recommended to configure trace files and alert logs in /ORACLE_TEST0 for ease of manageability. See Oracle documentation for information on setting up trace files and alert logs.

5.ORACLE_HOME=/ORACLE_TEST0 needs to be set in the toolkit configuration file haoracle.conf.

6./ORACLE_TEST0/dbs is the configuration directory for the 'ORACLE_TEST0' database. This directory contains the Oracle parameter file (pfile/spfile) and the password file for ORACLE_TEST0.

Symbolic links need to be created for all subdirectories in /home/Oracle other than dbs, like "/ORACLE_TEST0/bin --> /home/Oracle/bin" and so on.

10 Using the Oracle Toolkit in an HP Serviceguard Cluster

Image 10

HP Serviceguard Toolkit for Oracle Data Guard manual Using the Oracle Toolkit in an HP Serviceguard Cluster

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