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