Oracle Database 12c on Ubuntu 14.04, Software Only

This blog documents my install of Oracle 12c database on Ubuntu 14.04 LTS Server. After initial installation of Oracle 12c database on Ubuntu I will perform the database creation w/db.rsp file and provide the details in another blog.

Oracle 12c database is not certified on this particular OS so the install instructions contained in this blog should not be used on servers in a production environment.

I used Ubuntu Server and used this download link http://www.ubuntu.com/server

I downloaded 14.04 LTS Server iso , burned to CD and installed with minimal number of packages.

For this activity, I referenced Oracle Documentation, referenced online blogs and documentation, those are listed as references at the bottom of this blog.

The steps below should be followed sequentially.

FINISH OS INSTALLATION

apt-get update

apt-get dist-upgrade

apt-get install openssh-server

reboot

CHECK / MODIFY HOST FILE

Hosts File The "/etc/hosts" file must contain a fully qualified name for the server.

<IP-address> <fully-qualified-machine-name> <machine-name>

For example. My hostname is ubuntu

127.0.0.1 ubuntu
192.168.1.111 ubuntu

Set the correct hostname in the "/etc/hostname" file.

ubuntu

Restart your network service

/etc/init.d/networking restart
 
INSTALL ADDITIONAL PACKAGES

Required:
apt-get -y install lsb binutils build-essential debhelper g++-4.4 gawk gettext html2text intltool-debian ksh make odbcinst po-debconf sysstat unzip openssh-server lxde-core xorg lib32ncurses5 lib32bz2-dev lib32z1-dev libaio-dev libbeecrypt7 libelf-dev libltdl-dev libmotif4 libodbcinstq4-1 libodbcinstq4-1:i386 libqt4-core libqt4-gui libsqlite3-0 libstdc++5 libstdc++6 unixodbc-dev

Optional:
apt-get -y install gnome-core

ADD ORACLE GROUPS AND USERS

groupadd oinstall

groupadd dba

useradd -m -g oinstall -G dba -s /bin/bash oracle

passwd oracle

CREATE ORACLE DIRECTORIES

mkdir -p /u01/app/oracle

chown -R oracle:oinstall /u01

chmod -R 775 /u01

CREATE ORACLE DIRs & GRANT PRIVS TO ORACLE

mkdir /u01
chown oracle:oinstall /u01

CREATE .bash_profile for ORACLE

# .bash_profile

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=ubuntu; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_home; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID
ORACLE_TERM=xterm; export ORACLE_TERM

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

BASE_PATH=/usr/sbin:$PATH:$HOME/bin; export BASE_PATH
PATH=$ORACLE_HOME/bin:$BASE_PATH; export PATH

CREATE REQUIRED LINKS FOR UBUNTU OS

mkdir /usr/lib64

ln -s /etc /etc/rc.d

ln -s /lib/x86_64-linux-gnu/libgcc_s.so.1 /lib64/

ln -s /usr/bin/awk /bin/awk

ln -s /usr/bin/basename /bin/basename

ln -s /usr/bin/rpm /bin/rpm

ln -s /usr/lib/x86_64-linux-gnu/libc_nonshared.a /usr/lib64/

ln -s /usr/lib/x86_64-linux-gnu/libpthread_nonshared.a /usr/lib64/

ln -s /usr/lib/x86_64-linux-gnu/libstdc++.so.6 /lib64/

ln -s /usr/lib/x86_64-linux-gnu/libstdc++.so.6 /usr/lib64/

PRETEND WE ARE INSTALLING ON A SUPPORTED OS

not necessary

DOWNLOAD SOFTWARE & UNZIP FILES

You will need an OTN.oracle.com account. I downloaded the files from OTN.oracle.com to my local Win PC than I transferred the files to my Ubuntu host via some method not described here.

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

unzip linuxamd64_12102_database_1of2.zip

unzip linuxamd64_12102_database_2of2.zip

RUN THE ORACLE INSTALLER

ssh -Y oracle@192.168.1.111
  this is the ip for my host named ubuntu

/tmp/database/runInstaller -ignoreSysPrereqs

INSTALLATION ERRORS
5 errors occurred during the gui install all have workarounds, and need to be posted here
12/12/14



References :
Start with Installation examples for Oracle 11g database on Ubuntu

http://www.oracle-base.com
http://hswong3i.net/blog/hswong3i/oracle-database-11g-release-2-ubuntu-12-04-howto
http://www.makina-corpus.org/blog/howto-install-oracle-11g-ubuntu-linux-1204-precise-pangolin-64bits
http://thinkigotit.wordpress.com/2014/08/13/install-oracle-database-12c-in-ubuntu-14-04/#01
http://tutorialforlinux.com/2014/10/01/how-to-install-oracle-12c-database-for-ubuntu-14-04-trusty-lts-64bit-linux-easy-guide/