#oratab
FBD:/opt/oracle/product/10.2.0:Y

#!/sbin/runscript
# Akadia AG, Arvenweg 4, CH-3604 Thun
# ----------------------------------------------------------------------
# File:       dbora
#
# Autor:      Martin Zahn / 10.03.2004
#
# Purpose:    Startup Oracle Database(s) defined in
#             /etc/oratab
# ----------------------------------------------------------------------

# NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1; export NLS_LANG
ORACLE_OWNER=oracle; export ORACLE_OWNER
ORACLE_SCRIPTS_DIR=/home/oracle/config/adm; export ORACLE_SCRIPTS_DIR

depend() {
    need net
}

start() {
    ebegin "Starting Oracle"
    if [ ! -f $ORACLE_SCRIPTS_DIR/dbstart ]
    then
        echo "Oracle not started (no dbstart script)"
    else
        su - $ORACLE_OWNER -c $ORACLE_SCRIPTS_DIR/dbstart
    fi
    eend $? "Failed to start Oracle."
}

stop() {
    ebegin "Stopping Oracle"
    if [ ! -f $ORACLE_SCRIPTS_DIR/dbshut ]
    then
        echo "Oracle not started (no dbshut script)"
    else
        su - $ORACLE_OWNER -c $ORACLE_SCRIPTS_DIR/dbshut
    fi
    eend $? "Failed to stop Oracle."
}

env | grep ORACLE

:
#
# $Id: dbstart.sh.pp 30-oct-2003.17:04:23 mwidjaja Exp $ 
# Copyright (c) 1991, 2003, Oracle Corporation.  All rights reserved.  
#

###################################
# 
# 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.
#
#####################################
#set -x
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 start
# that ORACLE
#

cat $ORATAB | while read LINE
do
    case $LINE in
        \#*)                ;;        #comment-line in oratab
        *)
#       Proceed only if last field is 'Y'.
#       Entries whose last field is not Y or N are not DB entry, ignore them.
        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
            SPFILE1=${ORACLE_HOME}/dbs/spfile.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 <<EOF
connect internal
shutdown abort
EOF
                        ;;
                    *)  $SQLDBA $args <<EOF
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 $SPFILE -o -f $SPFILE1 -o -f $PFILE ] ; then
                    case $VERSION in
                        "6")  sqldba command=startup ;;
                        "internal")  $SQLDBA <<EOF
connect internal
startup
EOF
                            ;;
                        *)  $SQLDBA <<EOF
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

sqlplus /nolog
connect / as sysdba