How to Install Oracle 11g R2 Database on Ubuntu 16.04 Xenial LTS 64-bit Easy Guide

Setting Up Parameters

5. 5. Setting Up Parameters

   Parameters Configuration SetUp
   
   So Execute:

   • Edit /etc/sysctl.conf file.

     nano /etc/sysctl.conf

     Then hit Ctrl+x to Save and Exit from nano Editor
     Add or amend the following lines
     

     #### Oracle 11g Kernel Parameters ####
     fs.suid_dumpable = 1
     fs.aio-max-nr = 1048576
     fs.file-max = 6815744
     kernel.shmall = 818227
     kernel.shmmax = 4189323264
     kernel.shmmni = 4096
     kernel.panic_on_oops = 1
     # semaphores: semmsl, semmns, semopm, semmni
     kernel.sem = 250 32000 100 128
     net.ipv4.ip_local_port_range = 9000 65500
     net.core.rmem_default=262144
     net.core.rmem_max=4194304
     net.core.wmem_default=262144
     net.core.wmem_max=1048576
     

     The Values of ‘shmall’ and ‘shmmax’ Need to be Customized following your System Memory Size.
     Here above is a Valid Setup for a 8Gb RAM Size!
     If you need to Change first Check your Phisical Memory Size with:

     cat /proc/meminfo | grep MemTotal

     Then ‘shmall’ should be Set as:

     [RamKb] / 10

     And instead ‘shmmax’ as:

     [RamKb] * 1024 / 2

     For further Instructions See Oracle Documentation…
     
     If Exists then Comment out these lines below that Gives an Error

     #net.bridge.bridge-nf-call-ip6tables = 0
     #net.bridge.bridge-nf-call-iptables = 0
     #net.bridge.bridge-nf-call-arptables = 0
     

   • Edit /etc/security/limits.conf file.

     nano /etc/security/limits.conf

     Add the following lines
     

     #### oracle User Settings 4 Oracle 11g ####/noracle       soft  nproc  2047/noracle       hard  nproc  16384/noracle       soft  nofile 1024/noracle       hard  nofile 65536/noracle       soft  stack  10240
     

   • Load the New Kernel Parameters

     /sbin/sysctl -p