HP Serviceguard Enterprise Cluster Master Toolkit User Guide, December 2012 (5900-2145)

Setting up the Toolkit
Toolkit Overview
Use swinstall to properly install both Serviceguard and the Enterprise Cluster Master Toolkit (referred
to as the ECMT), which includes the scripts for Oracle.
After installing the toolkit, six scripts and a README file is created in the/opt/cmcluster/
toolkit/oracle directory. Two more scripts and one file is installed that is used only for modular
packages. The two scripts are in the /etc/cmcluster/scripts/ecmt/Oracle directory and
the third file is installed in the /etc/cmcluster/modules/ecmt/Oracle directory.
For legacy packages, there is one toolkit configuration script (haOracle.conf ) and nine functional
scripts that is described in the Table 2 (page 14)(toolkit.sh , haoracle.sh,
haoracle_sql.sh, haoracle.mon, halistener.mon, hadbhang.mon,
hagetdbstatus.sh, hatimeoutdbhang.sh, and SGAlert.sh) that coordinates with each
other to integrate Oracle database with the Serviceguard package control script.
Table 2 Legacy Package Scripts
DescriptionScript Name
This script contains a list of pre-defined variables that you must customize for
use with a particular database instance. This is a configuration file that is read
haoracle.conf (toolkit configuration file)
by the toolkit script, haoracle.sh. Table 3 (page 15) shows a list of variables
in haoracle.conf which must be set for the database package.
This script contains a list of internally used variables and functions that support
the starting and stopping of an Oracle database or ASM instance. This script
is called by toolkit.sh to perform the following:
Main Script (haoracle.sh )
• On package startup, it starts the database or ASM instance, a listener
process in case of a database instance and launches monitor processes.
• On package halt, it stops the database or ASM instance, the listener process
in case of a database instance, and monitor process.
• Oracle instance start/stop script (haoracle_sql.sh) This script contains
functions for starting and stopping Oracle instances and the listeners. This
script is invoked by the main script (haoracle.sh) to start up and shut
down Oracle.
This script contains a list of internally used variables and functions for
monitoring an Oracle server instance. This script is called by haoracle.sh.
Monitor Script (haoracle.mon)
By default, the following processes are monitored: ora_pmon_$SID_NAME,
ora_smon__$SID_NAME, ora_lgwr_$SID_NAME, ora_dbwr_$SID_NAME,
ora_ckpt_$SID_NAME, and ora_reco_$SID_NAME ($SID_NAME is the session
id name of the Oracle instance). These process names are contained in the
variable MONITOR_PROCESSES.
To include other processes to be monitored, you must add the names of the
processes to MONITOR_PROCESSES array in the toolkit configuration file
(haoracle.conf). For example, if Oracle archiver is enabled, archiver
process name can be added to theMONITOR_PROCESSES array
(ora_arc0_${SID_NAME}).
This script is called by haoracle.sh to monitor the configured listeners. The
script makes use of a command supplied by Oracle to check the status of the
listener.
Listener Monitor Script (halistener.mon)
The hadbhang.mon script is called by haoracle.sh to monitor the Oracle
instance for possible 'hung' state. hadbhang.mon script inturn uses
hagetdbstatus.sh and hatimeoutdb hang.sh to check the database status.
Database Hang Monitor Scripts
(hadbhang.mon, hagetdbstatus.sh,
hatimeoutdbhang.sh)
14 Using the Oracle Toolkit in an HP Serviceguard Cluster