First start with unixodbc installation
$sudo apt-get install unixodbc
To conform the installation just type in isql from the shell and should work.
Install the alien utility (You need to install local .rpm packages)
$sudo apt-get install alien
Install libaio1 64 bit$sudo apt-get install libaio1
I have followed the steps from this post. But simplified it little bit.
You need to first download them from Oracle site.
Instant Client Home page:http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
Download page: http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html (Linux 64 bit)
I went with the following packages
Instant Client Package - Basic
Instant Client Package - JDBC Supplement
Instant Client Package - SQL*Plus
Instant Client Package - ODBC
names.directory_path = (EZCONNECT, LDAP, TNSNAMES, HOSTNAME)
MY_ORACLE_DB= (description= (address_list= (address = (protocol = TCP)(host = myoracledb.example.com)(port = 1521)) ) (connect_data = (service_name=ORCL) ))