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.
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 couldn't really be simpler.
$ mkdir ~/software $ cd ~/software $ unzip /tmp/instantclient-basic-linux.x64-220.127.116.11.0.zip $ unzip /tmp/instantclient-sqlplus-linux.x64-18.104.22.168.0.zip
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
For more information see:
Hope this helps. Regards Tim...