數據加載中……
          oracle 在Linux 自啟動方法

          1、 修改Oracle系統配置文件/etc/oratab

          /etc/oratab 格式為: SID:ORACLE_HOME:AUTO

          把AUTO域設置為Y(大寫),只有這樣,oracle 自帶的dbstart和dbshut才能夠發揮作用。我的為:

          TestDB:/home/oracle/product/10.2.0:Y(以oracle 10為例子)
                  2、 編寫服務腳本:
                  如下:

           

          #!/bin/bash

          #

          #################FUNCTION#############

          #

          # AutoStart Oracle and listener

          # AutoStop Oracle and listener

          #

          #####################################

          #

          # Created by ZhouYS 2003-11-26

          #

          case "$1" in

          start)

          echo "Starting Oracle Databases ... "

          echo "-------------------------------------------------" >> /var/log/oracle

          date +" %T %a %D : Starting Oracle Databasee as part of system up." >> /var/log/oracle

          echo "-------------------------------------------------" >> /var/log/oracle

          su - oracle -c "dbstart" >> /var/log/oracle

          echo "Done."

          echo "Starting Oracle Listeners ... "

          echo "-------------------------------------------------" >> /var/log/oracle

          date +" %T %a %D : Starting Oracle Listeners as part of system up." >> /var/log/oracle

          echo "-------------------------------------------------" >> /var/log/oracle

          su - oracle -c "lsnrctl start" >> /var/log/oracle

          echo "Done."

          echo ""

          echo "-------------------------------------------------" >> /var/log/oracle

          date +" %T %a %D : Finished." >> /var/log/oracle

          echo "-------------------------------------------------" >> /var/log/oracle

          touch /var/lock/subsys/oracle

          ;;

          stop)

          echo "Stoping Oracle Listeners ... "

          echo "-------------------------------------------------" >> /var/log/oracle

          date +" %T %a %D : Stoping Oracle Listener as part of system down." >> /var/log/oracle

          echo "-------------------------------------------------" >> /var/log/oracle

          su - oracle -c "lsnrctl stop" >> /var/log/oracle

          echo "Done."

          rm -f /var/lock/subsys/oracle

          echo "Stoping Oracle Databases ... "

          echo "-------------------------------------------------" >> /var/log/oracle

          date +" %T %a %D : Stoping Oracle Databases as part of system down." >> /var/log/oracle

          echo "-------------------------------------------------" >> /var/log/oracle

          su - oracle -c "dbshut" >>/var/log/oracle

          echo "Done."

          echo ""

          echo "-------------------------------------------------" >> /var/log/oracle

          date +" %T %a %D : Finished." >> /var/log/oracle

          echo "-------------------------------------------------" >> /var/log/oracle

          ;;

          restart)

          $0 stop

          $0 start

          ;;

          *)

          echo "Usage: oracle {start|stop|restart}"

          exit 1

          esac


                 將腳本命名為oracle,保存在/etc/rc.d/init.d下。
                 
                  3、建立服務連接:

          系統啟動時啟動數據庫,我們需要以下連結∶

          --------------------------------------------------------------------------------

          $ ln -s ../init.d/oracle /etc/rc.d/rc2.d/S99oracle

          $ ln -s ../init.d/oracle /etc/rc.d/rc3.d/S99oracle

          $ ln -s ../init.d/oracle /etc/rc.d/rc5.d/S99oracle #rc4.d unused

          --------------------------------------------------------------------------------

          要在重新啟動時停止數據庫,我們需要以下連結∶

          --------------------------------------------------------------------------------

          $ ln -s ../init.d/oracle /etc/rc.d/rc0.d/K01oracle # 停止

          $ ln -s ../init.d/oracle /etc/rc.d/rc6.d/K01oracle # 重新啟動

          轉貼于:Oracle認證考試_考試大    

          posted on 2008-12-26 11:54 flyleer 閱讀(114) 評論(0)  編輯  收藏

          主站蜘蛛池模板: 孙吴县| 鄂州市| 乡宁县| 馆陶县| 麟游县| 宝应县| 定陶县| 外汇| 淮南市| 临颍县| 鱼台县| 岑巩县| 米易县| 宁明县| 崇文区| 西贡区| 日喀则市| 新巴尔虎右旗| 中西区| 富民县| 云阳县| 甘肃省| 宜兰县| 宁南县| 宜黄县| 通化市| 巴青县| 上栗县| 柞水县| 孙吴县| 成都市| 综艺| 保康县| 蒲城县| 庄河市| 屏南县| 灵川县| 循化| 汉沽区| 莆田市| 诸暨市|