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 ɬפȤƤѥå򡢥С򵤤ˤǿǤǤ

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

Ķ

OS 롼פȥ桼ν

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

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

  • 롼פȥ桼ɲ
    # 롼פɲ
    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 (2249d)