HP Serviceguard Toolkit for Oracle Data Guard manual ASM Package Configuration Example, Manager

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 Example

1.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=ASM

ASM_HOME=/ASM_TEST0

ASM_USER=Oracle

ASM_SID=+ASM

PFILE=${ASM_HOME}/dbs/init${ASM_SID}.ora

LISTENER=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