HP Serviceguard Toolkit for Oracle Data Guard manual ORACLEHOME=/ORACLETEST0

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