一台linux機器上安裝了oracle10g,現在使用它做測試用,公司要求下班后關機,上班后開機,但是每次還得啟停庫,所以寫個腳本.
#!/bin/sh
#!/bin/sh
# This Script For Oracle 10g db
# Script Name : oradb
export ORACLE_OWNER=oracle
export ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export ORACLE_SID=moe210
case "$1" in
start)
echo $ORACLE_HOME >> /var/log/oracledb
echo $ORACLE_SID >> /var/log/oracledb
echo $ORACLE_OWNER >> /var/log/oracledb
echo "Starting Oracle Listeners ......................." >> /var/log/oracledb
echo "-------------------------------------------------" >> /var/log/oracledb
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/lsnrctl start" >> /var/log/oracledb
echo "-------------------------------------------------" >> /var/log/oracledb
echo "Done............................................." >> /var/log/oracledb
echo "Starting Oracle Databases ......................." >> /var/log/oracledb
echo "-------------------------------------------------" >> /var/log/oracledb
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/sqlplus / as sysdba" << EOF >>/var/log/oracledb
startup
exit
EOF
echo "Done."
;;
stop)
rm -f /var/lock/subsys/oracle
echo "Stoping Oracle Listeners ... "
echo "-------------------------------------------------" >> /var/log/oracledb
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/lsnrctl stop" >> /var/log/oracledb
echo "Done."
echo "Stoping Oracle Databases ... "
echo "-------------------------------------------------" >> /var/log/oracledb
su - $ORACLE_OWNER -c "$ORACLE_HOME/bin/sqlplus / as sysdba" << EOF >>/var/log/oracledb
shutdown immediate
exit
EOF
echo "Done."
echo "-------------------------------------------------" >> /var/log/oracledb
date " %T %a %D : Finished." >> /var/log/oracledb
echo "-------------------------------------------------" >> /var/log/oracledb
;;
restart)
$0 stop
$0 start
;;
*)
echo "Usage: oradb {start|stop|restart}"
exit 1
esac
給這個腳本執行許可權,並加在rc.local里.
本文出自 「剛剛出殼的小鳥」 博客,請務必保留此出處http://qhd2004.blog.51cto.com/629417/454083
