DB/Oracle/11g ´Ä¶­¹½ÃÛ

Top/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