Instance are reboot on System startup !
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Instance are reboot on System startup !

  1. #1
    Join Date
    Nov 2003
    Posts
    4

    Unhappy Instance are reboot on System startup !

    Hallo specialists,

    i have problems with a 9i Database on FSC Primepower Solaris 8. On Systemstartup, the Database makes an reboot (starting an shutdown). the dbstart-Script looks good (like this):

    ---------------------------------------------------------------------

    #
    # $Header: dbstart.sh.pp 03-apr-2001.13:38:21 jboyce Exp $ dbstart.sh.pp Copyr (c) 1991 Oracle
    #

    ###################################
    #
    # 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=/var/opt/oracle/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 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
    # add for bug # 652997
    LD_LIBRARY_PATH=${SAVE_LLP}:${ORACLE_HOME}/lib ; export LD_LIBRARY_PATH
    PFILE=${ORACLE_HOME}/dbs/init${ORACLE_SID}.ora
    SPFILE=${ORACLE_HOME}/dbs/spfile${ORACLE_SID}.ora

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

    STATUS=1
    if [ -f $ORACLE_HOME/dbs/sgadef${ORACLE_SID}.dbf ] ; then
    STATUS="-1"
    fi
    if [ -f $ORACLE_HOME/dbs/sgadef${ORACLE_SID}.ora ] ; then
    STATUS="-1"
    fi
    pmon=`ps -ef | egrep pmon_$ORACLE_SID | grep -v grep`
    if [ "$pmon" != "" ];
    then
    STATUS="-1"
    echo "Database \"${ORACLE_SID}\" already started."
    fi

    if test $STATUS -eq -1 ; then
    echo ""
    echo "Database \"${ORACLE_SID}\" possibly left running when system went down (system crash?)."
    echo "Notify Database Administrator."
    case $VERSION in
    "6") sqldba "command=shutdown abort" ;;
    "internal") $SQLDBA $args < connect internal
    shutdown abort
    EOF
    ;;
    *) $SQLDBA $args < connect /as sysdba
    shutdown abort
    EOF
    ;;
    esac
    if test $? -eq 0 ; then
    STATUS=1
    else
    echo "Database \"${ORACLE_SID}\" NOT started."
    fi
    fi

    if test $STATUS -eq 1 ; then
    if [ -f $PFILE -o -f $SPFILE ] ; then
    case $VERSION in
    "6") sqldba command=startup ;;
    "internal") $SQLDBA < connect / as sysdba
    startup
    EOF
    ;;
    *) $SQLDBA < connect / as sysdba
    startup
    EOF
    ;;
    esac

    if test $? -eq 0 ; then
    echo ""
    echo "Database \"${ORACLE_SID}\" warm started."
    else
    echo ""
    echo "Database \"${ORACLE_SID}\" NOT started."
    fi
    else
    echo ""
    echo "Can't find init file for Database \"${ORACLE_SID}\"."
    echo "Database \"${ORACLE_SID}\" NOT started."
    fi
    fi
    fi
    ;;
    esac
    done

    ---------------------------------------------------------------------

    Has anyone an idea?

    Thx
    Henk

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    whats the actual problem, thats just look the dbstart script from $ORACLE_HOME/bin.

    Also whats in your /etc/init.d directorys and /etc/rc2.d and /etc/rc3.d

  3. #3
    Join Date
    Nov 2003
    Posts
    4
    in /etc/init.d are the dbora-file:

    ---------------------------------------------------------------------

    #!/usr/bin/sh
    #
    # chkconfig: 345 50 49
    # description: starts the oracle dabase deamons
    #
    echo "Oracle 9i auto start/stop"

    case "$1" in
    'start')

    echo "Starting Oracle9i: "
    su - oracle -c /oracle/OraHome1/bin/dbstart

    echo "Starting the Listener for 9i: "
    su - oracle -c "/oracle/OraHome1/bin/lsnrctl start"

    touch /var/lock/subsys/oracle9i
    echo
    ;;

    'stop')
    echo "Shutting Oracle9i: "
    su - oracle -c /oracle/OraHome1/bin/dbshut

    echo "Shutting down Listener for 9i: "
    su - oracle -c "/oracle/OraHome1/bin/lsnrctl stop"

    rm -f /var/lock/subsys/oracle9i
    echo
    ;;

    'restart')

    echo -n "Restarting Oracle9i: "
    $0 stop
    $0 start
    echo
    ;;

    *)
    echo "Usage: oracle9i {start | stop | restart }"
    exit 1

    esac
    exit 0

    --------------------------------------------------------------------

    and in /etc/rc2.d are a link S95oracle -> /etc/init.d/dbora
    and in /etc/rc0.d are a link K10oracle -> /etc/init.d/dbora

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    and you say the database gets started up and then shutdown? so you have to start it manually each time you restart?

  5. #5
    Join Date
    Nov 2003
    Posts
    4
    Yes, thatīs right!

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    what happens if you run the scripts diretly from the command line

    so do cd /etc/rc2.d
    ./S95oracle start

  7. #7
    Join Date
    Nov 2003
    Posts
    4
    thatīs work fine !!! :-(( also dbstart works

    but it dosnīt work at system startup!
    Last edited by Henk; 11-18-2003 at 03:02 AM.

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