Using the Oracle Toolkit in a HP Serviceguard Cluster README Revision: B.06.00, August 2010
shutdown using the abort option. If
"immediate" is specified, the database is
shutdown using the immediate option.
ALERT_MAIL_ID: This parameter is used to specify the
e-mail address for sending alerts.
- Main Script (haoracle.sh)
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 will be called by toolkit.sh
to perform the following:
- 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.
- Monitor Script (haoracle.mon)
This script contains a list of internally used variables and
functions for monitoring an Oracle server instance. This script
will be called by haoracle.sh. 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, the user needs to add
the names of the processes to MONITOR_PROCESSES array in the toolkit
user configuration file (haoracle.conf). For example, if oracle
archiver is enabled, then archiver process name can be added to the
MONITOR_PROCESSES array (ora_arc0_${SID_NAME}).
- 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 (hadbhang.mon, hagetdbstatus.sh,
hatimeoutdbhang.sh)
hadbhang.mon script will be called by haoracle.sh to monitor the
oracle
instance for possible 'hung' state. hadbhang.mon script inturn uses