Install prerequisites for Oracle database 12R2 on Oracle Linux 7

How to install the recommanded specifications/prerequistes system packages, kernel parameters and system security limits, for Oracle database 12c Release 2 on Oracle Linux 7.

Tables of contents:

  1. System versions
  2. Install the prerequist
  3. Vérificatiosn of the prerequistes.
  4. Hostname resolution.

 

1. System versions:

a. To check the Oracle Linux version:

# cat /etc/oracle-release
Oracle Linux Server release 7.4

b. The kernel version

# uname -a
Linux ol-7u4.wadhahdaouehi.tn 4.1.12-94.3.9.el7uek.x86_64 #2 SMP Fri Jul 14 20:09:40 PDT 2017 x86_64 x86_64 x86_64 GNU/Linux

 

2. Install the Oracle database prerequistes on Oracle Linux:

For any Oracle RDBMS version, check what recommanded prerequist from the source software or from the Oracle web site.

  1. What packages ?
  2. What kernel parameters ?
  3. What security limits.
  4. What groups should have the Oracle database software owner.

Note: With Oracle Linux, we can install all the prerequistes with One step, just to install the package oracle-rdbms-server-11gR2-preinstall.x86_64.

Step 0: Search for the package

# yum search oracle
==================================================== N/S matched: oracle =====================================================
kmod-oracleasm.x86_64 : oracleasm kernel module(s)
oracle-database-server-12cR2-preinstall.x86_64 : Sets the system for Oracle Database single instance and Real Application: Cluster install for Oracle Linux 7
oracle-logos.noarch : Oracle-related icons and pictures
oracle-rdbms-server-11gR2-preinstall.x86_64 : Sets the system for Oracle single instance and Real Application Cluster install: for Oracle Linux 7
oracle-rdbms-server-12cR1-preinstall.x86_64 : Sets the system for Oracle Database single instance and Real Application Cluster: install for Oracle Linux 7
oracleasm-support.x86_64 : The Oracle Automatic Storage Management support programs.
oraclelinux-release.x86_64 : Oracle Linux 7 release file
tuned-profiles-oracle.noarch : Additional tuned profile(s) targeted to Oracle loads
basesystem.noarch : The skeleton package which defines a simple Oracle Linux system
kabi-yum-plugins.noarch : The Oracle Linux kernel ABI yum plugin
ocfs2-tools.x86_64 : Tools for managing the Oracle Cluster Filesystem 2
redhat-bookmarks.noarch : Oracle Linux bookmarks
redhat-indexhtml.noarch : Browser default start page for Oracle Linux
redhat-upgrade-tool.noarch : The Oracle Linux Upgrade tool
  Name and summary matches only, use "search all" for everything.

Step 1: Install the package

# yum -y install oracle-database-server-12cR2-preinstall.x86_64

 

Step 2: Check the package information details:

# yum info oracle-database-server-12cR2-preinstall.x86_64
Loaded plugins: langpacks, ulninfo
Available Packages
Name        : oracle-database-server-12cR2-preinstall
Arch        : x86_64
Version     : 1.0
Release     : 3.el7
Size        : 19 k
Repo        : ol7_latest/x86_64
Summary     : Sets the system for Oracle Database single instance and Real Application Cluster install for Oracle Linux 7
License     : GPLv2
Description : The Oracle Preinstallation RPM package installs software packages and sets system parameters required for Oracle Database single instance and
            : Oracle Real Application Clusters installations for Oracle Linux Release 7 Files affected: /etc/sysctl.conf, /boot/grub/menu.lst OR
            : /boot/grub2/grub.cfg Files added: /etc/security/limits.d/oracle-database-server-12cR2-preinstall.conf

3. Vérificatiosn of the prerequistes:

We are going to check the prerequistes:

a. Check the kernel parameters

# cat /etc/sysctl.conf
....
# For more information, see sysctl.conf(5) and sysctl.d(5).
# oracle-database-server-12cR2-preinstall setting for fs.file-max is 6815744
fs.file-max = 6815744
# oracle-database-server-12cR2-preinstall setting for kernel.sem is '250 32000 100 128'
kernel.sem = 250 32000 100 128
# oracle-database-server-12cR2-preinstall setting for kernel.shmmni is 4096
kernel.shmmni = 4096
# oracle-database-server-12cR2-preinstall setting for kernel.shmall is 1073741824 on x86_64
kernel.shmall = 1073741824
# oracle-database-server-12cR2-preinstall setting for kernel.shmmax is 4398046511104 on x86_64
kernel.shmmax = 4398046511104
# oracle-database-server-12cR2-preinstall setting for kernel.panic_on_oops is 1 per Orabug 19212317
kernel.panic_on_oops = 1
# oracle-database-server-12cR2-preinstall setting for net.core.rmem_default is 262144
net.core.rmem_default = 262144
# oracle-database-server-12cR2-preinstall setting for net.core.rmem_max is 4194304
net.core.rmem_max = 4194304
# oracle-database-server-12cR2-preinstall setting for net.core.wmem_default is 262144
net.core.wmem_default = 262144
# oracle-database-server-12cR2-preinstall setting for net.core.wmem_max is 1048576
net.core.wmem_max = 1048576
# oracle-database-server-12cR2-preinstall setting for net.ipv4.conf.all.rp_filter is 2
net.ipv4.conf.all.rp_filter = 2
# oracle-database-server-12cR2-preinstall setting for net.ipv4.conf.default.rp_filter is 2
net.ipv4.conf.default.rp_filter = 2
# oracle-database-server-12cR2-preinstall setting for fs.aio-max-nr is 1048576
fs.aio-max-nr = 1048576
# oracle-database-server-12cR2-preinstall setting for net.ipv4.ip_local_port_range is 9000 65500
net.ipv4.ip_local_port_range = 9000 65500

b. Check the security Limits:

# cat /etc/security/limits.d/oracle-database-server-12cR2-preinstall.conf
...
# oracle-database-server-12cR2-preinstall setting for nofile soft limit is 1024
oracle   soft   nofile    1024
# oracle-database-server-12cR2-preinstall setting for nofile hard limit is 65536
oracle   hard   nofile    65536
# oracle-database-server-12cR2-preinstall setting for nproc soft limit is 16384
# refer orabug15971421 for more info.
oracle   soft   nproc    16384
# oracle-database-server-12cR2-preinstall setting for nproc hard limit is 16384
oracle   hard   nproc    16384
# oracle-database-server-12cR2-preinstall setting for stack soft limit is 10240KB
oracle   soft   stack    10240
# oracle-database-server-12cR2-preinstall setting for stack hard limit is 32768KB
oracle   hard   stack    32768
# oracle-database-server-12cR2-preinstall setting for memlock hard limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90 % of RAM
oracle   hard   memlock    134217728
# oracle-database-server-12cR2-preinstall setting for memlock soft limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90% of RAM
oracle   soft   memlock    134217728

c. Check the Groups:

# cat /etc/group
...
oracle:x:1000:
oinstall:x:54321:
dba:x:54322:
oper:x:54323:
backupdba:x:54324:
dgdba:x:54325:
kmdba:x:54326:
racdba:x:54330:

d. Check the user RDBMS owner:

In my case, the system Linux user oracle will be the Owner of the Oracle software:

d.1. Check user groups:

# id oracle
uid=1000(oracle) gid=1000(oracle) groups=1000(oracle),10(wheel)

d.2. Add user groups:

# usermod -g oinstall -G dba,oper,backupdba,dgdba,kmdba,racdba oracle

d.3. Check user groups:

# id oracle
uid=1000(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)

 

4. Hostname resolution:

Step 1: Check the hostname

# hostname
ol-7u4.wadhahdaouehi.tn

Step 2: Add hostname to the hosts file

# cat /etc/hosts
127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
::1         localhost localhost.localdomain localhost6 localhost6.localdomain6
127.0.0.1       ol-7u4.wadhahdaouehi.tn         ol-7u4

Conclusion:

After Installing the system Linux prerequistis for the Oracle database, it is time to enjoy installing Oracle database.

 

 

Bookmark the permalink.
Loading Facebook Comments ...

One Response to Install prerequisites for Oracle database 12R2 on Oracle Linux 7

  1. Pingback: Install Step by Step Oracle database 12R2 on Oracle Linux 7 – Wadhah DAOUEHI

Leave a Reply