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

Oracle 11g DB Installation on Ubuntu 14.04 Trusty | 1/6 Initial Configuration

1. Download the Oracle 11g R2 Database for Linux:
   Oracle 11g R2 .zip for Linux
   The Link Contains the List of Oracle 11g r2 Database Releases.

2. Open a Shell Session or Terminal Emulator Window
   Ctrl+Alt+t on desktop
   (Press “Enter” to Execute Commands)

   
3. Login as Super-User

   sudo su

   If Got “User is Not in Sudoers file” then Look: Solution

4. Make Network Configuration
   • Get hostname:

     hostname

   • Get IP:

     /sbin/ifconfig

     You will Find It Under the lo >> inet Section.

   • Check if Hostname is Already into the Enabled Hosts File.

     cat /etc/hosts

     If It’s Not Present then Insert it with:

     nano /etc/hosts

     Insert:

     [myIP] [myHostname]

     Example: ‘127.0.0.1 localhost.localdomain’

     Ctrl+Shift+v to Paste Content into nano
     Ctrl+x to Save and Exit from nano Editor :)

   • Grant Connection to X Server
     

     xhost +myIP

     Example: # xhost +127.0.0.1

5. Parameters Configuration SetUp
   
   • 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 ####
     oracle       soft  nproc  2047
     oracle       hard  nproc  16384
     oracle       soft  nofile 1024
     oracle       hard  nofile 65536
     oracle       soft  stack  10240
     

   • Load the New Kernel Parameters.

     /sbin/sysctl -p

Follow with Ubuntu 14.04 Oracle 11g DB Installation | 2/6 Installing Packages >>

Tags: Database, Getting Started, Guide, How-to, Install, install oracle database ubuntu, install oracle database ubuntu 14.04, Linux, Linux Tutorial, Linux Ubuntu 14.04 Trusty, Oracle, Oracle 11g, oracle 11g database ubuntu, oracle 11g db quickstart, oracle 11g db quickstart ubuntu, oracle 11g db ubuntu, Oracle 11g R2 Database, Oracle Database, quickstart, Tutorial, Ubuntu, ubuntu 14.04 Trusty Tahr LTS, Visual-Guide