CentOS 사전 준비 및 오라클 다운로드

CentOS 패키지 설치

##yum_for_oracle12c.sh
yum update -y
yum install binutils -y
yum install compat-libcap1 -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

Oracle 12c 다운로드

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

Create Group and Users for Oracle

su -
groupadd -g 601 oinstall
groupadd -g 602 dba
groupadd -g 603 backupdba
groupadd -g 604 dgdba
groupadd -g 605 kmdba
groupadd -g 606 oper
useradd -u 60101 -g oinstall -G dba,backupdba,dgdba,kmdba,oper oracle
mkdir /opt/oracle
chown oracle:oinstall /opt/oracle
passwd oracle

환경변수 설정

#Oracle Settings
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_HOSTNAME=orcl.localdomain
export ORACLE_UNQNAME=db1
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db_1
export ORACLE_SID=db1
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

터미널 X DISPLAY 설정

su -
DISPLAY=:0.0
export DISPLAY
xhost +
su – oracle
DISPLAY=:0.0
export DISPLAY
#xclock

Oracle 12c 설치

1. Unzip
   unzip linuxamd*1of2.zip
unzip linuxamd*2of2.zip
2. Install
   ./runInstaller
3. Listener
4. Create DB