Oracle 8.0.5 on Debian


Startup script
Don't forget to change auto-start flag on /etc/oratab from 'N' to 'Y'
#! /bin/sh
ORA_HOME=/home/oracle/app/product/oracle/8.0.5
ORA_OWNER=oracle

if [ ! -f $ORA_HOME/bin/dbstart -o ! -d $ORA_HOME ]
then
  echo "Oracle startup: cannot start"
  exit
fi

case $1 in 
  'start')
    echo "Oracle startup"
    env LD_LIBRARY_PATH=$ORA_HOME/lib su $ORA_OWNER -c $ORA_HOME/bin/dbstart
    env ORACLE_HOME=$ORA_HOME su $ORA_OWNER -c $ORA_HOME/bin/lsnr-start
    ;;

  'stop')
    echo "Oracle shutdown"
    env ORACLE_HOME=$ORA_HOME su $ORA_OWNER -c $ORA_HOME/bin/lsnr-stop
    env LD_LIBRARY_PATH=$ORA_HOME/lib su $ORA_OWNER -c $ORA_HOME/bin/dbshut
    ;;
    
  *)
    echo "Usage: $0 {start|stop}"
    exit 1
    ;;
esac

Listener startup and shutdown script
#!/bin/sh
#lsnr-start
$ORACLE_HOME/bin/lsnrctl start

#!/bin/sh
#lsnr-stop
$ORACLE_HOME/bin/lsnrctl stop

$Id: oracle.html,v 1.4 2000/03/28 13:34:44 andika Exp andika $