Saturday, July 9, 2016

Install Oracle Database 12c on Linux

9:20 PM Posted by Dilli Raj Maharjan No comments

Hardware Requirments

Disk Space Requirements on Linux x86-64


Database EditionDisk Space
Enterprise Edition6.4 GB
Standard Edition6.1 GB
Standard Edition One6.1 GB
Standard Edition 26.1 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
  • Oracle Linux 5 Update 6, Red Hat Enterprise Linux 5 Distributions Update 6 with Kernel 2.6.18-238.0.0.0.1.el5 or later
  • SUSE Distributions for x86-64
  • SUSE Linux Enterprise Server 11 SP2: 3.0.13-0.27 or later
  • SUSE Linux Enterprise Server 12 SP1: 3.12.49-11 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


Package for RHEL 5

  • binutils-2.17.50.0.6
  • compat-libstdc++-33-3.2.3
  • compat-libstdc++-33-3.2.3 (32 bit)
  • coreutils-5.97-23.el5_4.1
  • gcc-4.1.2
  • gcc-c++-4.1.2
  • glibc-2.5-58
  • glibc-2.5-58 (32 bit)
  • glibc-devel-2.5-58
  • glibc-devel-2.5-58 (32 bit)
  • ksh
  • libaio-0.3.106
  • libaio-0.3.106 (32 bit)
  • libaio-devel-0.3.106
  • libaio-devel-0.3.106 (32 bit)
  • libgcc-4.1.2
  • libgcc-4.1.2 (32 bit)
  • libstdc++-4.1.2
  • libstdc++-4.1.2 (32 bit)
  • libstdc++-devel 4.1.2
  • libXext-1.0.1
  • libXext-1.0.1 (32 bit)
  • libXtst-1.0.1
  • libXtst-1.0.1 (32 bit)
  • libX11-1.0.3
  • libX11-1.0.3 (32 bit)
  • libXau-1.0.1
  • libXau-1.0.1 (32 bit)
  • libXi-1.0.1
  • libXi-1.0.1 (32 bit)
  • make-3.81
  • sysstat-7.0.2


Package for SUSE 11

  • binutils-2.21.1-0.7.25
  • gcc-4.3-62.198
  • gcc-c++-4.3-62.198
  • glibc-2.11.3-17.31.1
  • glibc-devel-2.11.3-17.31.1
  • ksh-93u-0.6.1
  • libaio-0.3.109-0.1.46
  • libaio-devel-0.3.109-0.1.46
  • libcap1-1.10-6.10
  • libstdc++33-3.3.3-11.9
  • libstdc++33-32bit-3.3.3-11.9
  • libstdc++43-devel-4.3.4_20091019-0.22.17
  • libstdc++46-4.6.1_20110701-0.13.9
  • libgcc46-4.6.1_20110701-0.13.9
  • make-3.81
  • sysstat-8.1.5-7.32.1
  • xorg-x11-libs-32bit-7.4
  • xorg-x11-libs-7.4
  • xorg-x11-libX11-32bit-7.4
  • xorg-x11-libX11-7.4
  • xorg-x11-libXau-32bit-7.4
  • xorg-x11-libXau-7.4
  • xorg-x11-libxcb-32bit-7.4
  • xorg-x11-libxcb-7.4
  • xorg-x11-libXext-32bit-7.4
  • xorg-x11-libXext-7.4


Package for SUSE12

  • binutils-2.25.0-13.1
  • gcc-4.8-6.189
  • gcc48-4.8.5-24.1
  • glibc-2.19-31.9
  • glibc-32bit-2.19-31.9
  • glibc-devel-2.19-31.9.x86_64
  • glibc-devel-32bit-2.19-31.9.x86_64
  • mksh-50-2.13
  • libaio1-0.3.109-17.15
  • libaio-devel-0.3.109-17.15
  • libcap1-1.10-59.61
  • libstdc++48-devel-4.8.5-24.1.x86_64
  • libstdc++48-devel-32bit-4.8.5-24.1.x86_64
  • libstdc++6-5.2.1+r226025-4.1.x86_64
  • libstdc++6-32bit-5.2.1+r226025-4.1.x86_64
  • libstdc++-devel-4.8-6.189.x86_64
  • libstdc++-devel-32bit-4.8-6.189.x86_64
  • libgcc_s1-5.2.1+r226025-4.1.x86_64
  • libgcc_s1-32bit-5.2.1+r226025-4.1.x86_64
  • make-4.0-4.1.x86_64
  • sysstat-10.2.1-3.1.x86_64
  • xorg-x11-driver-video-7.6_1-14.30.x86_64
  • xorg-x11-server-7.6_1.15.2-36.21.x86_64
  • xorg-x11-essentials-7.6_1-14.17.noarch
  • xorg-x11-Xvnc-1.4.3-7.2.x86_64
  • xorg-x11-fonts-core-7.6-29.45.noarch
  • xorg-x11-7.6_1-14.17.noarch
  • xorg-x11-server-extra-7.6_1.15.2-36.21.x86_64
  • xorg-x11-libs-7.6-45.14.noarch
  • xorg-x11-fonts-7.6-29.45.noarch


Configure host file

/etc/hosts


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.1.0.2/db_1
chown -R oracle:oinstall /u01/app

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

export ORACLE_HOSTNAME=oem13c.localdomain
export ORACLE_UNQNAME=oemrep
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0.2/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
Change directory to oracle staging
Execute runInstaller






























After executing runInstaller executable above window will be displayed.































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. Installing database later enables selecting template for OEM database. So selecting Install database software only option.































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































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































Click on Save Response File to save the summary.
























Selection the location and file name click on save to save response file.































Click on Install to begin installation.































Installation on progress ####################































Installation on progress ########################################























































Execute above scripts as user root and click on OK.


























Click on OK to continue.































Finally Click on Close to finish the installation.
                                   
Oracle 12c network Configuration

0 comments:

Post a Comment