[SQL] 纯文本查看 复制代码
#! /bin/bash
case "$1" in
start)
echo "Starting Oracle Listener and Database....."
echo "----------------------------------------------" >> /var/log/oracle.log
echo "`date +%T%a%D`:Starting Oracle Listener and Database....." >> /var/log/oracle.log
echo "---------------------------------------------" >> /var/log/oracle.log
su - oracle -c dbstart >> /var/log/oracle.log
echo "Done"
echo ""
echo "----------------------------------------------" >> /var/log/oracle.log
;;
stop)
echo "stoping Oracle Listener and Database....."
echo "----------------------------------------------" >> /var/log/oracle.log
echo "`date +%T%a%D`:Stoping Oracle Listener and Database....." >> /var/log/oracle.log
echo "---------------------------------------------" >> /var/log/oracle.log
su - oracle -c dbshut >> /var/log/oracle.log
echo "Done"
echo ""
echo "----------------------------------------------" >> /var/log/oracle.log
;;
*)
echo "Usage: oracle{start | stop}"
;;
esac