ASM_HOME=/ASM_TEST0
ASM_USER=oracle
ASM_SID=+ASM
LISTENER=yes
LISTENER_NAME=LSNR_TEST0
LISTENER_PASS=LSNR_TEST0_PASS
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}
MONITOR_PROCESSES[6]=ora_rbal_${SID_NAME}
MONITOR_PROCESSES[7]=ora_asmb_${SID_NAME}
MAINTENANCE_FLAG=yes
MONITOR_INTERVAL=30
TIME_OUT=30
KILL_ASM_FOREGROUNDS=yes
PARENT_ENVIRONMENT=yes
CLEANUP_BEFORE_STARTUP=no
USER_SHUTDOWN_MODE=abort
ORA_CRS_HOME=/opt/oracle/crs
OC_TKIT_DIR=/etc/cmcluster/oc
4.Generate the database package configuration file and the control script in the database package directory and edit the parameters of these files as mentioned for the database package.
#cmmakepkg
#cmmakepkg
Edit the package configuration file db1pkg.conf as shown below:
PACKAGE_NAME - Set to any name desired.
PACKAGE_TYPE - Set to FAILOVER.
RUN_SCRIPT /etc/cmcluster/db1_package/db1pkg.cntl
HALT_SCRIPT /etc/cmcluster/db1_package/db1pkg.cntl
DEPENDENCY_NAMEoc_dependency
DEPENDENDY_CONDITION <SGeRAC OC MNP Package>=UP
DEPENDENCY_LOCATIONSAME_NODE
Configure the service parameters:
SERVICE_NAMEORACLE_DB1_SRV
SERVICE_FAIL_FAST_ENABLED NO
SERVICE_HALT_TIMEOUT 300
If listener is configured and needs to be monitored, configure another set of service parameters:
SERVICE_NAME | ORACLE_LSNR_SRV |
SERVICE_FAIL_FAST_ENABLED | NO |
SERVICE_HALT_TIMEOUT | 300 |
Edit the package control script db1pkg.cntl as shown below:
Since LVM logical volumes are used in disk groups, set VGCHANGE to "vgchange
Configure the package service:
SERVICE_NAME[0]="ORACLE_DB1_SRV"
SERVICE_CMD[0]="/etc/cmcluster/db1_package/toolkit.sh monitor"
If listener service is configured in the package configuration file, set the following parameters:
