Navicat connecting Oracle database Ora-28547:connection to server failed, probable Oracle Net Admin Error Resolution

Original: Navicat connection Oracle database Ora-28547:connection to server failed, probable Oracle Net Admin Error Resolution

The navicat is connected to an Oracle server through an Oracle client. There are two types of clients for Oracle, a standard client setup program:

Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

The other is a "concise version" of the client, called Oracle Instant Client, referred to as OCI,:

Http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

Navicat typically contains a version of the OCI under its own installation path,

If a ORA-28547 error occurs when using Navicat to connect to an Oracle server,

Most are due to the fact that the NAVICAT local OCI version does not match the Oracle server.

The solution is to go to the OCI download page

Http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

Select a server with the same version of the installation to local,

Here is an installation document http://wiki.navicat.com/wiki/index.php/Instant_client_required

One thing to note in this document: Download theappropriate Instant Client packages for your platform (must is 32-bit version, even you AR E using 64-bit Windows)

It is said: Whether your machine is 32-bit, you must download the 32-bit oci!

Navicat connecting Oracle database Ora-28547:connection to server failed, probable Oracle Net Admin Error Resolution