Tag Archives: Instant Client

ORA-28547 with Instant Client and Amazon Cloud Web Services

By | |
Leave a comment

Connecting with the Oracle Instant Client 11g to Amazon Cloud Web Services (amazonaws.com) can result in the next error:

ORA-28547: connection to server failed, probable Oracle Net admin error

I found that while pinging the host, it was not able to resolve it, but connecting with SQL Developer (4.1.0.17) was possible! Strange…

I downloaded the Oracle Instant Client 12c (12.1.0.2) and that works. It seems the Oracle Instant Client 11g (11.2.0.4) is not able to connect to Amazon Web Services…

Happy connecting!

Install Oracle Instant Client / ODAC

By | | , ,
5 Comments

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

Installation steps:

  1. Download Basic Package from the Oracle site
  2. Unzip to directory x (your ORACLE_HOME)
  3. Set PATH (Windows) or LD_LIBRARY_PATH (*nix) to the Instant Client directory x
  4. Move TNSNAMES.ora to directory x/network/admin (or set TNS_ADMIN and ORACLE_HOME).
  5. Extend with SQL*Plus Package (optional)
  6. 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 Types (too much to sum up):

Client master note

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

Happy consulting!

Checked for relevance on November 4th, 2019.