Oracle startup script

Upstart

# description "start and stop oracle instance"

start on runlevel [3]
stop on runlevel [!3]

console log
chdir /home/oracle
setuid oracle
setgid oinstall
expect fork

env ORACLE_BASE=/u01/app/oracle
env ORACLE_SID=ORCL
env ORAENV_ASK=NO

script
 . oraenv
 echo startup | sqlplus '/ as sysdba'
 lsnrctl start LISTENER
 echo 'ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;' | sqlplus '/ as sysdba'

end script

pre-stop script
 . oraenv
 echo 'ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;' | sqlplus '/ as sysdba'
 echo 'shutdown immediate' | sqlplus '/ as sysdba'
 lsnrctl stop LISTENER

end script