Installing Oracle client libraries on Ubuntu

The latest RPM files can be downloaded from Oracle instant client download section.

The three minimal RPMs required are “Basic”, “SQLPlus” and the “SDK”.

In case of Ubuntu 14.04 LTS, Intel on 64-bit we will need to download the files mentioned below:

• oracle-instantclient12.1-basic-*.x86_64.rpm
• oracle-instantclient12.1-sqlplus-*.x86_64.rpm
• oracle-instantclient12.1-devel-*.x86_64.rpm

Note: The asterisk (*) would be the latest version available for download.
Convert and Install

The RPM filess need to be converted from .rpm to .deb, you’ll need to use the commandline tool alien. I the tool is not already installed it needs to be installed as shown bellow:

1	$ sudo apt-get install alien

Now convert and install the packages in this order:

1 2 3

$ sudo alien -i oracle-instantclient12.1-basic-*.x86_64.rpm $ sudo alien -i oracle-instantclient12.1-sqlplus-*.x86_64.rpm $ sudo alien -i oracle-instantclient12.1-devel-*.x86_64.rpm

Now test the client libs using the sqlplus commandline tool. Use either sqlplus or sqlplus64 depending on your platform:

Replace the connection string with the appropriate parameters.

1	$ sqlplus64 username/password@//dbhost:1521/SID

If you get an error message “missing libaio.so.1 file”, run:

1	$ sudo apt-get install libaio1

If you get an error message “sqlplus64: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory”, then you need to add it to the system library list. To do so you need to locate the Oracle liberaries path, which would be something like:

/usr/lib/oracle/12.1/client64/lib/

Now, add this path to the system library list. CREATE and ADD the line to a NEW file:

1	$ sudo vi /etc/ld.so.conf.d/oracle.conf

Add inside the path:

/usr/lib/oracle/12.1/client64/lib/

Run now the dynamic linker run-time bindings utility:

Shell

1	$ sudo ldconfig

For any further errors or issues while trying to run sqlplus, please refer the Ubuntu help page.