Home | Mirror | Search |
Oracle 817 資料庫啟動腳本
#!/bin/bash ############################################################## # Script to startup and shutdown Oracle and listener # File:/etc/rc.d/init.d/orcl ############################################################## # Setup environment for script execution #./home/oracle/.bash_profile # ORACLE_HOME=/u01/app/oracle/product/8.1.7 # Determine and execute action based on command line parameter case "$1" in start) echo "Starting Oracle database(s) listed in /etc/oratab ..." sleep 2 su - oracle -c "$ORACLE_HOME/bin/dbstart" echo "Starting TNS listener ..." sleep 2 su - oracle -c "$ORACLE_HOME/bin/lsnrctl start" touch /var/lock/subsys/orcl ;; stop) echo "Shutting down TNS listener ..." sleep 2 su - oracle -c "$ORACLE_HOME/bin/lsnrctl stop" echo "Shutting down Oracle database(s) listed in /etc/oratab ..." su - oracle -c "$ORACLE_HOME/bin/dbshut" rm -f /var/lock/subsys/orcl ;; status) ps -ax | grep -e ora_ -e tnslsnr ;; *) echo "Usage: $1 {start|stop|status}" ;; esac exit 0