[Oracle 11g] Pre-Installation Oracle 11gR2(11.2.0.1) for CentOS 7

### root permission ###

 

 

1. Install Required Packages

# yum install binutils \
              compat-libcap1 \
              compat-libstdc++-33.i686 \
              compat-libstdc++-33 \
              elfutils-libelf \
              elfutils-libelf-devel \
              gcc \
              gcc-c++ \
              glibc.i686 \
              glibc \
              glibc-common \
              glibc-devel.i686 \
              glibc-devel \
              glibc-static \
              glibc-static.i686 \
              ksh \
              libaio.i686 \
              libaio \
              libaio-devel.i686 \
              libaio-devel \
              libgcc.i686 \
              libgcc \
              libstdc++.i686 \
              libstdc++ \
              libstdc++-devel.i686 \
              libstdc++-devel \
              libXi.i686 \
              libXi \
              libXtst.i686 \
              libXtst \
              make \
              sysstat \
              unixODBC \
              unixODBC.i686 \
              unixODBC-devel \
              unixODBC-devel.i686 \
              xclock \
              xterm

 

 

2. Environment Configuration

# vi /etc/hosts
192.168.0.1    MYSTUDY.localdomain MYSTUDY

저장

 

# vi /etc/selinux/config
LINE 7:
SELINUX=disabled

저장

 

# vi /usr/lib/sysctl.d/00-system.conf
Line 6:
# Disable netfilter on bridges.
#net.bridge.bridge-nf-call-ip6tables = 0
#net.bridge.bridge-nf-call-iptables = 0
#net.bridge.bridge-nf-call-arptables = 0

저장

 

# vi /etc/sysctl.conf

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

저장

 

# vi /etc/pam.d/login
session    required     pam_selinux.so open
session    required     pam_namespace.so
session    required    pam_limits.so
session    optional     pam_keyinit.so force revoke
session    include      system-auth
session    include      postlogin
-session   optional     pam_ck_connector.so

저장

 

3 . Create User and Groups for Oracle 11gR2

# groupadd -g 900 dba
# groupadd -g 910 oper
# groupadd -g 920 asmadmin
# groupadd -g 930 oinstall

# mkdir /app
# useradd -g dba -G oinstall,oper,asmadmin -u 1100 -d /app/orauser orauser

# passwd orauser
  -> Setting Password for orauser

# cd /app
# chown orauser.dba orauser
# chmod 755 -R orauser

# mkdir -p /logs/orauser
# cd /logs
# chown orauser.dba orauser
# chmod 755 -R orauser

 

# vi /etc/security/limits.conf
# for Oracle
orauser    soft     nproc    2047
orauser    hard    nproc    16384
orauser    soft     nofile    1024
orauser    hard    nofile    65536

저장

 

# shutdown -r now (or reboot)

 

 

### orauser Permission ###

 

 

1. profile setting

# vi .bash_profile
# for Oracle
export ORACLE_HOSTNAME=MYSTUDY
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_OWNER=orauser
export ORACLE_BASE=/app/orauser/oracle
export ORACLE_HOME=$ORACLE_BASE/products/11.2.0
export ORACLE_LOG=/logs/orauser
export ORACLE_SID=MYDB
export NLS_LANG=American_America.UTF8    (or KOREAN_KOREA.UTF8)
export ORACLE_TERM=xterm
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS10=$ORACLE_HOME/nls/data
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME:/usr/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/rdbms/lib
export LIBPATH=$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib
export CLASSPATH=$ORACLE_HOME/jdk/jre/:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export EDITOR=vi
if [ $USER = "orauser" ]; then
    if [ $SHELL = "/bin/ksh" ]; then
        ulimit -p 16384
        ulimit -n 65536
    else
        ulimit -u 16384 -n 65536
    fi
fi

저장

 

# exit (logout and re-login)