Wednesday, September 10, 2014

Oracle Instant Client Installation


This was a useful guide to installing the Oracle Instant Client and SQL Plus applications on a Linux system.

The type of download file will vary depending on your Linux installation.  The two basic file types are the "instantclient-basic" and the "instantclient-sqlplus" files.

  • instantclient-basic-linux.x64-11.2.0.4.0.zip
  • instantclient-sqlplus-linux.x64-11.2.0.4.0.zip



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

The versions may vary depending on your current environment.  To use the software, set your PATH variables:

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

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



Original Reference:

ORACLE-BASE - Oracle Instant Client Installation