Installing Oracle 11g client in Ubuntu 14.04 LTS

I referred to the post at –> https://help.ubuntu.com/community/Oracle%20Instant%20Client

There are certain additional steps that I took to get the Oracle client up and running.

My laptop is running Ubuntu 14.04 64bit.

1. First download the *.zip file–> “instance client basic lite” from Oracle website

http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

2. Unzip the file into /usr/lib/oracle/11.2/client64

3. Prepare .bash_profile file

cat $HOME/.bash_profile
export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib/:$LD_LIBRARY_PATH
export ORACLE_HOME=/usr/lib/oracle/11.2/client64
export PATH=$PATH:$ORACLE_HOME/bin

4. Create a “bin” folder. Move sqlplus into the bin folder.

5. Create a “lib” folder. Move all lib* files into “lib” folder.

6. Create network/admin folder. And put your tnsnames.ora into it. This way your sqlplus will know which alias to call.

7. Ultimately, the structure should be as followed

/usr/lib/oracle/11.2/client64$ ls -ltr

total 5076
-rw——- 1 des des 192365 Aug 24 2013 uidrvci
-rw——- 1 des des 47860 Aug 24 2013 genezi
-rw——- 1 des des 449 Aug 24 2013 BASIC_LITE_README
-rw——- 1 des des 25420 Aug 24 2013 adrci
-rw——- 1 des des 66779 Aug 24 2013 xstreams.jar
-rw——- 1 des des 2739616 Aug 24 2013 ojdbc6.jar
-rw——- 1 des des 2091135 Aug 24 2013 ojdbc5.jar
-rw——- 1 des des 443 Aug 24 2013 SQLPLUS_README
drwxrwxr-x 2 des des 4096 Sep 23 14:03 bin
drwxrwxr-x 2 des des 4096 Sep 23 14:05 lib
drwxrwxr-x 3 des des 4096 Sep 23 14:16 network

8. I need to run the following as well.

sudo apt-get install libaio1

9. It should work now.

Standard

Leave a comment