Monday, September 18, 2006

Poor Man's Oracle Client

I generally despise having to install Oracle software because it's so big and bloated, it's scary. Most downloads won't fit on a typical CD, even their Oracle Express edition is bigger than Microsoft Windows! I don't know what Express means to them, but "huge" isn't the description I would think of.

But there is light at the end of the tunnel, Oracle now has Instant Client which is only 35MB! Wow! And all you have to do is unzip it. It includes OCI, OCCI, and JDBC drivers, but if you want to make it useful out of the box, you should get the SQL Plus package for Instant Client (722KB!) and unzip it into the same directory.  Put your tnsnames.ora into the directory as well if required.  Then run sqlplus.exe as you normally would and voila, you're done.

  1. Download Oracle Instant Client
  2. Download SQL*Plus for Instant Client (from same download page)
  3. Unzip Instant Client into a directory
    1. eg: c:\oracle_ic
  4. Unzip SQL*Plus into the same directory
  5. Put tnsnames.ora into the same directory (OPTIONAL)
  6. Run: sqlplus username/password@SID

Get SQL Explorer for a free JDBC based client if you want to connect with a visual client.