#!/bin/bash
# Script name : /etc/init.d/oraclexe
#
# Start & stop Oracle 10g Express Edition Database and Listener
RETVAL=0
export ORACLE_HOME=/opt/db/oraclexe/app/oracle/product/10.2.0/server
export ORA_HOME=$ORACLE_HOME
export ORACLE_OWNER=oraclexe
export ORA_OWNR=oraclexe
export ORACLE_SID=XE
export PATH=$ORACLE_HOME/bin:$PATH
export LC_ALL=C
export SQLPLUS=$ORACLE_HOME/bin/sqlplus
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib


start() {
  status=`ps -ef | grep tns | grep oraclexe`
  if [ "$status" == "" ]
  then
    if [ -f $ORACLE_HOME/bin/tnslsnr ]
    then
      echo "Starting Oracle Net Listener."
      su - oraclexe -c "$ORACLE_HOME/bin/lsnrctl start" #> /dev/null 2>&1
    fi
  fi
  echo "Starting Oracle Database 10g Express Edition Instance."
  su oraclexe -c "$SQLPLUS -s /nolog @$ORACLE_HOME/config/scripts/startdb.sql" #> /dev/null 2>&1
  RETVAL=$?
  if [ $RETVAL -eq 0 ]
  then
    echo
  else
    echo Failed to start Oracle Net Listener using $ORACLE_HOME/bin/tnslsnr
    echo and Oracle Express Database using $ORACLE_HOME/bin/sqlplus.
    RETVAL=1
  fi
  touch /var/lock/oraclexe
  return $RETVAL
}


stop() {
  echo "Shutting down Oracle Database 10g Express Edition Instance."
  su - oraclexe -c "$SQLPLUS -s /nolog @$ORACLE_HOME/config/scripts/shutdb.sql" #> /dev/null 2>&1
  echo Stopping Oracle Net Listener.
  su - oraclexe -c "$ORACLE_HOME/bin/lsnrctl stop" > /dev/null 2>&1
  RETVAL=$?
  echo
  if [ $RETVAL -eq 0 ] && rm -f /var/lock/oraclexe
  then
    return $RETVAL
  fi
}


# See how we were called
case "$1" in
  start)
    start
    ;;
  stop)
    stop
    ;;
  restart|reload)
    stop
    start
    RETVAL=$?
    ;;
  *)
    echo $"Usage: $0 {start|stop|restart}"
    exit 1
esac