Re: Help with dbstart script

On Jun 12, 9:01 am, Massa Batheli <mng..._at_gmail.com> wrote:
> 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

No, this version won't, since it was last modified in 1995, long before 10g was even a glimmer in the developer's eyes.

Use the correct dbstart script, located in the 10g $ORACLE_HOME/bin directory. The script I have for 10g looks much different from what you posted.

David Fitzjarrell Received on Tue Jun 12 2007 - 09:18:57 CDT