Table 2 Legacy Package Scripts (continued)

Script Name

Description

Listener Monitor Script (halistener.mon) 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.

Database Hang Monitor Scripts

The hadbhang.mon script will be called by haOracle.sh to monitor the

(hadbhang.mon, hagetdbstatus.sh,

Oracle instance for possible 'hung' state. hadbhang.mon script inturn uses

hatimeoutdbhang.sh)

hagetdbstatus.sh and hatimeoutdb hang.sh to check the database status.

 

 

Alert Notification Scriptv(SGAlert.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.

 

 

Interface Script (toolkit.sh)

This script is the interface between the Serviceguard package control script

 

and the Oracle toolkit.

Table 3 Variable or Parameter Name in haoracle.conf file

Variable/Parameter Name

Description

 

 

INSTANCE_TYPE

This parameter determines whether the instance is an ASM instance or a database

 

instance. Set this parameter to "database".

 

 

ORACLE_HOME

The home directory of Oracle.

 

 

ORACLE_ADMIN

User name of the Oracle database administrator. This will be used for starting and

 

stopping of the database.

 

 

SID_NAME

The Oracle session name. This is sometimes called the session ID (SID). (for example,

 

ORACLE_TEST0) and uniquely identifies an Oracle database instance.

 

 

START_MODE

This parameter defines the Oracle database startup mode. Valid options are "no

 

mount", "mount" and "open". Default mode is "open".

 

 

LISTENER

Set to "yes" if you want this toolkit to start and stop the Oracle Listener.

 

 

LISTENER_NAME

The name(s) of the listener process(es) (typically the SID_NAME )

 

 

LISTENER_PASS

The password(s) of the listener process(es).

 

 

LISTENER_RESTART

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.

 

 

PFILE

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.

 

 

MONITOR_PROCESSES

The names of all processes that should be executing.

 

 

14 Using the Oracle Toolkit in an HP Serviceguard Cluster