How to Set up Automatic Startup and Shutdown of an Oracle Database on Linux without Using Oracle-Restart

$ORACLE_SID:$ORACLE_HOME:<N|Y>

#! /bin/sh 
 # description: Oracle auto start-stop script.
 #
 # Set ORACLE_HOME to be equivalent to the $ORACLE_HOME
 # from which you wish to execute dbstart and dbshut;
 #
 # Set ORA_OWNER to the user id of the owner of the
 # Oracle database in ORACLE_HOME.
 
 

case "$1" in
 'start')
  # Start the Oracle databases:
  # The following command assumes that the oracle login
  # will not prompt the user for any values
  # Remove "&" if you don't want startup as a background process.
  su - $ORA_OWNER -c "$ORA_HOME/bin/dbstart $ORA_HOME" &
  touch /var/lock/subsys/dbora
  ;;
 
 'stop')
  # Stop the Oracle databases:
  # The following command assumes that the oracle login
  # will not prompt the user for any values
  su - $ORA_OWNER -c "$ORA_HOME/bin/dbshut $ORA_HOME" &
  rm -f /var/lock/subsys/dbora
  ;;
 esac

$ORACLE_HOME/bin/lsnrctl {start|stop} listener_name

# chgrp dba dbora
 # chmod 750 dbora

# ln -s /etc/init.d/dbora /etc/rc.d/rc0.d/K01dbora
 # ln -s /etc/init.d/dbora /etc/rc.d/rc3.d/S99dbora
 # ln -s /etc/init.d/dbora /etc/rc.d/rc5.d/S99dbora

chkconfig --add dbora

# service dbora start
 # service dbora stop