Linux下自動啟動和關閉ORACLE的指令碼

自動啟動ORACLE服務
在oracle使用者下：
   vi Start_ORA.sh
--------------------------------
echo "Begin to start the oracle!"
lsnrctl start
sqlplus /nolog <<EOF
connect /as sysdba
startup
exit
EOF
echo "Oracle just have been started!"
exit

自動關閉ORACLE服務
vi Stop_ORA.sh
--------------------------------
echo "Begin to stop the oracle!"
sqlplus /nolog <<EOF
connect /as sysdba
shutdown immediate
exit
EOF
lsnrctl stop
echo "Oracle just have been stopped!"
exit

指令碼編寫完成後分別給這兩個指令碼執行許可權
chmod a+x Start_ORA.sh
chmod a+x Stop_ORA.sh
將啟動和關閉oracle指令碼加到系統的開機自啟動
vi /etc/rc.local
su - oracle -c "/home/oracle/Start_ORA.sh" ＃啟動oracle

作者“changhui-liang”