#!/bin/sh

ORAHOME=/opt/oracle/product/8.1.7
ORAOWNER=oracle

if [ ! -f $ORAHOME/bin/dbstart ] ;
then
	echo "ERROR: Cannot start Oracle Database Server"
fi

case "$1" in
	"start")
		echo "Starting Oracle Database... \c"
		su - $ORAOWNER -c "$ORAHOME/bin/lsnrctl start" > /dev/null
		su - $ORAOWNER -c $ORAHOME/bin/dbstart > /dev/null
		echo "Done."
	;;
	
	"stop")
		echo "Stopping Oracle Database... \c"
		su - $ORAOWNER -c $ORAHOME/bin/dbshut > /dev/null
		su - $ORAOWNER -c "$ORAHOME/bin/lsnrctl stop" > /dev/null
		echo "Done."
	;;

	"*")
		echo "You must tell what you want me to do."
		echo "Usage : ./dbora [start | stop ]"
		echo "	start    - Start Oracle Database immediately"
		echo "	stop     - Stop Oracle Database immediately"
	;;

esac

exit