$schemamarkup = get_post_meta(get_the_ID(), 'schemamarkup', true); if(!empty($schemamarkup)) { echo $schemamarkup; }

How to Install Oracle 12c R2 Database on Ubuntu 17.10 Artful 64-bit Easy Guide

May 9, 2018 | By the+gnu+linux+evangelist.

Install Oracle 12c R2 Ubuntu 17.10 64-bit

Hi! The Tutorial shows you Step-by-Step and Visually How to Install Oracle 12c R2 Database for Ubuntu 17.10 Artful LTS Amd64 GNU/Linux Desktop/Server.

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

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

The Process is Extended and Tricky so it require a little patience and confidence with the Command Line shell.

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

How to Install Oracle 12c R2 Database on Ubuntu 17.10 Artful 64-bit - Featured

Oracle 12c R2 DB Installation on Ubuntu 17.10 Artful
1/5 Initial Configuration

  1. Download the Oracle 12c R2 Database for Linux:
    Oracle 12c R2 .zip for Linux
    The Link Contains the List of Oracle 12c R2 Database Releases.

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

    How to Install Oracle 12c R2 Database on Ubuntu 17.10 Artful 64-bit - Open Terminal

    In case first see: Terminal QuickStart Guide.

  3. Extracting the Oracle 12c R2 Archive
    Double-Click or Right-Click on Archive and Extract into /tmp.

    How to Install Oracle 12c R2 Database on Ubuntu 17.10 Artful 64-bit - Extraction
    Or From Command Line:

    unzip -d /tmp linuxx64_122*.zip
  4. Add Needed Oracle DB Groups and User

    sudo su

    If Got “User is Not in Sudoers file” then see: How to Enable sudo

    groupadd -g 502 oinstall
    groupadd -g 503 dba
    groupadd -g 504 oper
    groupadd nobody
    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 :)

  5. Setting up 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 on 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 Target Directories

    mkdir -p /u01/app/oracle/product/12/dbhome_1
    chown -R oracle:oinstall /u01
    chmod -R 775 /u01
  8. 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 R2 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 12c R2 ####/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



Follow with Ubuntu 17.10 Oracle 12c R2 DB Installation | 2/5 Installing Packages >>.