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
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
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
