본문 바로가기

쓰기

Centos에서 oracle 12c 설치하기

2021.09.27 01:58

이곤아이 조회 수:485

Centos에서 Oracle 12C설치하기

/etc/hosts에 호스트네임 정보 수정 (localhost 말고...)

  1. 패키지 설치하기
    $> yum install binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33.i686 gcc gcc-c++ glibc glibc.i686 glibc-devel glibc-devel.i686 ksh libgcc -y
    $> yum install libgcc.i686 libstdc++ libstdc++.i686 libstdc++-devel libstdc++-devel.i686 libaio libaio.i686 libaio-devel libaio-devel.i686 libXext libXext.i686 -y
    $> yum install libXtst libXtst.i686 libX11 libX11.i686 libXau libXau.i686 libxcb libxcb.i686 libXi libXi.i686 unixODBC unixODBC-devel -y
  2. 커널파라미터 수정
    $> echo "fs.file-max = 6815744
    kernel.sem = 250 32000 100 128
    kernel.shmmni = 4096
    kernel.shmall = 1073741824
    kernel.shmmax = 4398046511104
    net.core.rmem_default = 262144
    net.core.rmem_max = 4194304
    net.core.wmem_default = 262144
    net.core.wmem_max = 1048576
    fs.aio-max-nr = 1048576
    net.ipv4.ip_local_port_range = 9000 65500" >> /etc/sysctl.conf
    $> sysctl -p
  3. 계정정보 설정
    $> echo "oracle   soft   nofile    1024
    oracle   hard   nofile    65536
    oracle   soft   nproc    16384
    oracle   hard   nproc    16384
    oracle   soft   stack    10240
    oracle   hard   stack    32768" >> /etc/security/limits.conf 
    
    $> groupadd -g 54321 oinstall
    $> groupadd -g 54322 dba
    $> groupadd -g 54323 oper
    $> useradd -u 54321 -g oinstall -G dba,oper oracle
    $> passwd oracle
    {{ 패스워드 입력 2회 }}
    $> mkdir -p /usr/local/oracle/product/12.1.0/db_1
    $> mkdir /usr/local/oraInventory
    $> chown -R oracle:oinstall /usr/local/oracle
    $> chown oracle.oinstall /usr/local/oraInventory
    $> chmod -R 775 /usr/local/oracle
  4. 시스템 변수 설정
    $> echo "
    # Oracle Settings
    export TMP=/tmp
    export TMPDIR=\$TMP
    export ORACLE_HOSTNAME=orcl.localdomain
    export ORACLE_UNQNAME=orcl
    export ORACLE_BASE=/usr/local/oracle
    export ORACLE_HOME=\$ORACLE_BASE/product/12.1.0/db_1
    export ORACLE_SID=orcl
    export PATH=/usr/sbin:\$PATH
    export PATH=\$ORACLE_HOME/bin:\$PATH
    export LD_LIBRARY_PATH=\$ORACLE_HOME/lib:/lib:/usr/lib
    export CLASSPATH=\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib" >> /home/oracle/.bash_profile
  5. 시스템 구동 후 DB실행
    $> echo "
    source /etc/profile
    su - oracle -c \"\$ORACLE_HOME/bin/lsnrctl start\"
    su - oracle -c \"\$ORACLE_HOME/bin/dbstart\"
    " >> /etc/rc.d/rc.local