Oracle Database HOWTO : ¦Û°Ê±Ò°Ê¤Î°±¤î
Previous: ¥Î¤áªº³]©w
Next: ¨ä¥L¨Æ©y

6. ¦Û°Ê±Ò°Ê¤Î°±¤î

6.1. dbstart ¤Î dbstop

Oracle ¸ê®Æ®wªº¦Û°Ê±Ò°Ê¤Î°±¤î¥iÄy Oracle ´£¨Ñªº dbstart ¤Î dbshut ÀɹF¦¨ (¦b 7.3.3.0.0 ¤¤¡^¡C³o¨ÇÀɮפS­A¨Ì¾a /etc/oratab ¦s¦b¤~¯à¨Ï¥Î¡]ÁöµM§ó§ï dbshut ©M dbstart ÀÉ¥i¨Ï¸Ñ°£³o­­¨î¡C¡

/etc/oratab Àɮ榡¦p¤U¡G


SID:ORACLE_HOME:AUTO

¨Ò¦p


orcl:/home/oracle/7.3.3.0.0:Y
leaveup:/home/oracle/7.3.2.1.0:N

6.2. init.d ¤Î rc.d

­n¦b¶}¾÷Ãö¾÷®É¦Û°Ê±Ò°Ê©Mµ²Éô¸ê®Æ®wªº¸Ü¡A§A»Ý­n­×§ï Linux ªº±Ò°Ê©R¥O½Z¡C³o¨Ã¤£§xÃø¡A¤£¹L¡A§Ú»Ý­n«ü¥X³o¨Ç§ï°Ê¦]À³¤£¦Pªº Linux µo¦æª©¥»¡]slackware, debian, redhat µ¥¡^¦Ó¦³©Ò¤£¦P¡C§Ú³o¨Ç¨Ò¤l¾A¥Î©ó Redhat 5.0¡C­n¬°§A©Ò¥Îªº Linux §@¥X­×§ï¡A½Ð¥ý°Ñ¦Ò§A¤âÀY¤Wªº Linux ¤å¥ó¡C¡]ÁöµM³o¹ê»Ú¤WÀ³¸Ó¾A¥Î©ó©Ò¦³ Sys V UNIX¡C¡

­º¥ý¡A§Ú­Ì­n«Ø¥ß·|°õ¦æ /etc/rc.d/init.d ¥Ø¿ý¤¤ dbshut ¤Î dbstart ªº©R¥O½Z¡C§â¥H¤UÀɮשR¦W¬° /etc/rc.d/init.d/oracle:


#!/bin/sh
#
# /etc/rc.d/init.d/oracle
# ¸Ñ»¡¡J±Ò°Ê¤Î°±¤î Oracle ¸ê®Æ®w©MºÊÅ¥µ{¦¡
# Àˬd¦p¦ó°õ¦æ©R¥O½Z
case "$1" in
  start)
        echo -n "Starting Oracle Databases: "
        echo "----------------------------------------------------" >> /var/log/oracle
        date +"! %T %a %D : Starting Oracle Databases as part of system up." >> /var/log/oracle
        echo "----------------------------------------------------" >> /var/log/oracle
        su - oracle -c dbstart >> /var/log/oracle
        echo "Done."
        echo -n "Starting Oracle Listeners: "
        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 -n "Shutting Down Oracle Listeners: "
        echo "----------------------------------------------------" >> /var/log/oracle
        date +"! %T %a %D : Shutting Down Oracle Databases 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 -n "Shutting Down Oracle Databases: "
        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)
        echo -n "Restarting Oracle Databases: "
        echo "----------------------------------------------------" >> /var/log/oracle
        date +"! %T %a %D : Restarting Oracle Databases as part of system up." >> /var/log/oracle
        echo "----------------------------------------------------" >> /var/log/oracle
        su - oracle -c dbstop >> /var/log/oracle
        su - oracle -c dbstart >> /var/log/oracle
        echo "Done."
        echo -n "Restarting Oracle Listeners: "
        su - oracle -c "lsnrctl stop" >> /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
        ;;
  *)
        echo "Usage: oracle {start|stop|restart}"
        exit 1
esac

¤£­n§[¶Þ©óÀˬd³o­ÓÀɮר쩳¦³¨S¦³¯uªº¥¿½T¦a±Ò°Ê©M°±¤î¨t²Î¤¤ªº¸ê®Æ®w¡C½ÐÀˬd°O¿ýÀÉ(log file)¡A¬Ý¬Ý¦³¨S¦³¿ù»~°T®§¡C

§Ë§´³o©R¥O½Z«á¡A§Ú­Ì­n¦b¥¿½Tªº°õ¦æµ¥¯Å¥Ø¿ý (runlevel directories) /etc/rc.d/rcX.d ¤¤«Ø¥ß¤Î§R°£²Å¸¹³sµ² (symbolic links)¡C

¥H¤U«ü¥O½T«O¦b°õ¦æµ¥¯Å 2, 3 ¤Î 4 ¤U·|¥s¥X¸ê®Æ®w¡J


$ 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/rc4.d/S99oracle

­n¦b­«·s±Ò°Ê®É°±¤î¸ê®Æ®w¡A§Ú­Ì»Ý­n¥H¤U³sµ²¡J


$ ln -s ../init.d/oracle /etc/rc.d/rc0.d/K01oracle          # °±¤î
$ ln -s ../init.d/oracle /etc/rc.d/rc6.d/K01oracle          # ­«·s±Ò°Ê


Oracle Database HOWTO : ¦Û°Ê±Ò°Ê¤Î°±¤î
Previous: ¥Î¤áªº³]©w
Next: ¨ä¥L¨Æ©y