Tuesday, January 05, 2010

Installing Oracle 11g InstantClient

I've recently begun using the Oracle InstantClient as opposed to the full client install for two reasons:
  1. Smaller footprint (42MB for 11.1.0.7.0)
  2. No Windows restart required (great for production environments)
  3. Really simple installation...

Installation Procedure

  1. Download the InstantClient zip folder (http://www.oracle.com/technology/software/products/database)
  2. Unzip the folder to a location of your choice
  3. Add that folder to the 'path' environment variable
  4. If you are using TNSNAMES, add the location of the tnsnames.ora file to the TNS_ADMIN environment variable

Worked a treat for getting ASP.NET 3.5 and SQL Server Reporting Services 2005 up and running with Oracle connectivity.

No comments: