Sunday, March 12, 2017

Install Oracle Database 12c R2

7:03 PM Posted by Dilli Raj Maharjan , No comments

Hardware Requirments

Disk Space Requirements on Linux x86-64

Database EditionDisk Space
Enterprise Edition7.5 GB
Standard Edition 27.5 GB

Memory Requirement

RAMSwap Space
Between 1 GB and 2 GB1.5 times the size of the RAM
Between 2 GB and 16 GBEqual to the size of the RAM
More than 16 GB16 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-
  • 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- (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- (x86_64)
  • libXtst- (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- 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

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/
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/

export ORACLE_SID=oemrep
export PATH=/usr/sbin:$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:

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.

Click On Next once you check Ignore all option.

Warning message will be displayed for any prerequisites failure and ignore.
On Summary page Click on Install to begin installation.

Installation is on progress. ##########

Execute Configuration Scripts window will be poped up. Make Sure all the script listed above is executed as user root before Pressing OK Button.

Once the script is executed successfully. Click on OK on the Execute Configuration Scripts window.

Once the installation is completed Click on Close to complete Installation.


Post a Comment