[Linux-cluster] Oracle start up script issue with RHEL3 Cluster

lingu hicheerup at gmail.com
Sat Nov 15 19:27:01 UTC 2008


Hi all

I am running two node active/passive cluster on RHEL3U8-64 bit
operating system for my oracle 9i  database.I am facing issue when
cluster fail over to node 2 my oracle start up script not starting up
even though i configured start up script in my cluster configuration
but if i type clustat on node 2  it shows service is started. If i
shift the service manually from node 2 to node 1 or even if rebooted
the node1  my cluster starting up the same  service  properly on node
1.Any one help me to fix out this issue.Below  is my script.

Cluster Version: clumanager-1.2.31-1.x86_64

Note: If i start the same script manually on the node 2 it is starting
the database properly without any error.

/etc/init.d/script_db.sh
#####################################################################################
#!/bin/bash
. /etc/rc.d/init.d/functions

start()	{
	echo "Starting Database"

	su -l oracle -c "sh startdb.sh"
	## Sleep for 2 Minuts ####

#	sleep 120
#	echo " reStarting app"
#        clusvcadm -R application
#        echo " app restarted"

	RETVAL=$?
	return $RETVAL
}


stop()	{
	echo "Stopping  Database"
	
	su -l oracle -c "sh stopdb.sh"

	RETVAL=$?
	return $RETVAL
}

status() {
#DBUP=`ps -ef | grep oracle | grep -v grep | grep -c ora_pmon `
DBUP=`ps -ef | grep -c ora_pmon `
#LSNRUP=`ps -ef | grep oracle | grep 9.2.0  | grep -v grep | grep -c lsnrctl`
LSNRUP=`ps -ef | grep -c lsnrctl`
if [ ${DBUP} -ge 1 ]
then
        if [ ${LSNRUP} -ge 1 ]
        then
                echo "Database Running"
		return 0
        fi
fi
echo "Database  Not Running"
return 1
}


case "$1" in
	start)
	        start
		echo "Start Database complete"
	        ;;
	
	stop)
         	stop
		echo "Database Stopped"
		;;
	restart)
	         stop
	         start
	         ;;
	status)
		status
		;;
	
	*)
	
	echo $" Not Applicable"
	exit 1

esac
echo "exiting script"
exit $RETVAL
###################################################################################
stopdb.sh

/home/oracle/orahome/bin/sqlplus /nolog<<EOF
connect sys/sysxyzcall at xyzcall as sysdba
shutdown immediate;
host lsnrctl stop
quit;
EOF
exit
######################################################################################
startdb.sh
#######################################################################
/home/oracle/orahome/bin/sqlplus /nolog <<EOF
host lsnrctl stop
host lsnrctl start
connect sys/sysxyzcall at xyzcall as sysdba
startup
quit;
EOF
exit
############################################################################

Regards,
Lingu




More information about the Linux-cluster mailing list