Install Oracle Instant Client / ODAC

Installing the Oracle Instant Client will save you ~600 megabyes compared to the ‘full’ Oracle Client.

Installation steps:

  1. Read some basic info here…
  2. Download Basic Package for Oracle site
  3. Unzip to directory x (your ORACLE_HOME)
  4. Set PATH (Windows) or LD_LIBRARY_PATH (*nix) to the Instant Client directory x
  5. Move TNSNAMES.ora to directory x/network/admin (or set TNS_ADMIN and ORACLE_HOME).
  6. Extend with SQL*Plus Package from (optional)
  7. Start your application

Read my full article here: Whiteblog – Installing the Oracle Instant Client. (links in referred blog might not work!)

ODAC

OLE DB, .NET and ASP.NET drivers are not included in the instant client (first Oracle link might suggest it is). These are included in the ODAC package, download them separately at these locations:

Instant Client vs Full Client (Administrator and Runtime)

What Are The Different Oracle Client Components Installed With Different Installation Type In (too much to sum up):

Client mater note

Master Note For Oracle Database Client Installation (Doc ID 1157463.1)

Happy consulting!

Checked for relevance on 7 March 2016.

Xming: wrong authentication protocol

Ever had the “wrong authentication protocol” error when using Xming and xhost+ still did not work?

When you are on a private network, you can try using the “-ac” option when starting Xming. Use this only on private trusted networks, because it gives access to everyone.

For mote information on Access Control in Xming and X-Forwarding with PuTTY and SSH, check the Xming troubleshoot guide.

Happy consulting!