[MEGA LOG]ORACLE Database改成開機啟動

修改/etc/rc.d/rc.local 檔案內容

su - oracle -c "lsnrctl start"
sleep 5
su - oracle -c "echo startup |sqlplus \"/as sysdba\" "
su - oracle -c "lsnrctl set log_status off"

或 修改/etc/rc.d/rc.local 檔案內容

/home/oracle/startdb.sh << /home/oracle/startdb.log 2 <&1

/home/oracle/startdb.sh內容

#!/bin/bash
echo"######starting oracle##${date +%F\ %H:%M:%S}###"
su - oracle <<eom
source /home/oracle/.bash_profile
lsnrctl start
sqlplus /nolog <<eof
conn / as sysdba
startup
exit
eof
exit
eof
echo"#########################END####################"