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 ¤ÇɬÍפȤµ¤ì¤Æ¤¤¤ë¥Ñ¥Ã¥±¡¼¥¸¤ò¡¢¥Ð¡¼¥¸¥ç¥ó¤òµ¤¤Ë¤»¤ººÇ¿·ÈǤòÊü¤ê¹þ¤ó¤Ç¤ª¤¯¡£
- ¥Ñ¥Ã¥±¡¼¥¸¤Î¥¤¥ó¥¹¥È¡¼¥ë
- OUI ¤Î´Ä¶¥Á¥§¥Ã¥¯¤Ç²¿¸Ä¤«¥³¥±¤¿¡£i386 ¤Î¥Ñ¥Ã¥±¡¼¥¸¤¬É¬Íפäݤ¤¡£Í×Ä´ºº
- ̵»ë¤·¤Æ¤âÊ¿µ¤¤Ã¤Ý¤¤¤Î¤Ç̵»ë¤·¤Æ¤ä¤Ã¤Æ¤ß¤Æ¤ë¡£¾ÜºÙ¤Ï¸åÆü
´Ä¶ÀßÄê †
OS ¥°¥ë¡¼¥×¤È¥æ¡¼¥¶¤Î½àÈ÷ †
Oracle ¥¤¥ó¥Ù¥ó¥È¥ê¥°¥ë¡¼¥×¤È DBA ¥°¥ë¡¼¥×¡¢Oracle ¥½¥Õ¥È¥¦¥§¥¢½êͼԤΥ桼¥¶¤¬É¬ÍפʤΤÇÄɲ乤롣¤½¤ì¤¾¤ìɸ½à¤Ï oinstall¡¢dba¡¢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¡Ë¤Î¥ê¥½¡¼¥¹À©¸Â¤ò³Îǧ¤·¤Æ¡¢É¬Íפ¬¤¢¤ì¤ÐÀßÄꤹ¤ë¡£
- ¥ê¥½¡¼¥¹À©¸Â¤Î³Îǧ
¥É¥¥å¥á¥ó¥È¤ò³Îǧ¤·¤ÆÀßÄêÃͤ¬Í×·ï¤òËþ¤¿¤·¤Æ¤¤¤Ê¤±¤ì¤ÐÀßÄê¥Õ¥¡¥¤¥ë¤Ëµ½Ò¤¹¤ë¡£
- /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 ¤Ê¤É¤Ëµ½Ò
¥¤¥ó¥¹¥È¡¼¥ë †
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