- 论坛徽章:
- 0
|
orcl2.sh
#!/usr/bin/sh
###############################################################################
#
ORA_ver=9_2_0
DB_NAME=orcl
SID_NAME=orcl2
ORACLE_HOME=/oracle/app/oracle/product/9.2.0
LISTENER=yes
LISTENER_NAME=
LISTENER_PASS=
MONITOR_INTERVAL=30
PACKAGE_NAME=oracle_orcl2
TIME_OUT=30
set -A MONITOR_PROCESSES ora_pmon_${SID_NAME} ora_dbw0_${SID_NAME} ora_ckpt_${SID_NAME} ora_smon_${SID_NAME} ora_lgwr_${SID_NAME} ora_reco_${SID_NAME}
HOST=`hostname`
DATE=`date`
PATH=${ORACLE_HOME}/bin:/sbin:/usr/bin:/usr/sbin:/etc:/bin
export ORACLE_SID=${SID_NAME}
export ORACLE_HOME
###############################################################################
###############################################################################
# Function: oracle_run_cmds
#
# Start the ORACLE instance defined in the environment variables ORACLE_HOME
# and SID_NAME.
###############################################################################
function oracle_run_cmds
{
# Startup Oracle.
case $ORA_ver in
9_2_0)
#su oracle -c "${ORACLE_HOME}/bin/srvctl start inst -d ${DB_NAME} -i ${SID_NAME}'"
su oracle -c "${ORACLE_HOME}/bin/sqlplus '/as sysdba'"<<EOF
startup
exit
EOF
if [[ $? != 0 ]] then
print "Oracle startup failed."
else
print "Oracle startup done."
fi
;;
*)
print "Oracle startup failed, check configuration variables."
;;
esac
# Start the listener process.
case $LISTENER in
yes)
su oracle -c "${ORACLE_HOME}/bin/lsnrctl start ${LISTENER_NAME}"
if [[ $? != 0 ]] then
print "Oracle lsnrctl start failed."
else
print "Oracle lsnrctl start done."
fi
;;
*)
print "Not starting the listener, configured not to start."
;;
esac
}
###############################################################################
# Function: oracle_shutdown_cmds
#
# Shutdown Oracle using the shutdown immediate command.
# This will do a clean shutdown of the database.
# Do NOT use 'cmhaltpkg' to shutdown the database as 'cmhaltpkg'
# does a database abort and all transactions in memory will be lost.
###############################################################################
function oracle_shutdown_cmds
{
# Shutdown Oracle.
case $ORA_ver in
9_2_0)
#su oracle -c "${ORACLE_HOME}/bin/srvctl stop inst -d ${DB_NAME} -i ${SID_NAME}'"
su oracle -c "${ORACLE_HOME}/bin/sqlplus '/as sysdba'"<<EOF
shutdown immediate
exit
EOF
if [[ $? != 0 ]] then
print "Oracle shutdown failed."
else
print "Oracle shutdown done."
fi
;;
*)
print "Oracle shutdown failed, check configuration variables."
;;
esac
# Stop the listener process.
case $LISTENER in
yes)
su oracle -c "${ORACLE_HOME}/bin/lsnrctl stop ${LISTENER_NAME}"
if [[ $? != 0 ]] then
print "Oracle lsnrctl stop failed."
else
print "Oracle lsnrctl stop done."
fi
;;
*)
print "Not stoping the listener, configured not to stop."
;;
esac
}
###############################################################################
# Function: oracle_abort_cmds
#
# Recursively call this script with the "kill" option to terminate any process
# that will not die normally after waiting for the TIME_OUT period.
###############################################################################
function oracle_abort_cmds
{
# Something is wrong so we will abort.
#
# Call this script with the kill option to terminate any process that will
# not die normally after waiting for the TIME_OUT period.
set -m
${0} kill &
# Stop Oracle process.
case $ORA_ver in
9_2_0)
su oracle -c "${ORACLE_HOME}/bin/sqlplus '/as sysdba'"<<EOF
shutdown abort
exit
EOF
if [[ $? != 0 ]] then
print "Oracle abort failed."
else
print "Oracle abort done."
fi
;;
esac
# Stop the listener process.
case $LISTENER in
yes)
su oracle -c "${ORACLE_HOME}/bin/lsnrctl stop ${LISTENER_NAME}"
if [[ $? != 0 ]] then
print "Oracle lsnrctl stop failed."
else
print "Oracle lsnrctl stop done."
fi
;;
*)
print "Not stoping the listener, configured not to stop."
;;
esac
# Make sure all processes have gone away before determining that shutdown is
# complete. This stops the other node from starting up the package before it
# has been stopped and the file system has been unmounted.
typeset -i c
typeset -i num_procs=${#MONITOR_PROCESSES[@]}
while true
do
for i in ${MONITOR_PROCESSES[@]}
do
id=`ps -fu oracle | awk '/'${i}$'/ { print $2 }'` #JAGad06432
if [[ ${id} = "" ]] #JAGad06432
then
print "\n *** ${i} process has stopped. ***\n"
c=0
while (( c < $num_procs ))
do
if [[ ${MONITOR_PROCESSES[$c]} = $i ]] then
unset MONITOR_PROCESSES[$c]
c=$num_procs
fi
(( c = c + 1 ))
done
fi
done
if [[ ${MONITOR_PROCESSES[@]} = "" ]] then
# The shutdown was successful; therefore, get rid of the script (which
# was started earlier) to kill any existing hung processes. Check to
# see if the script is still running. If the result from the 'job'
# command indicates that the script is done, then there is no need
# to kill it.
job=$(jobs | grep -v Done)
if [[ ${job} != "" ]] then
print "Killing the kill_hung_processes script\n"
kill %1
fi
exit 0
# fix for 1653287920
fi
sleep 5
done
}
###############################################################################
# Function: kill_hung_processes
#
# If the database is hung, spawn a background process that will issue a
# a SIGKILL to each of the monitored processes. This allows us to guarantee
# a time limit for clean halt attempts.
###############################################################################
function kill_hung_processes
{
# Wait for the TIME_OUT period before sending a kill signal. The TIME_OUT
# value should be less than the MC/Serviceguard package time-out.
sleep ${TIME_OUT}
for i in "${MONITOR_PROCESSES[@]}"
do
id=`ps -fu oracle | awk '/'${i}$'/ { print $2 }'` #JAGad06432
if [[ ${id} != "" ]] then
kill -9 ${id}
if [[ $? != 0 ]] then
print "\n *** ${0} kill_hung_processes function did NOT find process ***\n *** ${i} running. ***\n"
else
print "\n *** ${0} kill_hung_processes function did find process ***\n *** ${i} running. Sent SIGKILL. ***\n"
fi
else
print " *** kill_hung_processes function did NOT find ANY process running. ***\n"
fi
done
}
###############################################################################
# Function: monitor_processes
#
# Monitor the Oracle processes by making sure that all required processes are
# running.
##############################################################################
function monitor_processes
{
typeset -i n=0
for i in "${MONITOR_PROCESSES[@]}"
do
MONITOR_PROCESSES_PID[$n]=`ps -fu oracle | awk '/'${i}$'/ { print $2 }'` #JAGad06432
print "Monitored process = ${i}, pid = ${MONITOR_PROCESSES_PID[$n]}"
if [[ ${MONITOR_PROCESSES_PID[$n]} = "" ]] then
print "\n\n"
ps -ef
print "\n *** ${i} has failed at startup time. Aborting Oracle. ***"
set -m
nohup ${0} fault & # The script calls itself with the fault option.
set +m
sleep 999999
fi
(( n = n + 1 ))
done
sleep ${MONITOR_INTERVAL}
while true
do
for i in ${MONITOR_PROCESSES_PID[@]}
do
kill -s 0 ${i} > /dev/null
if [[ $? != 0 ]] then
print "\n\n"
ps -ef
print "\n *** ${i} has failed. Aborting Oracle. ***"
set -m
nohup ${0} fault & # The script calls itself with the fault option.
set +m
sleep 999999
fi
done
sleep ${MONITOR_INTERVAL}
done
}
###############################################################################
# Function: halt_package
#
# Because there is no move command in MC/Serviceguard, the package must first
# be halted, disabled from running on the host, and then enabled to run in the
# cluster.
###############################################################################
function halt_package
{
cmhaltpkg ${PACKAGE_NAME}
cmmodpkg -d -n ${HOST} ${PACKAGE_NAME}
sleep 1
cmmodpkg -e ${PACKAGE_NAME}
}
###############################################################################
# MAIN
#
# Check the command-line option and take the appropriate action.
###############################################################################
print "\n *** $0 called with $1 argument. ***\n"
case $1 in
fault)
halt_package
;;
kill)
kill_hung_processes
;;
monitor)
monitor_processes
;;
start)
print "\n \"${HOST}\": Starting Oracle $SID_NAME at ${DATE} "
oracle_run_cmds
;;
halt)
print "\n \"${HOST}\": Aborting Oracle $SID_NAME at ${DATE} "
oracle_abort_cmds
;;
shutdown)
print "\n \"${HOST}\": Shutting down Oracle $SID_NAME at ${DATE} "
oracle_shutdown_cmds
;;
*)
print "Usage: ${0} [ shutdown | halt | start | monitor ]"
;;
esac
pkg_oracle.cntl(一号机)
. ${SGCONFFILE:=/etc/cmcluster.conf}
PATH=$SGSBIN:/usr/bin:/usr/sbin:/etc:/bin
VGCHANGE="vgchange -a s" # Default
CVM_ACTIVATION_CMD="vxdg -g \$DiskGroup set activation=exclusivewrite"
VG[0]="vg_ora"
DEACTIVATION_RETRY_COUNT=0
KILL_PROCESSES_ACCESSING_RAW_DEVICES="NO"
VXVOL="vxvol -g \$DiskGroup startall" # Default
FS_MOUNT_RETRY_COUNT=0
CONCURRENT_VGCHANGE_OPERATIONS=1
CONCURRENT_FSCK_OPERATIONS=1
CONCURRENT_MOUNT_AND_UMOUNT_OPERATIONS=1
SERVICE_NAME[0]="orcl1.sh"
SERVICE_CMD[0]="/etc/cmcluster/pkg_oracle/orcl1.sh monitor"
SERVICE_RESTART[0]="-R"
function customer_defined_run_cmds
{
# ADD customer defined run commands.
: # do nothing instruction, because a function must contain some command.
/etc/cmcluster/pkg_oracle/orcl1.sh start
test_return 51
}
function customer_defined_halt_cmds
{
# ADD customer defined halt commands.
: # do nothing instruction, because a function must contain some command.
//etc/cmcluster/pkg_oracle/orcl1.sh halt
test_return 52
}
pkg_oracle.cntl(二号机)
. ${SGCONFFILE:=/etc/cmcluster.conf}
PATH=$SGSBIN:/usr/bin:/usr/sbin:/etc:/bin
VGCHANGE="vgchange -a s" # Default
CVM_ACTIVATION_CMD="vxdg -g \$DiskGroup set activation=exclusivewrite"
VG[0]="vg_ora"
DEACTIVATION_RETRY_COUNT=0
KILL_PROCESSES_ACCESSING_RAW_DEVICES="NO"
VXVOL="vxvol -g \$DiskGroup startall" # Default
FS_MOUNT_RETRY_COUNT=0
CONCURRENT_VGCHANGE_OPERATIONS=1
CONCURRENT_FSCK_OPERATIONS=1
CONCURRENT_MOUNT_AND_UMOUNT_OPERATIONS=1
SERVICE_NAME[0]="orcl2.sh"
SERVICE_CMD[0]="/etc/cmcluster/pkg_oracle/orcl2.sh monitor"
SERVICE_RESTART[0]="-R"
function customer_defined_run_cmds
{
# ADD customer defined run commands.
: # do nothing instruction, because a function must contain some command.
/etc/cmcluster/pkg_oracle/orcl2.sh start
test_return 51
}
function customer_defined_halt_cmds
{
# ADD customer defined halt commands.
: # do nothing instruction, because a function must contain some command.
//etc/cmcluster/pkg_oracle/orcl2.sh halt
test_return 52
}
pkg_oracle.conf (一号机)
PACKAGE_NAME oracle_inst1
PACKAGE_TYPE FAILOVER
FAILOVER_POLICY CONFIGURED_NODE
FAILBACK_POLICY MANUAL
AUTO_RUN YES
NODE_NAMErp3440_1
LOCAL_LAN_FAILOVER_ALLOWED YES
NODE_FAIL_FAST_ENABLED NO
RUN_SCRIPT /etc/cmcluster/pkg_oracle/pkg_oracle.cntl
RUN_SCRIPT_TIMEOUT NO_TIMEOUT
HALT_SCRIPT /etc/cmcluster/pkg_oracle/pkg_oracle.cntl
HALT_SCRIPT_TIMEOUT NO_TIMEOUT
SERVICE_NAME orcl1.sh
SERVICE_FAIL_FAST_ENABLED NO
SERVICE_HALT_TIMEOUT 300
pkg_oracle.conf (二号机)
PACKAGE_NAME oracle_inst2
PACKAGE_TYPE FAILOVER
FAILOVER_POLICY CONFIGURED_NODE
FAILBACK_POLICY MANUAL
AUTO_RUN YES
NODE_NAMErp3440_2
LOCAL_LAN_FAILOVER_ALLOWED YES
NODE_FAIL_FAST_ENABLED NO
RUN_SCRIPT /etc/cmcluster/pkg_oracle/pkg_oracle.cntl
RUN_SCRIPT_TIMEOUT NO_TIMEOUT
HALT_SCRIPT /etc/cmcluster/pkg_oracle/pkg_oracle.cntl
HALT_SCRIPT_TIMEOUT NO_TIMEOUT
SERVICE_NAME orcl2.sh
SERVICE_FAIL_FAST_ENABLED NO
SERVICE_HALT_TIMEOUT 300 |
|
免费注册
发表于 2006-04-11 15:23
