customizing process monitoring of Oracle under ServiceGuard
You can add /remove the oracle processes being monitored by Service Guard cluster by modifying the 'haoracle.conf' file in the package directory. There will be separate file for each of the package you configure under SG.
==> snip from haoracle.conf
###############################################################################
# MONITOR_PROCESSES:
# This is the list of all the critical oracle processes for an
# instance that must be executing to assume that the instance is up
# and running. User can add more oracle instance processes. Suppose
# if this particular oracle instance needs to be run with archiving
# enabled then this toolkit needs to mointor oracle archiver process
# ora_arch_${SID_NAME} process too. This can be done by adding this
# to the array variable MONITOR_PROCESSES. MONITOR_PROCESSES array
# is indexed from 0 and the next index is obtained by incrementing
# current by 1. By default the follwing 6 process are monitored.
#
# 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}
#
# To add oracle archiver process to the array add the following
# line.
#
# MONITOR_PROCESSES[6]=ora_arc0_${SID_NAME}
###############################################################################
declare -a MONITOR_PROCESSES
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_mmon_${SID_NAME}
#MONITOR_PROCESSES[7]=ora_arc0_${SID_NAME}
==> snip from haoracle.conf
###############################################################################
# MONITOR_PROCESSES:
# This is the list of all the critical oracle processes for an
# instance that must be executing to assume that the instance is up
# and running. User can add more oracle instance processes. Suppose
# if this particular oracle instance needs to be run with archiving
# enabled then this toolkit needs to mointor oracle archiver process
# ora_arch_${SID_NAME} process too. This can be done by adding this
# to the array variable MONITOR_PROCESSES. MONITOR_PROCESSES array
# is indexed from 0 and the next index is obtained by incrementing
# current by 1. By default the follwing 6 process are monitored.
#
# 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}
#
# To add oracle archiver process to the array add the following
# line.
#
# MONITOR_PROCESSES[6]=ora_arc0_${SID_NAME}
###############################################################################
declare -a MONITOR_PROCESSES
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_mmon_${SID_NAME}
#MONITOR_PROCESSES[7]=ora_arc0_${SID_NAME}
Comments