Manuals / HP / Computer Equipment / Software

HP Serviceguard Toolkit for Oracle Data Guard manual Contents

Models: Serviceguard Toolkit for Oracle Data Guard

1 140

Download 140 pages 15.58 Kb

Page 3

Contents
1 Introduction	6
Overview	6
2 Using the Oracle Toolkit in an HP Serviceguard Cluster	8
Overview	8
Supported versions	8
Support For Oracle Database without ASM	9
Setting Up The Application	9
Setting Up the Toolkit	13
Toolkit Overview	13
Support for multiple listeners	17
Support for database hang detection	17
Cluster Verification for ECMT - Oracle Toolkit	18
Oracle Package Configuration Example	18
Package Setup and Configuration	18
If you are using LVM or VxVM	19
If you are using CFS	19
If you are using LVM	20
If you are using VxVM	21
Supporting Oracle ASM instance and Oracle database with ASM	26
What is Automatic Storage Management (ASM)?	26
Why ASM over LVM?	28
Configuring LVM Volume Groups for ASM Disk Groups	28
Sample Command Sequence for Configuring LVM Volume Groups	29
Serviceguard support for ASM on HP-UX 11i v3 onwards	31
Framework for ASM support with Serviceguard	31
How Toolkit Starts, Stops and Monitors the Database instance	32
Serviceguard Toolkit Internal File Structure	33
ASM File Descriptor Release	35
Installing, Configuring, and Troubleshooting	35
Setting up DB instance and ASM instance	36
Setting Up the Toolkit	37
ASM Package Configuration Example	40
Modifying a legacy database package using an older version of Oracle ECMT scripts to use the
scripts provided for ASM support	47
Adding the Package to the Cluster	49
Node-specific Configuration	50
Error Handling	50
Network Configuration	50
Database Maintenance	51
Configuring and packaging Oracle single-instance database to co-exist with SGeRAC packages	52
Configuring Oracle single-instance database that uses ASM in a Coexistence Environment	52
Attributes newly added to ECMT Oracle toolkit	53
Configuring a modular failover package for an Oracle database using ASM in a Coexistence
Environment	54
Configuring a legacy failover package for an Oracle database using ASM in a Coexistence
Environment	55
ECMT Oracle Toolkit Maintenance Mode	57
Supporting EBS database Tier	57
Oracle ASM Support for EBS DB Tier	58

Contents 3

Image 3

HP Serviceguard Toolkit for Oracle Data Guard manual Contents

Contents

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