Table 6 Variables or Parameters in haoracle.conf file (continued)

Parameter Name

Description

KILL_ASM_FOREGROUNDS

When ASM is being used, this parameter is used to specify if the ASM

 

foreground processes of the form Oracle <ASM_SID> having file descriptors

 

open on the dismounted disk group volumes should be killed during database

 

package halt. The Oracle scripts will wait for a timeout of 12 seconds before

 

terminating the foreground processes that continue to have file descriptors open

 

on the dismounted disk group volumes. This parameter can be set to either

 

"yes" or "no". The default value is 'yes'. This parameter must be set only in the

 

case of an ASM database instance package.

 

 

OC_TKIT_DIR

This parameter should be populated only in case the Oracle database package

 

is dependent on the SGeRAC OC MNP package. This parameter should point

 

to the working directory of the SGeRAC OC MNP. In case of modular packages,

 

the value for this parameter is automatically populated when the package is

 

created using the cmapplyconf command. In case of legacy packages, this

 

attribute must be populated manually in the haoracle.conf file. This parameter

 

can be set only using the CLI and cannot be set using the Serviceguard

 

Manager.

ASM Package Configuration Example

Oracle Legacy Package Configuration Example1.ASM Multi-Node Package Setup and Configuration

NOTE: This package must not be created if SGeRAC packages are created in the same cluster.

Create your own ASM package directory under /etc/cmcluster and copy over the scripts in the bundle.

Log in as root:#mkdir /etc/cmcluster/asm_package_mnp#cd /etc/cmcluster/asm_package_mnp

Then copy the framework scripts provided to this location : cp /opt/cmcluster/toolkit/Oracle/*

.

Edit the configuration file haoracle.conf for the ASM MNP to fit your specific Oracle environment as indicated by the comments in that script. You will have to set the variables as shown in the example below:

INSTANCE_TYPE=ASMASM_HOME=/ASM_TEST0ASM_USER=OracleASM_SID=+ASMPFILE=${ASM_HOME}/dbs/init${ASM_SID}.oraLISTENER=no (Change from default value "yes" to "no")MONITOR_PROCESSES[0]=asm_pmon_${ASM_SID}MONITOR_PROCESSES[1]=asm_dbw0_${ASM_SID}MONITOR_PROCESSES[2]=asm_ckpt_${ASM_SID}MONITOR_PROCESSES[3]=asm_smon_${ASM_SID}MONITOR_PROCESSES[4]=asm_lgwr_${ASM_SID}MONITOR_PROCESSES[5]=asm_rbal_${ASM_SID}MONITOR_PROCESSES[6]=asm_gmon_${ASM_SID}

MAINTENANCE_FLAG=yes

MONITOR_INTERVAL=30

TIME_OUT=30

PARENT_ENVIRONMENT=yes

CLEANUP_BEFORE_STARTUP=no

USER_SHUTDOWN_MODE=abort

40 Using the Oracle Toolkit in an HP Serviceguard Cluster