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