Centos에서 oracle 12c 설치하기

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