DB/Oracle/11g ´Ä¶¹½ÃÛ
Ìܼ¡†
Oracle ¤Î¥¹¥Æ¥¥é¥¤¥»¥ó¥¹¡Ê³«È¯¼Ô¥é¥¤¥»¥ó¥¹¡Ë¤Ë¤è¤ê¡¢¼Â¸³¤ä¸¡¾ÚÌÜŪ¤Ç¤ÏËÜÍèͽþ¤Î¥â¥Î¤â¥À¥¦¥ó¥í¡¼¥É¤·¤Æ¥¤¥ó¥¹¥È¡¼¥ë¤Ç¤¤Þ¤¹¡£
¤È¤¤¤¦¤ï¤±¤Ç¡¢Å·²¼¤Î Oracle ÍͤδÇÈÄÀ½ÉʤǤ¢¤ë¤È¤³¤í¤Î Oracle Database 11g ¤ò¼«Âð¤Î Linux ´Ä¶¡ÊRHEL 6¡£CentOS ¤Ç¤â¤¿¤Ö¤ó°ì½ï¡Ë¤ËÆþ¤ì¤ë¤È¤¤¤¦¤ªÏá£
¤Ê¤ª¡¢RHEL 6 ¤Ï¥µ¥Ý¡¼¥ÈÂоݳ°¤Ã¤Ý¤¤¤Î¤Ç¡¢¤â¤·¥¢¥ì¤Ç¤â²æËý¤·¤Þ¤·¤ç¤¦¡£
»²¾È¥É¥¥å¥á¥ó¥È†
¤½¤Î¤â¤Î¥º¥Ð¥ê¤Î¥É¥¥å¥á¥ó¥È¤¬¤¢¤ë¤Î¤Ç¤½¤³¤ò»²¾È¤¹¤ë¡£¤Û¤«¤Î¥×¥é¥Ã¥È¥Õ¥©¡¼¥à¤Î¥¤¥ó¥¹¥È¥ì¡¼¥·¥ç¥ó¥¬¥¤¥É¤âõ¤»¤Ð¤¢¤ë¡£
Í×·ï¤Î³Îǧ†
¸¢¸Â†
Í× root ¸¢¸Â¡£su ¤·¤Æ¤ª¤¯¡£
¥á¥â¥ê†
ºÇÄã 4GB¡£¤±¤Ã¤³¤¦»È¤¦¤Î¤Í¡£
¼«Æ°¥á¥â¥ê´ÉÍý¤ò»È¤¦¾ì¹ç¤Ï¡¢/dev/shm ¤¬ MAX_MEMORY_TARGET ¤È MEMORY_TARGET °Ê¾å¤Ê¤¤¤È¤¤¤±¤Ê¤¤¡£¼«Æ°¶¦Í¥á¥â¥ê´ÉÍý¤Î¾ì¹ç¤Ï¤³¤Î¸Â¤ê¤Ç¤Ï¤Ê¤¤¡£
- /dev/shm ¤ÎÍÆÎ̤γÎǧ
df -h /dev/shm
¥Ç¥£¥¹¥¯†
OS†
RHEL 6 ¤¬¥µ¥Ý¡¼¥ÈÂоݳ°¤Ã¤Ý¤¤¤Î¤Ç¤Á¤ç¤Ã¤Èº¤¤ë¡£´ª¤Ç¿Ê¤á¤ë¡£
¥«¡¼¥Í¥ë†
¥Ñ¥Ã¥±¡¼¥¸†
¥É¥¥å¥á¥ó¥È¤Ë¤Ï RHEL 6 ¤Î¾ÜºÙµ½Ò¤Ê¤·¡£RHEL 5 ¤ÇɬÍפȤµ¤ì¤Æ¤¤¤ë¥Ñ¥Ã¥±¡¼¥¸¤ò¡¢¥Ð¡¼¥¸¥ç¥ó¤òµ¤¤Ë¤»¤ººÇ¿·ÈǤòÊü¤ê¹þ¤ó¤Ç¤ª¤¯¡£
- ¥Ñ¥Ã¥±¡¼¥¸¤Î¥¤¥ó¥¹¥È¡¼¥ë
# ¤³¤ó¤Ê»¨¤ÊÆþ¤ìÊý¤Ç¤¤¤¤¤Î¤«¤Í yum install binutils compat-libstdc++ gcc gcc-c++ glibc glibc-devel glibc-devel-32bit ksh-93r libaio libaio-32bit libaio-devel libaio-devel-32bit libelf libgcc libstdc++ libstdc++-devel make numactl sysstat unixODBC unixODBC-devel
- OUI ¤Î´Ä¶¥Á¥§¥Ã¥¯¤Ç²¿¸Ä¤«¥³¥±¤¿¡£i386 ¤Î¥Ñ¥Ã¥±¡¼¥¸¤¬É¬Íפäݤ¤¡£Í×Ä´ºº
- ̵»ë¤·¤Æ¤âÊ¿µ¤¤Ã¤Ý¤¤¤Î¤Ç̵»ë¤·¤Æ¤ä¤Ã¤Æ¤ß¤Æ¤ë¡£¾ÜºÙ¤Ï¸åÆü
´Ä¶ÀßÄê†
OS ¥°¥ë¡¼¥×¤È¥æ¡¼¥¶¤Î½àÈ÷†
Oracle ¥¤¥ó¥Ù¥ó¥È¥ê¥°¥ë¡¼¥×¤È DBA ¥°¥ë¡¼¥×¡¢Oracle ¥½¥Õ¥È¥¦¥§¥¢½êͼԤΥ桼¥¶¤¬É¬ÍפʤΤÇÄɲ乤롣¤½¤ì¤¾¤ìɸ½à¤Ï oinstall¡¢dba¡¢oracle¡£
¤¹¤Ç¤Ë¥æ¡¼¥¶¤¬Â¸ºß¤¹¤ë¾ì¹ç¤Ï¡¢½ê°¥°¥ë¡¼¥×¤ÎÀßÄê¤ò³Îǧ¤·¤Æ¡¢É¬Íפ¬¤¢¤ì¤Ð½¤Àµ¤¹¤ë¡£
- ¥°¥ë¡¼¥×¤È¥æ¡¼¥¶¤ÎÄɲÃ
# ¥°¥ë¡¼¥×¤ÎÄɲà groupadd -r oinstall groupadd -r dba # ¥æ¡¼¥¶¤ÎÄɲà useradd -g oinstall -G dba oracle # ¥Ñ¥¹¥ï¡¼¥É¤ÎÀßÄê passwd oracle
¥«¡¼¥Í¥ë¥Ñ¥é¥á¡¼¥¿¤ÎÀßÄê†
¥É¥¥å¥á¥ó¥Æ¡¼¥·¥ç¥ó¥¬¥¤¥É¤ò»²¾È¤·¤Æ¡¢Å¬µ¹É¬ÍפÊÃͤò /etc/sysctl.conf ¤Ëµ½Ò¤¹¤ë¡£
- /etc/sysctl.conf ¤Ø¤Îµ½ÒÎã
# Oracle Database 11g Recomended Values net.core.rmem_max = 4194304 net.core.rmem_default = 262144 net.core.wmem_max = 1048576 net.core.wmem_default = 262144 fs.aio-max-nr = 1048576
µ½Ò¤¬¤Ç¤¤¿¤é¥«¡¼¥Í¥ë¤ËÈ¿±Ç¤µ¤»¤ë¡£¥³¥Þ¥ó¥É¤ò¼Â¹Ô¤¹¤ë¤«ºÆµ¯Æ°¤¹¤ë¡£
- ÀßÄê¤ÎÈ¿±Ç
sysctl -p
¥ê¥½¡¼¥¹À©¸Â¤ÎÀßÄê†
¥¤¥ó¥¹¥È¡¼¥ë»þ¤Ë»È¤¦¥æ¡¼¥¶¡Ê¤³¤³¤Ç¤Ï oracle¡Ë¤Î¥ê¥½¡¼¥¹À©¸Â¤ò³Îǧ¤·¤Æ¡¢É¬Íפ¬¤¢¤ì¤ÐÀßÄꤹ¤ë¡£
- ¥ê¥½¡¼¥¹À©¸Â¤Î³Îǧ
# ¥æ¡¼¥¶¤ÎÊѹ¹ su - oracle # ¥Õ¥¡¥¤¥ëµ½Ò»Ò¿ô¤Î¥½¥Õ¥È¥ê¥ß¥Ã¥È ulimit -Sn # ¥Õ¥¡¥¤¥ëµ½Ò»Ò¿ô¤Î¥Ï¡¼¥É¥ê¥ß¥Ã¥È ulimit -Hn # ¥×¥í¥»¥¹¿ô¤Î¥½¥Õ¥È¥ê¥ß¥Ã¥È ulimit -Su # ¥×¥í¥»¥¹¿ô¤Î¥Ï¡¼¥É¥ê¥ß¥Ã¥È ulimit -Hu # ¥¹¥¿¥Ã¥¯¥»¥°¥á¥ó¥È¥µ¥¤¥º¤Î¥½¥Õ¥È¥ê¥ß¥Ã¥È ulimit -Ss # ¥¹¥¿¥Ã¥¯¥»¥°¥á¥ó¥È¥µ¥¤¥º¤Î¥Ï¡¼¥É¥ê¥ß¥Ã¥È ulimit -Hs
¥É¥¥å¥á¥ó¥È¤ò³Îǧ¤·¤ÆÀßÄêÃͤ¬Í×·ï¤òËþ¤¿¤·¤Æ¤¤¤Ê¤±¤ì¤ÐÀßÄê¥Õ¥¡¥¤¥ë¤Ëµ½Ò¤¹¤ë¡£
- /etc/security/limits.conf ¤Îµ½ÒÎã
oracle soft nofile 1024 oracle hard nofile 65536 oracle soft nproc 2047 oracle hard stack 32768
¥Ç¥£¥ì¥¯¥È¥ê¤ÎºîÀ®†
ɬÍפʥǥ£¥ì¥¯¥È¥ê¤òºîÀ®¤·¤Æ½êͼԤä¤é¤Ê¤Ë¤ä¤é¤âÀµ¤·¤¯Êѹ¹¤¹¤ë¡£
- ¥Ç¥£¥ì¥¯¥È¥ê¤ÎºîÀ®
mkdir -p /u01/app chown -R oracle:oinstall /u01/app chmod -R 775 /u01/app
´Ä¶¤ÎÀßÄê†
umask ¤ä¤é´Ä¶ÊÑ¿ô¤ä¤é¤ò¤¤¤¸¤ë¡£
- /home/oracle/.bash_profile ¤Ê¤É¤Ëµ½Ò
# umask ¤ÎÊѹ¹ umask 022 # ´Ä¶ÊÑ¿ô¤Î»ØÄê export ORACLE_BASE=/u01/app/oracle export ORACLE_SID=orcl
¥¤¥ó¥¹¥È¡¼¥ë†
GUI ´Ä¶¤Ç¹Ô¤¦¤Î¤ÇÍץǥ£¥¹¥×¥ì¥¤Àܳ¡£X ¤ò³°¤ËÈô¤Ð¤·¤Æ¤â¤¤¤¤¡ÊÍ× DISPLAY ÀßÄê¡Ë¤·¡¢VNC ¤Ç¤â¤¤¤¤¡£º£²ó¤Ï VNC ´Ä¶¤ò¤¹¤Ç¤Ë¤Ä¤¯¤Ã¤Æ¤¢¤Ã¤¿¤Î¤Ç¤½¤Ã¤Á¤Ç¤ä¤ë¡£
VNC Àܳ¤·¤Æ¡¢oracle ¥æ¡¼¥¶¤Ç¥í¥°¥¤¥ó¤·¤¿¤é¡¢¥À¥¦¥ó¥í¡¼¥É¤·¤Æ¤ª¤¤¤¿ ZIP ¥Õ¥¡¥¤¥ë¤ò²òÅष¤Æ¡¢database/runInstaller ¤ò¼Â¹Ô¤¹¤ë¤À¤±¡£VNC ´Ä¶¤Ç¤ä¤Ã¤¿¤é OUI ¤ÎÆüËܸ줬²½¤±¤¿¤Î¤Ç¤Ò¤È¤Þ¤º LANG=C ²¼¤Ç¼Â¹Ô¤·¤¿¡£
- OUI ¤Î¼Â¹Ô
env LANG=C ./runInstaller
¤¢¤È¤Ï¥¦¥£¥¶¡¼¥É¤Ë½¾¤¦¡£ÀßÄêÆâÍƤÏÆñ¤·¤¯¤Ê¤¤¡£
ºÇ¸å¤Ë root ¤Ç¼Â¹Ô¤·¤Ê¤¤ã¤Ê¤é¤ó¥¹¥¯¥ê¥×¥È¤ò 2 ¤Ä¡Êroot.sh ¤È orainstRoot.sh¡Ë»ØÄꤵ¤ì¤ë¤Î¤Ç¡¢¤½¤ì¤Ï˺¤ì¤º¤Ë root ¤Ç¼Â¹Ô¤¹¤ë¤³¤È¡£
Last-modified: 2011-11-24 (ÌÚ) 00:46:59