Oracle Database - 18c: On Premise Installation - Oracle Linux - Part 1

In this blog I discuss installation of Oracle 18c 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 18c Linux. 

On a fresh installation of Oracle Linux (Linux orclbox18c.novalocal 4.1.12-112.14.15.el7uek.x86_64 GNU/Linux)


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

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

Swap Creation for both Manual and automated pre-req completion - http://o-dba.blogspot.com/2018/05/oracle-database-12c18c-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/18/ladbi/database-installation-guide-linux.pdf
2.  User Creation
1. groupadd -g 54321 oinstall
2. groupadd -g 54322 dba
3. useradd -g 54321 -G dba -u 54321 oracle
3. Create file - /etc/sysctl.d/99-oracle-database-preinstall-18c-sysctl.conf
2. For shmmax - 90% of memory in KB
3. For shmmall - shmmax/4096
4. For vm.nr_hugepages = 80% of memory in MB / 2
5. 
   
6. fs.file-max = 6815744
7. kernel.sem = 250 32000 100 128
8. kernel.shmmni = 4096
9. kernel.shmall = 1073741824
10. kernel.shmmax = 4398046511104
11. kernel.panic_on_oops = 1
12. net.core.rmem_default = 262144
13. net.core.rmem_max = 4194304
14. net.core.wmem_default = 262144
15. net.core.wmem_max = 1048576
16. net.ipv4.conf.all.rp_filter = 2
17. net.ipv4.conf.default.rp_filter = 2
18. fs.aio-max-nr = 1048576
19. net.ipv4.ip_local_port_range = 9000 65500
20. vm.nr_hugepages = 13100
5. Create file - /etc/security/limits.d/oracle-database-preinstall-18c.conf
2. oracle   soft   nofile    1024
3. oracle   hard   nofile    65536
4. oracle   soft   nproc    16384
5. oracle   hard   nproc    16384
6. oracle   soft   stack    10240
7. oracle   hard   stack    32768
8. ## oracle-database-preinstall-18c setting for memlock soft/hard limit is maximum of 128GB on x86_64 or 3GB on x86 OR 90% of RAM
9. oracle   hard   memlock    134217728
10. oracle   soft   memlock    134217728
6. Disable Transparent Huge Pages
7. Add NOZEROCONF parameter in network configuration in file /etc/sysconfig/network
8. Disabling Transparent Hugepages - Refer Oracle Note:1557478.1
9. Disabling defrag - Refer Oracle Note:1557478.1