HowTo install SQL*PLUS on Ubuntu 9.10

Download the Instant Client Package Basic and SQL*PLUS zips from here.

Create a directory and unzip them both into that directory, they unzip into the same sub-dir

The sql*plus .rpm files don't download properly, they just show partial data in firefox.
Besides you would need alien to install the .rpm files since ubuntu used .deb.

gedit ~/.bashrc


Add the following editing paths as appropriate:

PATH=.:$PATH:/home/tcollinsworth/Oracle/instantclient_10_2
export LD_LIBRARY_PATH=/home/tcollinsworth/Oracle/instantclient_10_2
export TNS_ADMIN=~

gedit ~/tnsnames.ora

Add the following editing as appropriate:

YOUR_ALIAS_NAME =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = someHostname.company.com)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = YOUR_SERVICE_NAME)
      (SERVER = DEDICATED)
    )
  )

Reload the .bashrc with:

. ~/.bashrc

Connect to oracle with:

>sqlplus user/pwd@your_alias_name


Followed this blog