Skip to main content

Centos에서 oracle 11g 설치

  1. 패키지 설치하기

    $> yum -y groupinstall "Desktop" "X Window System" "GNOME Desktop Environment" "Desktop Platform Development" "Desktop Platform"
    $> yum -y install glibc* libaio* compat-libstdc* compat-gcc* gcc* libXp* openmotif* compat-db* xorg-x11-deprecated-libs compat-lib*
    $> yum install kde-i18n-Korean -y
    $> yum install fonts-korean -y
    $> yum install -y binutils-2.* compat-libstdc++-33* elfutils* gcc-4.* gcc-c++-4.* glibc-2.* glibc* ksh* libaio* libgomp* libgcc* libstdc++* unixODBC-2* unixODBC-devel* numactl-devel* sysstat* pdksh*
    • Centos6 64비트에서는 추가 패키지 설치
      $> yum install -y xorg-x11-xauth.x86_64 xorg-x11-apps.x86_64
      $> yum install -y libXp libXtst binutils compat-db compat-libstdc++-33 glibc glibc-devel glibc-headers gcc gcc-c++ libstdc++ cpp make libaio ksh elfutils-libelf sysstat libaio libaio-devel setarch  libXp.i686 libXtst-1.0.99.2-3.el6.i686 glibc-devel.i686 libgcc-4.4.4-13.el6.i686 compat-libstdc++* compat-libf2c* compat-gcc* compat-libgcc* libXt.i686 libXtst.i686
      $> yum install -y glibc-2.12-1.7.el6_0.5.i686
  2. 커널 파라미터 적용
    $> echo "fs.suid_dumpable = 1
    fs.aio-max-nr = 1048576
    fs.file-max = 6815744
    kernel.shmall = 2097152
    kernel.shmmax = 536870912
    kernel.shmmni = 4096
    # semaphores: semmsl, semmns, semopm, semmni
    kernel.sem = 250 32000 100 128
    net.ipv4.ip_local_port_range = 9000 65500
    net.core.rmem_default=4194304
    net.core.rmem_max=4194304
    net.core.wmem_default=262144
    net.core.wmem_max=1048586" >> /etc/sysctl.conf
    $> sysctl -p
  3. 계정 설정
    $> echo "oracle              soft    nproc   2047
    oracle              hard    nproc   16384
    oracle              soft    nofile  4096
    oracle              hard    nofile  65536
    oracle              soft    stack   10240" >> /etc/security/limits.conf
    $> groupadd oinstall
    $> useradd -g oinstall oracle
    $> passwd oracle
    {{ 패스워드 입력 2번 }}
    $> mkdir /usr/local/oracle
    $> chown oracle.oinstall /usr/local/oracle
  4. OS정보 수정
    mv /etc/redhat-release /etc/redhat-release_ori
    echo "redhat-4" > /etc/redhat-release
  5. 시스템 변수 설정
    $> echo "
    # Oracle Settings
    TMP=/tmp; export TMP
    TMPDIR=\$TMP; export TMPDIR
    ORACLE_HOSTNAME=orcl.localdomain; export ORACLE_HOSTNAME
    ORACLE_UNQNAME=DB11G; export ORACLE_UNQNAME
    ORACLE_BASE=/usr/local/oracle; export ORACLE_BASE
    ORACLE_HOME=\$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
    ORACLE_SID=orcl; export ORACLE_SID
    PATH=/usr/sbin:\$PATH; export PATH
    PATH=\$ORACLE_HOME/bin:\$PATH; export PATH
    LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
    CLASSPATH=\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib; export CLASSPATH" >> /etc/profile
  6. 시스템 구동시 오라클 구동
    $> echo "
    source /etc/profile
    su - oracle -c \"\$ORACLE_HOME/bin/lsnrctl start\"
    su - oracle -c \"\$ORACLE_HOME/bin/dbstart\"
    " >> /etc/rc.d/rc.local