#!/bin/bash
#
# name: /etc/rc.d/init.d/ora9
# description:	starts and stops oracle 9i database, TNS listener
#		http server, and fixes kernel parameters for oracle


#oracle environment
export ORACLE_HOME=/home/ora9/product/9.2
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/Apache/Apache/bin:$PATH
export NLS_LANG='croatian_croatia.ee8iso8859p2'
export ORACLE_SID=ora9
export DISPLAY=:0
oracle_user=ora9

# see how we're called

case $1 in 
  start)
  # fix kernel parameters
  echo 250 32000 100 128 > /proc/sys/kernel/sem
  echo 2147483648 > /proc/sys/kernel/shmmax
  echo 4096 > /proc/sys/kernel/shmmni
  echo 2097152 > /proc/sys/kernel/shmall
  # start listener, apache and database
  su - "$oracle_user"<<EOO
    lsnrctl start
    apachectl start
    sqlplus /nolog<<EOS
      connect / as sysdba
      startup
EOS
EOO
  touch /var/lock/subsys/oracle
 ;;

 stop)
  # stop listener, apache and database
  su - "$oracle_user"<<EOO
    lsnrctl stop
    apachectl stop
    sqlplus /nolog<<EOS
      connect / as sysdba
      shutdown immediate
EOS
EOO
  rm -f /var/lock/subsys/oracle
  ;;

  *)
  echo "Usage: ora9 [start|stop]"
  ;;

esac