#!/bin/sh

# Use to start and stop the Oracle database
# Must be run by oracle user or member of DBA group

ORACLE_SID=H920
ORACLE_HOME=/u01/$ORACLE_SID/oracle
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_SID ORACLE_HOME PATH

start() {
        su - oracle <<EOU
        $ORACLE_HOME/bin/lsnrctl start
        $ORACLE_HOME/bin/sqlplus /nolog <<END
        connect / as sysdba
        startup
END
EOU
}

stop() {
        su - oracle <<EOU
        $ORACLE_HOME/bin/lsnrctl stop
        $ORACLE_HOME/bin/sqlplus /nolog <<END
        connect / as sysdba
        shutdown immediate
END
EOU
}

if [ -z $ORACLE_HOME ]; then
        echo "You must define ORACLE_HOME" 1>&2
        exit 2
fi

    if [ ! -d $ORACLE_HOME ]; then
    echo "Unable to find ORACLE_HOME" 1>&2
    exit 2
    fi

    case "$1" in
    'start')
    start
    ;;
    'stop')
    stop
    ;;
    *)
    echo "Usage: $0 { start | stop }"
    exit 2
    ;;
    esac

    exit 0