Oracle 8i | Oracle 9i | Oracle 10g | Oracle 11g | Oracle 12c | Miscellaneous | PL/SQL | SQL | Oracle RAC | Oracle Apps | Linux

Oracle Instant Client Installation

The Oracle Instant Client is a light-weight, freely distributable implementation of an Oracle client. A big advantage of the Instant Client is it does not need a formal installation. Instead, it can be unzipped and used without any fuss.

Download

The links below provide the general downloads page and the Linux x86-64 specific downloads, which will be used in this article.

There are a number of downloads available, depending on which features you require. The Linux versions also come with an RPM option, but as this requires root privilege to install, it may not be considered so desirable. The basic download provides all the core functionality necessary to make basic connections from Java. In this case, I wanted to make SQL*Plus connections, so I downloaded the following zip files.

Installation

Installation couldn't really be simpler.

$ mkdir ~/software
$ cd ~/software
$ unzip /tmp/instantclient-basic-linux.x64-11.2.0.4.0.zip
$ unzip /tmp/instantclient-sqlplus-linux.x64-11.2.0.4.0.zip 

Use

When using the Instant Client, we need to make sure the LD_LIBRARY_PATH environment variable is set to point to the location where the software was unzipped. In this case, I also set the PATH environment variable.

$ export LD_LIBRARY_PATH=/home/tomcat/software/instantclient_11_2
$ export PATH=$PATH:$LD_LIBRARY_PATH

$ sqlplus scott/tiger@//myhost.example.com:1521/myservice

That's it!

For more information see:

Hope this helps. Regards Tim...

Back to the Top.