DB/Oracle/11g Ķ

Top/DB/Oracle/11g Ķ

ܼ

Oracle Υƥ饤󥹡ʳȯԥ饤󥹡ˤˤꡢ¸両ŪǤͭΥΤɤƥ󥹥ȡǤޤ

Ȥ櫓ǡŷ Oracle ͤδʤǤȤ Oracle Database 11g Linux ĶRHEL 6CentOS Ǥ⤿֤ˤȤá

ʤ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 δĶåDzĤi386 ΥѥåɬפäݤĴ
    • ̵뤷ƤʿäݤΤ̵뤷ƤäƤߤƤ롣ܺ٤ϸ

Ķ

OS 롼פȥ桼ν

Oracle ٥ȥꥰ롼פ DBA 롼סOracle եȥͭԤΥ桼ɬפʤΤɲä롣줾ɸ oinstalldbaoracle

Ǥ˥桼¸ߤϡ°롼פǧơɬפн롣

  • 롼פȥ桼ɲ

ͥѥ᡼

ɥơ󥬥ɤ򻲾ȤơŬɬפͤ /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