Install Oracle Database 12c R2 ~ Oracle Cloud Administrator

Hardware Requirments

Disk Space Requirements on Linux x86-64

Database Edition	Disk Space
Enterprise Edition	7.5 GB
Standard Edition 2	7.5 GB

Memory Requirement

RAM	Swap Space
Between 1 GB and 2 GB	1.5 times the size of the RAM
Between 2 GB and 16 GB	Equal to the size of the RAM
More than 16 GB	16 GB

OS Requirement

Oracle Linux 7, Red Hat Enterprise Linux 7 Distributions Kernel 3.10.0-54.0.1.el7.x86_64 or later
Oracle Linux 6, Red Hat Enterprise Linux 6 Distributions Kernel 2.6.32-71.el6.x86_64 or later

Package for RHEL 7

binutils-2.23.52.0.1-12.el7.x86_64
compat-libcap1-1.10-3.el7.x86_64
compat-libstdc++-33-3.2.3-71.el7.i686
compat-libstdc++-33-3.2.3-71.el7.x86_64
gcc-4.8.2-3.el7.x86_64
gcc-c++-4.8.2-3.el7.x86_64
glibc-2.17-36.el7.i686
glibc-2.17-36.el7.x86_64
glibc-devel-2.17-36.el7.i686
glibc-devel-2.17-36.el7.x86_64
ksh
libaio-0.3.109-9.el7.i686
libaio-0.3.109-9.el7.x86_64
libaio-devel-0.3.109-9.el7.i686
libaio-devel-0.3.109-9.el7.x86_64
libgcc-4.8.2-3.el7.i686
libgcc-4.8.2-3.el7.x86_64
libstdc++-4.8.2-3.el7.i686
libstdc++-4.8.2-3.el7.x86_64
libstdc++-devel-4.8.2-3.el7.i686
libstdc++-devel-4.8.2-3.el7.x86_64
libXi-1.7.2-1.el7.i686
libXi-1.7.2-1.el7.x86_64
libXtst-1.2.2-1.el7.i686
libXtst-1.2.2-1.el7.x86_64
make-3.82-19.el7.x86_64
sysstat-10.1.5-1.el7.x86_64

Package for RHEL 6

binutils-2.20.51.0.2-5.11.el6 (x86_64)
compat-libcap1-1.10-1 (x86_64)
compat-libstdc++-33-3.2.3-69.el6 (x86_64)
compat-libstdc++-33-3.2.3-69.el6 (i686)
gcc-4.4.4-13.el6 (x86_64)
gcc-c++-4.4.4-13.el6 (x86_64)
glibc-2.12-1.7.el6 (i686)
glibc-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6 (i686)
ksh
libgcc-4.4.4-13.el6 (i686)
libgcc-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (i686)
libstdc++-devel-4.4.4-13.el6 (x86_64)
libstdc++-devel-4.4.4-13.el6 (i686)
libaio-0.3.107-10.el6 (x86_64)
libaio-0.3.107-10.el6 (i686)
libaio-devel-0.3.107-10.el6 (x86_64)
libaio-devel-0.3.107-10.el6 (i686)
libXext-1.1 (x86_64)
libXext-1.1 (i686)
libXtst-1.0.99.2 (x86_64)
libXtst-1.0.99.2 (i686)
libX11-1.3 (x86_64)
libX11-1.3 (i686)
libXau-1.0.5 (x86_64)
libXau-1.0.5 (i686)
libxcb-1.5 (x86_64)
libxcb-1.5 (i686)
libXi-1.3 (x86_64)
libXi-1.3 (i686)
make-3.81-19.el6
sysstat-9.0.4-11.el6 (x86_64)

Use Command below to verify rpm installed or not.

rpm -q binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libgcc libstdc++ libstdc++-devel libaio libaio-devel libXext libXtst libX11 libXau libxcb libXi make sysstat

List all the i686 packages installed

rpm -qa --queryformat '%{NAME} %{ARCH}\n' | grep 'i[6543]86' | cut -d' ' -f1

List of the i686 packages required

compat-libstdc++-33
glibc
glibc-devel
libgcc
libstdc++
libstdc++-devel
libaio
libaio-devel
libXext
libXtst
libX11
libXau
libxcb
libXi

Use command below to install required i686 packages

rpm -ivh glibc-devel-2.12-1.80.el6.i686.rpm libstdc++-4.4.6-4.el6.i686.rpm libstdc++-devel-4.4.6-4.el6.i686.rpm libaio-0.3.107-10.el6.i686.rpm libaio-devel-0.3.107-10.el6.i686.rpm libXext-1.1-3.el6.i686.rpm libXtst-1.0.99.2-3.el6.i686.rpm libX11-1.3-2.el6.i686.rpm libXau-1.0.5-1.el6.i686.rpm libxcb-1.5-1.el6.i686.rpm libXi-1.3-3.el6.i686.rpm

Kernel parameters required.

kernel.sem = 250 32000 100 128

kernel.shmall = 3355443

kernel.shmmax = 3986726912

kernel.shmmni = 4096
kernel.panic_on_oops = 1
fs.file-max = 6815744
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 11000 65000
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

Execute command below to get new kernel setting in effect.

sysctl -p

Change Linux kernel setting on runtime

echo 11000 65500 > /proc/sys/net/ipv4/ip_local_port_range

Creating required Operating System Group and Users

Create Oracle Inverntory group

/usr/sbin/groupadd -g 1000 oinstall

Create Oracle dba group

/usr/sbin/groupadd -g 1001 dba

Create Oracle operator group

/usr/sbin/groupadd -g 1002 oper

Create Oracle software owner user

useradd -u 1000 -g oinstall -G oinstall,dba,oper oracle

passwd oracle

Checking Resource limits for Oracle software Installation user.

cat >> /etc/security/limits.conf

oracle soft nofile 1024

oracle hard nofile 65536

oracle soft nproc 2047

oracle hard nproc 16384

oracle soft stack 10240

oracle hard stack 32768

Set secure linux to permissive by editing /etc/selinux/config

SELINUX=permissive

Once modification is completed execute following command to set secure linux to Permissive

setenforce Permissive

Disable iptables firewall

/etc/init.d/iptables stop

chkconfig iptables off 345

Create Oracle Home directory

mkdir -p /u01/app/oracle/product/12.2.0.1/db_1

chown -R oracle:oinstall /u01/app

Configure oracle environment. Add following lines on .bash_profile file on /home/oracle

export ORACLE_HOSTNAME=core.localdomain

export ORACLE_UNQNAME=omrdb

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/db_1

export ORACLE_SID=oemrep

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

Login as user oracle and download Oracle Database 12c Release 2 from URL below:

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

Extract the downloaded source

Change directory to oracle staging and execute runInstaller

Below is the landing page after you execute runInstaller.

Uncheck I wish to receive security updates via My Oracle Support and Click on Next to continue

Warning window will be displayed. Click on Yes to continue.

Click on Next to continue.

I am planning to install database later manually. So selecting Install database software only option.

Select Single Instance database installation and click on Next to continue.

Select database edition option and click on Next to continue.

Select oracle base and Software location. Click on Next to continue.

Select Inventory Directory and oraInventory group Name. Click on Next to continue.

Select OS groups for OSDBA, OSOPER, OSBACKUPDBA, OSDGDBA, OSKMDBA. Click on Next to continue.

If any requirement is failed while Prerequisite Check, fix the issue before moving a head. In my case there was a Swap Size issue. I can safely ignore it and move ahead.