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.