Install Oracle 12c Database on Lubuntu 14.04 Trusty LTS 64bit Linux Easy Guide

October 3rd, 2014 by thelinuxevangelist

Getting-Started with Oracle 12c DB for Lubuntu 14.04 Trusty LTS Amd64



The Linux Tutorial Shows You Step-by-Step How to Install the Oracle 12c R1 Amd64 Database on Lubuntu Linux 14.04 Trusty Tahr LTS 64bit Unity Desktop.

Ubuntu-like Systems are Not in the List of Oracle 12c Database Supported OS So you should Be Careful 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.

The Only Hard Requirements to Take Into Account Before Installation are to Dispose At Least Of:

  • 1 Gb of RAM
  • 6 Gb of Drive Space

The Tutorial Include All the Essentials Screenshots Helping in Visualizing the Oracle 12c Database Installation Linux.

Install Oracle 12c Database Lubuntu 14.04 Trusty LTS Linux - Featured

With more than 500 new features, Oracle Database 12c is designed to give Oracle customers exactly what they need for Cloud Computing, Big Data, Security, and Availability.

The Best Oracle 12c Database New Features:

  1. Open Terminal Window
    Ctr+Alt+T
    (Press “Enter” to Execute Commands)

    Install Oracle 12c Database for Lubuntu 14.04 Trusty LTS 64bit - Open Terminal
  2. Add Needed Oracle DB Groups and User

    sudo su

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

    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

    Take Note of the oracle User Pass :)

  3. Install the Required Packages

    apt-get install alien autoconf automake autotools-dev binutils doxygen \
    elfutils expat gawk gcc gcc-multilib g++-multilib libstdc++6:i386 ksh less libtiff4 \
    libtiff4-dev lib32z1 libaio1 libaio-dev libc6-dev libc6-dev-i386 libc6-i386 \
    libelf-dev libltdl-dev libmotif4 libodbcinstq4-1 libodbcinstq4-1:i386 \
    libpthread-stubs0 libpth-dev libstdc++5 lsb-cxx make \
    pdksh openssh-server rlwrap rpm sysstat unixodbc unixodbc-dev x11-utils \
    zlibc libglapi-mesa:i386 libglu1-mesa:i386 libqt4-opengl:i386 \
    libpthread-workqueue0 libpthread-workqueue-dev libzthread-2.3-2 libzthread-dev \
    libpthread-stubs0-dev

    How-to Install libtiff4, libtiff4-dev and libpthread-stubs0: Here.

  4. Double-Click or Right-Click on Archive and Extract into /tmp
    Linux Oracle 12c Database Extraction
    Or From Command Line:

    unzip -d /tmp linuxamd64_12c_database*.zip
  5. Set DB Directory Permissions

    chown -R oracle:oinstall /tmp/database
  6. 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:

      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

  7. 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
    ln -s /lib/x86_64-linux-gnu/libgcc_s.so.1 .
  8. Make Target Directories
    mkdir -p /u01/app/oracle/product/12/dbhome_1
    chown -R oracle:oinstall /u01
    chmod -R 775 /u01
  9. 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 = 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
      net.core.rmem_default=4194304
      net.core.rmem_max=4194304
      net.core.wmem_default=262144
      net.core.wmem_max=1048586
      

      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
  10. Add Paths to oracle’s .bashrc

    Login as Oracle

    su oracle

    Edit .bashrc file

    nano ~/.bashrc

    Insert:


    # Oracle Settings
    TMP=/tmp; export TMP
    TMPDIR=$TMP; export TMPDIR
    ORACLE_HOSTNAME=[HOSTNAME]; export ORACLE_HOSTNAME
    ORACLE_UNQNAME=DB11G; export ORACLE_UNQNAME
    ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
    ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME
    ORACLE_SID=[DBSID]; export ORACLE_SID
    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
    CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
    

    Replace [HOSTNAME] with IP and [DBSID] with SID Name

    In this Example Respectively:

    • HOSTNAME = 127.0.0.1
    • DBSID = SID

    Load New .bashrc Settings

    source ~/.bashrc
  11. Run the Installation Script

    chmod -R +x /tmp/database
    /tmp/database/runInstaller

    If Got Display Not Set or For Any Issue Encountered Look:

    Oracle 12c DB Troubleshooting
  12. Then Follow the Installation WorkFlow
    If you Do Not Dispose of an Oracle Subcription leave Blank and Follow…
    Oracle Database 12c R1 Installation for Lubuntu 14.04 Trusty LTS Step 1 of 13
    Confirm for Installation also on Warning.
    Oracle Database 12c R1 Installation for Lubuntu 14.04 Trusty LTS - Confirm on Warning
    Oracle Database 12c R1 Installation for Lubuntu 14.04 Trusty LTS Step 2 of 13
    Then Check “Install Software Only”!
    Oracle Database 12c R1 Installation for Lubuntu 14.04 Trusty LTS Step 3 of 13
    Click on “Next”
    Oracle Database 12c R1 Installation for Lubuntu 14.04 Trusty LTS Step 4 of 13
    Select Languages and Click on “Next”
    Oracle Database 12c R1 Installation for Lubuntu 14.04 Trusty LTS Step 5 of 13
    Select Edition and Click on “Next”
    Oracle Database 12c R1 Installation for Lubuntu 14.04 Trusty LTS Step 6 of 13
    Check Installation Locations and Click on “Next”
    Oracle Database 12c R1 Installation for Lubuntu 14.04 Trusty LTS Step 7 of 13
    Check Inventory Directory and Click on “Next”
    Oracle Database 12c R1 Installation for Lubuntu 14.04 Trusty LTS Step 8 of 13
    Check Groups and Click on “Next”
    Oracle Database 12c R1 Installation for Lubuntu 14.04 Trusty LTS Step 10 of 13
    Click on “Install” to Start Installation Process
    Oracle Database 12c R1 Installation for Lubuntu 14.04 Trusty LTS Step 11 of 13
  13. Solving: “Error in invoking target ‘all_no_orcl'”

    Troubleshooting ‘all_no_orcl’ Issue

    Ubuntu 14.04 Trusty Tahr TLS Amd64 Install Oracle 12c Database - Solve Error in invoking target 'all_no_orcl'

    Click on Retry

  14. Solving: “Error in invoking target ‘utilities'”

    Troubleshooting ‘utilities’ Issue

    Ubuntu 14.04 Trusty Tahr TLS Amd64 Install Oracle 12c Database - Solve Error in invoking target 'utilities'

    Click on Retry

  15. Solving: “Error in invoking target ‘install'”

    Modify the ‘ins_net_server.mk’ File

    nano /u01/app/oracle/product/12/dbhome_1/network/lib/ins_net_server.mk

    Modify the Oracle DB Home Directory following Your Initial Setup…
    In this Example the Target is: “/u01/app/oracle/product/12/dbhome_1″

    Search for “TNSLSNR_LINKLINE
    Modify the Line:

    $(TNSLSNR_LINKLINE)

    In:

    $(TNSLSNR_LINKLINE) -lnnz12 -lons

    Ctrl+X to Save & Exit from ‘nano’ Editor :)
    Ubuntu 14.04 Trusty Tahr TLS Amd64 Install Oracle 12c Database - Solve Error in invoking target 'install'

    Click on Retry

  16. Solving: “Error in invoking target ‘irman ioracle'”

    Modify the ‘env_rdbms.mk’ File

    nano /u01/app/oracle/product/12/dbhome_1/rdbms/lib/env_rdbms.mk

    Search for “ORACLE_LINKLINE
    Modify the Line:

    ORACLE_LINKLINE=$(ORACLE_LINKER) $(PL_FLAGS) $(ORAMAI) $(SSORED) $(TTCSOI) \
    

    In:

    ORACLE_LINKLINE=$(ORACLE_LINKER) -Wl,--no-as-needed $(PL_FLAGS) $(ORAMAI) $(SSORED) $(TTCSOI) \
    

    Ubuntu 14.04 Trusty Tahr TLS Amd64 Install Oracle 12c Database - Solve Error in invoking target 'irman ioracle'

    Click on Retry

  17. Then Run the Configuration Scripts for Oracle 12c Database

    sudo su
    /u01/app/oraInventory/orainstRoot.sh
    /u01/app/oracle/product/12/dbhome_1/root.sh
    exit

    Oracle Database 12c R1 Installation for Lubuntu 14.04 Trusty LTS Step 12 of 13

    And Finally the Installation Should be Achieved Successfully!

    Oracle Database 12c R1 Installation for Lubuntu 14.04 Trusty LTS Step 13 of 13

  18. How-to Create and Start the Oracle 12c Database

    Oracle 12c Create Database
  19. So Now Thanks to the Oracle Corporation You Should Finally Fully Dispose of a Oracle 12c Database Installation Lubuntu 14.04 LTS 64bit Linux ;)

Share on Tumblr

Tags: , , , , , , , , , , , , , , , , , , , , , ,


Comments are disabled