Oracle Database - 19c: On Premise Installation - Oracle Linux (7.5) - Part 1

In this blog I discuss installation of Oracle 19c on premise. 

The part 1 covers the pre-requisites installation and part 2 covers the installation. 

Pre-requistites

The easy and fast way of covering the preq-reqs on Oracle Linux is to use Oracle validated rpm for 19c Linux. 

On a fresh installation of Oracle Linux (Linux oraclebox19c.novalocal 4.1.12-112.16.4.el7uek.x86_64 )
This is version 7.5 Oracle Linux


[root@orclbox19c ~]# yum install oracle-database-preinstall-19c.x86_64 -y

You can find the changes it did from /var/log/oracle-database-preinstall-19c/results
and backup of files from /var/log/oracle-database-preinstall-19c/backup

Swap Creation for both Manual and automated pre-req completion - http://o-dba.blogspot.com/2018/05/oracle-database-12c19c-swap-swapon.html


Manual Pre-reqs Install


1. Install required RPMs as per your Operating System and Kernel version & support. https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/database-installation-guide-linux.pdf

2. User Creation

• groupadd -g 54321 oinstall
• groupadd -g 54322 dba
• useradd -g 54321 -G dba -u 54321 oracle

3. Create file - /etc/sysctl.d/99-oracle-database-preinstall-19c-sysctl.conf

• For shmmax - 90% of memory in KB
• For shmmall - shmmax/4096
• For vm.nr_hugepages = 80% of memory in MB / 2
• fs.file-max = 6815744
• kernel.sem = 250 32000 100 128
• kernel.shmmni = 4096
• kernel.shmall = 1073741824
• kernel.shmmax = 4398046511104
• kernel.panic_on_oops = 1
• net.core.rmem_default = 262144
• net.core.rmem_max = 4194304
• net.core.wmem_default = 262144
• net.core.wmem_max = 1048576
• net.ipv4.conf.all.rp_filter = 2
• net.ipv4.conf.default.rp_filter = 2
• fs.aio-max-nr = 1048576
• net.ipv4.ip_local_port_range = 9000 65500
• vm.nr_hugepages = 13100

4. Create file - /etc/security/limits.d/oracle-database-preinstall-19c.conf

• oracle   soft   nofile    1024
• oracle   hard   nofile    65536
• oracle   soft   nproc    16384
• oracle   hard   nproc    16384
• oracle   soft   stack    10240
• oracle   hard   stack    32768
• ## oracle-database-preinstall-19c setting for memlock soft/hard limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90% of RAM
• oracle   hard   memlock    134217728
• oracle   soft   memlock    134217728
• Disable Transparent Huge Pages

5. Add NOZEROCONF parameter in network configuration in file /etc/sysconfig/network
6. Disabling Transparent Hugepages - Refer Oracle Note:1557478.1
7. Disabling defrag - Refer Oracle Note:1557478.1