Enterprise Cluster Master Toolkit User Guide April 2011 (5900-1606)

NOTE: When configuring a Oracle package in a SGeRAC cluster, command line interface

should be used to create the package and the Serviceguard Manager interface should not be

used.

a. Disable the Oracle database instance from being managed automatically by the Oracle

Clusterware.

management policy to manual:

For Oracle 10g:

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

For Oracle 11g:

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

b. Log in as root and create the database package directory:

# mkdir /etc/cmcluster/db1_package

c. Create the modular package configuration file db1pkg.conf by including the toolkit

attributes that need to be configured later by the user.

# cmmakepkg -m ecmt/Oracle/Oracle db1pkg.conf

Edit the package configuration file pkg.conf and configure the Serviceguard parameters

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

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

If the Oracle database is created on LVM logical volumes, specify the name(s) of the

volume groups for the parameter "vg".

Configure the ip_subnet and ip_address parameters.

d. Configure the toolkit parameter 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. For example, TKIT_DIR /etc/

cmcluster/db1_package.

Configure the other toolkit parameters for the database package for the database failover

legacy package.

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

46 Using the Oracle Toolkit in an HP Serviceguard Cluster