User's Manual

NOTE: If the Oracle database is running in a cluster where SGeRAC packages are also
running, then the ECMT Oracle single-instance database package must be made dependent
on the SGeRAC Oracle clusterware multi-node package (OC MNP). The dependency type
should be 'SAME_NODE=up'. This is because, when the Oracle clusterware is halted, it halts
the Oracle single-instance database. By putting this dependency, we ensure that the database
package is always halted first and then the SGeRAC OC MNP is halted. Also, the Oracle
database must be disabled from being started automatically by the Oracle Clusterware. This
can be done by following the below steps:
1. 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 -d <dbname> —y manual
For Oracle 11g:
# $ORACLE_HOME/bin/srvctl modify database -d <dbname> —y MANUAL
• The Oracle toolkit user configuration file.
In the package directory, modify the haoracle.conf configuration file for this Oracle
instance.
NOTE: In case of a modular package, the user need not specify the parameter values in
thehaoracle.conf file. The toolkit populates haoracle.conf on its own.
For example:
Edit the haoracle.conf script as indicated by the comments in that script. You will have to
set the variables as shown in the example below:
INSTANCE_TYPE=database
ORACLE_HOME=/ORACLE_TEST0
ORACLE_ADMIN=Oracle
SID_NAME=ORACLE_TEST0
START_MODE=open
ASM=no
LISTENER=yes
LISTENER_NAME=LISTENER_ORACLE_TEST0
LISTENER_PASS=
LISTENER_RESTART=
PFILE=${ORACLE_HOME}/dbs/init${SID_NAME}.ora
MONITOR_PROCESSES[0]=ora_pmon_${SID_NAME}
MONITOR_PROCESSES[1]=ora_dbw0_${SID_NAME}
MONITOR_PROCESSES[2]=ora_ckpt_${SID_NAME}
MONITOR_PROCESSES[3]=ora_smon_${SID_NAME}
MONITOR_PROCESSES[4]=ora_lgwr_${SID_NAME}
MONITOR_PROCESSES[5]=ora_reco_${SID_NAME}
MAINTENANCE_FLAG=yes
MONITOR_INTERVAL=30
TIME_OUT=30
PARENT_ENVIRONMENT=no
CLEANUP_BEFORE_STARTUP=no
USER_SHUTDOWN_MODE=abort
ALERT_MAIL_ID=
The parameters ASM_DISKGROUP, ASM_VOLUME_GROUP, ASM_HOME, ASM_USER,
ASM_SID, and KILL_ASM_FOREGROUNDS need to be set only for a database package
using ASM. For more information on ASM, see “Supporting Oracle ASM instance and Oracle
database with ASM” (page 26).
24 Using the Oracle Toolkit in an HP Serviceguard Cluster