If you are still having trouble running sqlplus please refer to my previous article on how to install Oracle Client.
In order to install cx_Oracle open a Terminal and execute the following:
apt-get install python-pip python-dev build-essential
ln -s libclntsh.so.x.x libclntsh.so
pip install cx_Oracle
As you know Oracle does not support Ubuntu. I was not able to find a link where it provides a step by step Oracle client installation. Therefore, I am going to provide them.
Open a Terminal and run the following:
sudo apt-get install alien
Go to http://www.oracle.com/technetwork/topics/linuxsoft-082809.html and download the following:
Go back to the terminal and move to the directory where you downloaded the files and execute the following:
sudo alien -i oracle-instantclient11.2-basic-184.108.40.206.0-1.i386.rpm
sudo alien -i oracle-instantclient11.2-sqlplus-220.127.116.11.0-1.i386.rpm
sudo alien -i oracle-instantclient11.2-devel-18.104.22.168.0-1.i386.rpm
sudo apt-get install libaio1
sudo vi /etc/ld.so.conf.d/oracle.conf and add /usr/lib/oracle/11.2/client/lib/
At this point sqlplus should be running from the terminal with no issues.
Add the following to .bashrc:
Execute the following:
sudo mkdir network
sudo mkdir admin
Put your tnsnames.ora file in /usr/lib/oracle/11.2/client/network/admin/