Advertisements

Archive

Posts Tagged ‘installing instant client jdbc’

How to Install Instant Client for Oracle Database

August 3, 2017 Leave a comment

Instant Client is an Oracle database auxiliary application that contains libraries such as OCI or JDBC to connect to a remote database server. To install Instant Client, it is available in the following link: http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

Select the Instant Client product that has the same as your Oracle database version. In this tutorial, we are using Oracle database 11g so we will use instant client 11.2.0.4. After you have downloaded the instant client, unpack the zip file and put it under the directory /opt/oracle/instantclient/. After that, make a symbolic link to the libclntsh.so.11.1 file by typing:

ln -s libclntsh.so.11.1 libclntsh.so

Also, set file permission to libclintsh.so and libnnz11.so by typing:

chmod 755 libclntsh.so
chmod 755 libnnz11.so

Change to the oracle user that you use to install your Oracle by typing su – oracle. Next, set your system environment accordingly for the instant client directory:

export D_LIBRARY_PATH=/opt/oracle/instantclient/
export ORACLE_HOME=$ORACLE_HOME:/opt/oracle/instantclient/
export PATH=$PATH:/opt/oracle/instantclient/

Advertisements