Wednesday, March 8, 2017

Install Oracle 12c Release 2 on CentOS 6

9:50 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-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.

/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

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






























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.


Warning message will be displayed for any prerequisites failure and ignore.


Once you check Ignore All check box. Click on Next. 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.


0 comments:

Post a Comment