HP Serviceguard Toolkit for Oracle Data Guard manual

Configuring a modular failover package for an Oracle database using ASM in a Coexistence Environment

To configure an ECMT modular failover package for an Oracle database:

1.Log in as the Oracle administrator and run the following command to set the database management policy to manual:

$ORACLE_HOME/bin/srvctl modify database -d <dbname> -y MANUAL

2.Create a database package directory under /etc/cmcluster Log in as root:

# mkdir /etc/cmcluster/db1_package

3.Create the modular package configuration file "pkg2.conf”:

#cmmakepkg -m ecmt/oracle/oracle pkg2.conf

4.Configure the package attributes as mentioned below:

package_name - Set to any name desired. package_type - Set to "failover".

Edit the service parameters if necessary. The service parameters are preset to:

service_name		oracle_service
service_cmd	"$SGCONF/scripts/ecmt/oracle/tkit_module.sh oracle_monitor"
service_restart		none
service_fail_fast_enabled		no
service_halt_timeout		300
service_name		oracle_listener_service
service_cmd	"$SGCONF/scripts/ecmt/oracle/tkit_module.sh oracle_monitor_listener"
service_restart		none
service_fail_fast_enabled		no
service_halt_timeout		300
service_name		oracle_hang_service
service_cmd		"$SGCONF/scripts/ecmt/oracle/tkit_module.sh oracle_hang_monitor 30
failover"
service_restart		none
service_fail_fast_enabled		no
service_halt_timeout		300

If the listener is configured, uncomment the second set of service parameters which are used to monitor the listener.

Edit the dependency parameters as shown:

dependency_name dependency_condition dependency_location

oc_dependency

<SGeRAC OC MNP Package name>=up same_node

Since LVM logical volumes are used in disk groups, specify the name(s) of the volume groups on which the ASM diskgroups reside, for the parameter "vg".

Configure the ip_subnet and ip_address parameters.

5.Configure the toolkit package attribute TKIT_DIR. This parameter is synonymous to the legacy package directory. On a cmapplyconf, TKIT_DIR will contain the toolkit configuration file haoracle.conf on all configured nodes.

Configure the other toolkit parameters for the database package as mentioned in this README for the database failover legacy package under “Supporting Oracle ASM instance and Oracle database with ASM” (page 26).

6.Configure the ASM Disk Group using the following attributes:

•Set attribute ASM to yes: ASM yes

•Specify all the ASM Disk Groups used by the database using the ASM_DISKGROUP attribute:

ASM_DISKGROUP[0] asm_dg1

54 Using the Oracle Toolkit in an HP Serviceguard Cluster