數(shù)據(jù)加載中……
          oracle 在Linux 自啟動(dòng)方法

          1、 修改Oracle系統(tǒng)配置文件/etc/oratab

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

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

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

           

          #!/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、建立服務(wù)連接:

          系統(tǒng)啟動(dòng)時(shí)啟動(dòng)數(shù)據(jù)庫(kù),我們需要以下連結(jié)∶

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

          $ 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

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

          要在重新啟動(dòng)時(shí)停止數(shù)據(jù)庫(kù),我們需要以下連結(jié)∶

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

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

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

          轉(zhuǎn)貼于:Oracle認(rèn)證考試_考試大    

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

          主站蜘蛛池模板: 武威市| 宜兰市| 修武县| 呈贡县| 和林格尔县| 怀安县| 临澧县| 黔南| 定西市| 读书| 澎湖县| 冷水江市| 开平市| 大田县| 克东县| 新干县| 浑源县| 石泉县| 阿坝县| 海安县| 万全县| 上犹县| 南雄市| 石阡县| 古田县| 武安市| 济宁市| 通化市| 万州区| 集贤县| 虞城县| 车致| 黄山市| 永新县| 莱州市| 句容市| 绥宁县| 潍坊市| 北安市| 湘潭市| 云梦县|