How-to Install Oracle 12c Database on Ubuntu 15.10 Wily 64bit Easy Guide

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:

• Plug Into the Cloud with Multitenant
• Automatic Data Optimization and Advanced Compression
• Enhanced Maximum Availability
• Enhanced Database Security

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

   

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 libtiff5 \
   libtiff5-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 libaio-dev

   How-to Install libpthread-stubs0: Here!

4. Double-Click or Right-Click on Archive and Extract into /tmp
   
   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 12c 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 12c ####
     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=DB12C; 
    export ORACLE_UNQNAME
    ORACLE_BASE=/u01/app/oracle; 
    export ORACLE_BASE
    ORACLE_HOME=$ORACLE_BASE/product/12/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

    bash

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

    Troubleshooting Oracle 12c Setup.
12. Then Follow the Installation WorkFlow
    If you Do Not Dispose of an Oracle Subcription leave Blank and Follow…
    
    Click on Next
    
    Confirm for Installation also on Warning about System does Not Meeting Minimum Requirements!
    
    Then Check “Install Software Only”!
    
    Click on “Next”
    
    Select Languages and Click on “Next”
    
    Select Edition and Click on “Next”
    
    Check Installation Locations and Click on “Next”
    
    Check Inventory Directory and Click on “Next”
    
    Click on “Next” on Groups
    Then Possibly Check “Ignore All” if Warned again about Missing Requirements…
    
    Click on “Install” to Start Installation Process
    

13. Solving Oracle 12c DB Libs Linking Errors on Ubuntu Wily

    Oracle 12c DB Troubleshooting Guide

    Oracle 12c DB Troubleshooting.

    

14. 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

    

    And Finally the Installation Should be Achieved Successfully!

    

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

    Oracle 12c Create Database

    Make Oracle Db

So Now Thanks to the Oracle Corporation
You Should Finally Fully Dispose of a Oracle 12c Database Installation Ubuntu 15.10 64bit Linux ;)

Tags: Database, Getting Started, getting-started oracle 12c database ubuntu, gnu, gnu linux, gnu linux tutorial, gnu/linux, Guide, How-to, Install, install database ubuntu, install oracle 12c database ubuntu, install oracle 12c database ubuntu 15.10, install oracle database ubuntu, Linux, linux database, linux oracle database, Linux Tutorial, Oracle, Oracle 12c, Oracle 12c Database, oracle 12c database ubuntu 15.10, oracle 12c r1 database, Oracle Database, oracle database installation ubuntu, oracle database tutorial, oracle db, oracle db tutorial, Tutorial, Ubuntu, Ubuntu 15.10 Wily Werewolf, ubuntu tutorial, Visual-Guide