dbstart
¤Î dbstop
Oracle ¸ê®Æ®wªº¦Û°Ê±Ò°Ê¤Î°±¤î¥iÄy Oracle ´£¨Ñªº dbstart
¤Î dbshut
ÀɹF¦¨ (¦b 7.3.3.0.0 ¤¤¡^¡C³o¨ÇÀɮפSA¨Ì¾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
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¡Cn¬°§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±Ò°Ê