Remove unnecessary parts of dbshut script
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Remove unnecessary parts of dbshut script

  1. #1
    Join Date
    Oct 2000
    Posts
    449
    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.. The goal is to make this script as simple as possible since occassionally our backup is failing to start or hanging and need to run this script manually..
    Thanks, ST2000
    ~

    :
    #
    # $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 < 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. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You've already changed shutdown to shutdown immediate. Since this is an oracle provided (although unsupported) script, why would you want to mung it up? If you want a stripped down version, write you own...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width