Help with dbstart script

From: Massa Batheli <mngong_at_gmail.com>
Date: Tue, 12 Jun 2007 07:01:34 -0700
Message-ID: <1181656894.597693.66340@r19g2000prf.googlegroups.com>

The dbstart script does not work in oracle 10G. This is the error that comes up , .
./dbstart[73]: syntax error: `;;' unexpected

#
# $Header: dbstart.sh.pp 1.1 95/02/22 14:37:29 rdhoopar Osd<unix> $
dbstart.sh.pp Copyr (c) 1991 Oracle
#

set -x
###################################
#
# usage: dbstart
#
# This script is used to start ORACLE from /etc/rc(.local).
# It should ONLY be executed as part of the system boot procedure.
#
#####################################

ORATAB=/etc/oratab

trap 'exit' 1 2 3
case $ORACLE_TRACE in

    T) set -x ;;
esac

# Set path if path not set (if called from /etc/rc)
case $PATH in

    "")	PATH=/bin:/usr/bin:/etc
	export PATH ;;

esac

#
# Loop for every entry in oratab file and and try to start
# that ORACLE
#

cat $ORATAB | while read LINE
do

    case $LINE in

	\#*)		;;	#comment-line in oratab
	*)


#       Proceed only if third field is 'Y'.

        if [ "`echo $LINE | awk -F: '{print $3}' -`" = "Y" ] ; then
            ORACLE_SID=`echo $LINE | awk -F: '{print $1}' -`
	    if [ "$ORACLE_SID" = '*' ] ; then
		ORACLE_SID=""
	    fi


#           Called programs use same database ID

            export ORACLE_SID
            ORACLE_HOME=`echo $LINE | awk -F: '{print $2}' -`


#           Called scripts use same home directory

            export ORACLE_HOME


#           Put $ORACLE_HOME/bin into PATH and export.

            PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/etc ; export PATH
	    PFILE=${ORACLE_HOME}/dbs/init${ORACLE_SID}.ora

	    if test  -f $ORACLE_HOME/dbs/sgadef${ORACLE_SID}.dbf  -o \
		     -f $ORACLE_HOME/dbs/sgadef${ORACLE_SID}.ora
	    then
		STATUS="-1"
	    else
		STATUS=1
	    fi
	    case $STATUS in
                1)  if [ -f $PFILE ] ; then

sqlplus '/ as sysdba' << !done!
startup
!done!

                        if test $? -eq 0 ; then
			    echo ""
		            echo "Database \"${ORACLE_SID}\" warm started."
			else
			    echo ""
                            echo "Database \"${ORACLE_SID}\" NOT
started."
		        fi
                    ;;
		-1) echo ""
		    echo "Database \"${ORACLE_SID}\" possibly left running when
system went down (system crash?)."
                    echo "Notify Database Administrator."

sqlplus '/ as sysdba' << !done!
shutdown abort
!done!

sqlplus '/ as sysdba' << !done!
startup
!done!

                            if test $? -eq 0 ; then
				echo ""
				echo "Database \"${ORACLE_SID}\" warm started."
			    else
				echo ""
				echo "Database \"${ORACLE_SID}\" NOT started."
			    fi
		    ;;
            esac
        fi
	;;

    esac
done

Massa Received on Tue Jun 12 2007 - 09:01:34 CDT