Script for sql shutdown.

Script for sql shutdown.

 

  

Can you please help with the following.

I need to run the following command as a cron job, but as soon as I conn
/ as sysdba, the script stop. I know I need to use EOF,,, but not sure
where....

Can you please help.

su - orauser
cd
. DEV.env
lsnrctl stop DEV
sqlplus /nolog
conn / as sysdba
shutdown immediate
sleep 60
exit


Oracle LazyDBA home page