Adjust the db script

Shell Programming and Scripting
1

Enclosing a script that is used everyday for database shutdown. In here you will find some code that checks oracle version.
That part is very unnecessary since we use only 8.1.7 and will never go back.. Can anyone help me by modifying the code, to
never use that part and readjust so script does not fail.. and add more comment lines after the last comment line..

:
#
# $Header: dbshut.sh.pp 30-may-2000.14:31:09 jboyce Exp $ dbshut.sh.pp Copyr (c) 1991 Oracle
#

###################################
#
# usage: dbshut
#
# This script is used to shutdown 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
# Save LD_LIBRARY_PATH
SAVE_LLP=$LD_LIBRARY_PATH

#
# Loop for every entry in oratab file and and try to shut down
# 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
# add for bug 652997
LD_LIBRARY_PATH=${SAVE_LLP}:${ORACLE_HOME}/lib ; export LD_LIBRARY_PATH
PFILE=${ORACLE_HOME}/dbs/init${ORACLE_SID}.ora

# See if it is a V6 or V7 database
if [ -f $ORACLE_HOME/bin/sqldba ] ; then
VERSION=`$ORACLE_HOME/bin/sqldba command=exit | awk '
/SQL\*DBA: (Release|Version)/ {split($3, V, ".") ;
print V[1]}'`
SQLDBA=sqldba
else
if [ -f $ORACLE_HOME/bin/svrmgrl ] ; then
SQLDBA=svrmgrl
else
SQLDBA="sqlplus /nolog"
fi
fi
case $VERSION in
6) sqldba command=shutdown ;;
*) $SQLDBA <<EOF
connect internal
shutdown immediate
EOF
;;
esac

        if test $? -eq 0 ; then
            echo "Database \\"$\{ORACLE_SID\}\\" shut down."
        else
            echo "Database \\"$\{ORACLE_SID\}\\" not shut down."
        fi
    fi
    ;;
esac

done

2

To get rid of the check, comment out the lines as follows and move the $SQLDBA << EOF down one.

# case $VERSION in
# 6) sqldba command=shutdown ;;
#*)
$SQLDBA <<EOF
connect internal
shutdown immediate
EOF
# ;;
# esac

You could also comment out the line that sets the VERSION variable (not by itself...you would still need to do the comments above).

Leaving it in will not hurt anything. You could have a Version 6 database come up that you want a shutdown script for OR you could change this over (if needed) when you upgrade to version 8 or 9.

If it not broke, don't fix it.