User's Manual

Table 2 Legacy Package Scripts (continued)
DescriptionScript Name
This script will be 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 will be 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)
This script is used to send an e-mail to the e-mail address specified by the
value of the ALERT_MAIL_ID package attribute, whenever there are critical
problems with the package.
Alert Notification Scriptv(SGAlert.sh)
This script is the interface between the Serviceguard package control script
and the Oracle toolkit.
Interface Script (toolkit.sh)
Table 3 Variable or Parameter Name in haoracle.conf file
DescriptionVariable/Parameter Name
This parameter determines whether the instance is an ASM instance or a database
instance. Set this parameter to "database".
INSTANCE_TYPE
The home directory of Oracle.ORACLE_HOME
User name of the Oracle database administrator. This will be used for starting and
stopping of the database.
ORACLE_ADMIN
The Oracle session name. This is sometimes called the session ID (SID). (for example,
ORACLE_TEST0) and uniquely identifies an Oracle database instance.
SID_NAME
This parameter defines the Oracle database startup mode. Valid options are "no
mount", "mount" and "open". Default mode is "open".
START_MODE
Set to "yes" if you want this toolkit to start and stop the Oracle Listener.LISTENER
The name(s) of the listener process(es) (typically the SID_NAME )LISTENER_NAME
The password(s) of the listener process(es).LISTENER_PASS
This parameter defines the number of attempts to be made to restart the listener. If the
listener does not restart after "LISTENER_RESTART" number of consecutive attempts,
the package will be failed over. If the listener restart is successful, then the next time
listener fails, the toolkit again tries "LISTENER_RESTART" number of times to restart the
listener.
LISTENER_RESTART
Oracle database parameter file. If not specified, Oracle picks this up from the Oracle
configuration directory $ORACLE_HOME/dbs. This parameter when configured
overrides the default file/location. If both pfile and spfile are present and this parameter
left unspecified, then ECM Oracle Toolkit will make use of pfile as the parameter file.
To make use of spfile in the toolkit do not configure this parameter and remove the
default pfile from its default location.
PFILE
The names of all processes that should be executing.MONITOR_PROCESSES
14 Using the Oracle Toolkit in an HP Serviceguard Cluster