Thursday, June 13, 2013

How-to Install and Getting-Started on Oracle 11g R2 Database for Linux Ubuntu 12.10 Quantal Quetzal 64bit Easy Visual-Guide

This is an Easy and Step-by-Step Guide to Install the Oracle 11g R2 x86_64 Database on Linux Ubuntu 12.10 Quantal Quetzal Amd64 Unity Desktop.

Ubuntu-like Systems are Not in the List of Oracle 11g Database Supported OS So you should Be Carefull and Use It At Most for Development and Not As Production Database Server!

The Guide Include All the Essentials Commands and Basic Screenshots of the Installation Process.

The Process is somewhat Extended and Advanced so it Demand some Basic Command Line Confidence.

Now Relax and Take the Time of Reading, Understanding and Executing Carefully the Instructions Contained here.

Metallic Oracle
  1. Download the Oracle 11g R2 Database:

    The Link Contains the List of Oracle 11g r2 Database Releases.
  2. Open Terminal Window
    Linux Ubuntu 12 Open Terminal
  3. Login as Root User
    sudo su
  4. Make Network Configuration
    • Get hostname:
    • Get IP:

      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: <IP HOSTNAME>

      Example: ' localhost.localdomain'

      Ctrl+x to Save and Exit from nano Editor :)

    • Grant Connection to X Server
      xhost +<hostIP>
      Example: # xhost +
  5. Install Prerequisite Packages
    apt-get install alien autoconf automake autotools-dev binutils doxygen \
    elfutils expat gawk gcc gcc-multilib g++-multilib ia32-libs ksh less lesstif2 \
    lesstif2-dev lib32z1 libaio1 libaio-dev libc6-dev libc6-dev-i386 libc6-i386 \
    libelf-dev libltdl-dev libmotif4 libodbcinstq4-1 libodbcinstq4-1:i386 libpth-dev \
    libpthread-stubs0 libpthread-stubs0-dev libstdc++5 lsb-cxx make openssh-server \
    pdksh rlwrap rpm sysstat unixodbc unixodbc-dev x11-utils zlibc
  6. Make Symlinks to Binaries and Libraries

    Linking Binaries

    ln -s /usr/bin/awk /bin/awk
    ln -s /usr/bin/rpm /bin/rpm
    ln -s /usr/bin/basename /bin/basename

    Linking Libraries

    ln -s /usr/lib/x86_64-linux-gnu /usr/lib64
    cd /lib64
    sudo ln -s /lib/x86_64-linux-gnu/ . 
  7. Add Groups and User
    groupadd -g 502 oinstall
    groupadd -g 503 dba
    groupadd -g 504 oper
    groupadd -g 505 asmadmin
    useradd -u 502 -g oinstall -G dba,asmadmin,oper -s /bin/bash -m oracle
    passwd oracle
  8. Make Target Directories
    mkdir -p /u01/app/oracle/product/11.2.0/dbhome_1
    chown -R oracle:oinstall /u01
    chmod -R 775 /u01
  9. Parameters Configuration SetUp
    • Edit /etc/sysctl.conf file.
      nano /etc/sysctl.conf
      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 = 2097152
      kernel.shmmax = 536870912
      kernel.shmmni = 4096
      # semaphores: semmsl, semmns, semopm, semmni
      kernel.sem = 250 32000 100 128
      net.ipv4.ip_local_port_range = 9000 65500
      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
  10. Unzip, Set oracle as Owner and Relocate database
    cd </path/To/linux_11gR2*.zip>
    chown -R oracle:oinstall database
    mv database /tmp
  11. Add Paths to oracle's .bashrc Login as Oracle
    su oracle
    Edit .bashrc file
    nano /home/oracle/.bashrc
    # Oracle Settings
    TMP=/tmp; export TMP
    TMPDIR=$TMP; export TMPDIR
    ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
    ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME
    PATH=/usr/sbin:$PATH; export PATH
    PATH=$ORACLE_HOME/bin:$PATH; export PATH
    LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/lib64; export LD_LIBRARY_PATH
    Substitute HOSTNAME and DBSID with the Values you Will Use During Software Installation In this Example Respectively:
    • HOSTNAME =
    • DBSID = SID

    Load New .bashrc Settings

    source ~/.bashrc
  12. Install the Oracle 11g Software
    cd /tmp/database

    If you Get: "Check if the DISPLAY variable is set. Failed". Look Link Below.

    Link2+ Oracle 11g Database Troubleshooting

    Linux Start Oracle 11g R2 Installation

    On the first screen Just Leave eMail Blank and Un-Check the Demand of Security Update Support then Click on Next Linux Oracle 11g R2 Installation Step 1 - Disabling Security Updates

    Then Confirm on Warning and Follow. Linux Oracle 11g R2 Installation - Confirm on Missing eMail Warning

    On "Select Installation Option" Select "Install database software only" and Click on Next Linux Oracle 11g R2 Installation Step 2

    On Step 3 Leave Default "Single instance database installation" and Click on Next Linux Oracle 11g R2 Installation Step 3

    On Step 4 Select your Language and Click on Next Linux Oracle 11g R2 Installation Step 4

    On Step 5 Leave Default Enterprise Edition and Click on Next Linux Oracle 11g R2 Installation Step 5

    On "Installation Location" Set All As Here Below and Click on Next

    • Oracle Base: /u01/app/oracle
    • Software Location: /u01/app/oracle/product/11.2.0/dbhome_1

    These are the Same Settings Inserted into the .bash_profile File...

    Linux Oracle 11g R2 Installation Step 6

    On "Create Inventory" if you Setup the Path on .bash_profile Like Here Leave Default and Click on Next Linux Oracle 11g R2 Installation Step 7

    On "Operating System Groups" if you Setup the Path on .bash_profile Like Here Leave Default and Click on Next Linux Oracle 11g R2 Installation Step 8

    On "Prerequisite Checks" you will Get Easily a "Warning Message" about some Missing Requirements

    Just Check: "Ignore All" and Follow Up with Installation...

    Check Ignore All and Follow...

    Linux Oracle 11g R2 Installation Ubuntu-like Ignore All

    On the "Summary" Click on "Save Response File" to Take Note of Settings and then Click on Finish Linux Oracle 11g R2 Installation Step 10

    The Installation Product Procedure should Start...

  13. Solving Errors in Building and Linking Libraries
    Oracle 11g Ubuntu-like Installation Error in Invoking Target Agent nmhs of makefile
  14. Execute Scripts

    Right Before the End of Process a Pop-Up Window will Show the Path to Two Configuration Scripts you Need to Execute on Terminal!

    Linux Oracle 11g R2 Installation Step 11

    Next Oracle Should Confirm you of the Successful Installation Achivement.) Linux Oracle 11g R2 Installation Step 12

  15. Create and Run a Listener for Oracle 11g
  16. Linux Penguin Oracle 11g
  17. How-to Create a Database for Oracle 11g

    Guide with Detailed Instruction 2 Create a Database for Oracle 11g.

After you Should Access the "Enterprise Manager" on Browser by the URL shown on the Last Screen. On a Localhost for Example you Should Access the Enterprise Manager by the Address:
And you can Login with: User Name: SYS Password: oracleDatabasePassword From the Drop-down below Select >> Connect as SYSDBA You Should be Able to Access the Database by the Enterprise Manager!
How Managing, Start & Stop Oracle 11g R2 Database by SQLPlus Commands
SQLPlus Oracle 11g DB Quick-Start

Oracle 11g Database Troubleshooting Guides

Enjoy this "Step by Step" Clear Installation and Getting Started... Goodk Luck! :)