Install Oracle Instant Client
Installing the Oracle Instant Client will save you 600 megabyes compared to the ‘full’ Oracle Client.
Installation steps:
- Download Basic Package
- Unzip
- Set path (and TNS_ADMIN !)
- Extend with SQL*Plus Package (optional)
- Start the application
Read full article here: Whiteblog – Installing the Oracle Instant Client.
Happy consulting!
May 19th, 2010 at 10:26 am
Hi Ian,
Thanks for the simplicity!
Can you give us an insight in how the instant client is different from the (enormous) ‘real’ version? In other words, when to use it, and when not?
Thanks!
Regards,
Douwe Pieter
May 19th, 2010 at 11:09 am
Hello Douwe,
With the full Oracle Client you will get the Oracle ‘thick’ Client and loads of binaries for administration like the Oracle Universal Installer, import and export tools, tnsping etc. including more data providers like ODBC, OLEDB and all kinds of .Net providers.
The Oracle ‘thick’ client includes drivers for fancy functionality like connection pooling, reacting to FAN messages when DataGuard or RAC nodes are shutting down etc.
If you only need ‘simple’ database access for tools like SQL Developer, the Oracle Instant Client is the only thing you need, download, copy, set PATH and GO!
Cheers,
Ian.
May 20th, 2010 at 12:53 pm
Sounds great Ian,
so you could probably use it in about 99% of the situations…
Regards,
Douwe Pieter