[Oracle] Linux Cent OS 7에서 Oracle 12c R2 Single 설치

< 필수 패키지 설치 >

yum install binutils -y

yum install compat-libstdc++-33 -y

yum install compat-libstdc++-33.i686 -y

yum install gcc -y

yum install gcc-c++ -y

yum install glibc -y

yum install glibc.i686 -y

yum install glibc-devel -y

yum install glibc-devel.i686 -y

yum install ksh -y

yum install libgcc -y

yum install libgcc.i686 -y

yum install libstdc++ -y

yum install libstdc++.i686 -y

yum install libstdc++-devel -y

yum install libstdc++-devel.i686 -y

yum install libaio -y

yum install libaio.i686 -y

yum install libaio-devel -y

yum install libaio-devel.i686 -y

yum install libXext -y

yum install libXext.i686 -y

yum install libXtst -y

yum install libXtst.i686 -y

yum install libX11 -y

yum install libX11.i686 -y

yum install libXau -y

yum install libXau.i686 -y

yum install libxcb -y

yum install libxcb.i686 -y

yum install libXi -y

yum install libXi.i686 -y

yum install make -y

yum install sysstat -y

yum install unixODBC -y

yum install unixODBC-devel -y

yum install zlib-devel -y

yum install zlib-devel.i686 -y

==================================================================

rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n'binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel

==================================================================

 

vi /etc/sysctl.conf 설정

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 실제 메모리 크기의 40%

kernel.shmmax = 물리적 메모리의 절반 크기

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048586

 

/sbin/sysctl -p

sysctl -p

=======================================================

vi /etc/security/limits.conf

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft stack 10240

oracle hard stack 32768

=========================================================

vi /etc/pam.d/login

session required pam_limits.so

=========================================================

groupadd -g 501 oinstall

groupadd -g 502 dba

=========================================================

useradd -g oinstall -G dba oracle

passwd oracle

==========================================================

oracle 계정에서

vi .bash_profile

export TMP=/tmp

export TMPDIR=$TMP

export ORACLE_BASE=/u01/oracle

export ORACLE_HOME=$ORACLE_BASE/12.2.0/dbhome_1

export ORACLE_SID=

export BASE_PATH=/usr/s/bin:$PATH

export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$BASE_PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

if [ $USER = "oracle" ]; then

if [ $SHELL = "/bin/ksh" ]; then

ulimit -p 16384

ulimit -n 65536

else

ulimit -u 16384 -n 65536

fi

umask 022

fi

==============================================================

vi /home/oracle/.bash_profile

 

export TMP=/tmp

export TMPDIR=/tmp

export ORACLE_BASE=/home/oracle/db

export ORACLE_SID=orcl

export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1

export ORACLE_HOME_LISTNER=$ORACLE_HOME/bin/lsnrctl

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH=$ORACLE_HOME/bin:$PATH

 

 

 

---

 

 

 

 

< 리스너 확인 >

lsnrctl status

 

< DB 가동 확인 >

-- SQL*Plus에 sysdba 권한으로 로그인
sqlplus / as sysdba

-- 데이터베이스 인스턴스의 상태 확인
SELECT status FROM v$instance;

 

< 메모리 크기 확인 >

-- SQL*Plus에 로그인 후
SHOW PARAMETER sga;

SHOW PARAMETER sga_max_size;
SHOW PARAMETER sga_target;

---