Herman Bos open source guerilla

Running SQL*plus on Ubuntu

Everytime I need it for school I have to re-figure-out how to fix the Oracle crap. I wasn't so keen on installing the full Oracle suite like I did the first time (few years back). Fortunately Oracle released a so-called "instantclient" a while ago, which is basicly the only part of the whole suite you need client-wise.

Download the files (version might differ ofcourse in some future time):
instantclient-basic-linux32-10.2.0.1-20050713.zip
instantclient-sqlplus-linux32-10.2.0.1-20050713.zip

Copy it to some place you like and add that directory to LD_LIBRARY_PATH
export LD_LIBRARY_PATH=/home/herman/garbage/instantclient_10_2:${LD_LIBRARY_PATH}

After this it is possible to connect. Syntax example:
./sqlplus USERNAME/PASSWORD@145.33.144.212/DBNAME
Port is 1521 by default.

Quite easy in the end, and less dirty then before.

Links: readme ic