Friday, October 07, 2016

Ubuntu Oracle Instant Client

Step by step for installing instant client 12.1

Install RPMs

1. Download Oracle Instant client RPM files from
Download "Basic lite", and "SQL*Plus".

2. Convert these .rpm files into .deb packages and install using "alien"
("sudo apt-get install alien" if you don't have it).

alien -i oracle-instantclient12.1-basiclite-
alien -i oracle-instantclient12.1-sqlplus-

3. Test your Instantclient install by using "sqlplus" to connect to your database:

sqlplus username/password@//dbhost:1521/SID

Integrate Oracle Libraries & ORACLE_HOME

Add the Oracle libraries to the LD_LIBRARY_PATH to the system library list create a new file as follows:

sudo vi /etc/ && sudo chmod o+r /etc/

and add the oracle library path as the first line:


Then run ldconfig:

sudo ldconfig

Define ORACLE_HOME & LD_LIBRARY_PATH in a system-wide location.

sudo sudo vi /etc/profile.d/ && sudo chmod o+r /etc/profile.d/

Add the following:

export ORACLE_HOME=/usr/lib/oracle/12.1/client64
export LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib/${LD_LIBRARY_PATH:+:$LD_LIBRARY_PATH}

Alternatively, each user can define this in their ~/.bash_profile


No comments: