Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Help with dbstart script

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US