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.
Log in as the Oracle administrator and run the following command to set the database management policy to manual:
For Oracle 10g:
#$ORACLE_HOME/bin/srvctl modify database
#$ORACLE_HOME/bin/srvctl modify database
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
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:
