User's 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 oc_dependency
dependency_condition <SGeRAC OC MNP Package name>=up
dependency_location 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