Navicat connecting 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 will typically include a version of OCI under its own installation path, if ORA-28547 error occurs when connecting to an Oracle server using Navicat, mostly because 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 in this document, there is one thing to pay special attention to: Download the appropriate Instant Client packages for your platform (must is 32-bit version, even you is using 64-bit wind OWS) is to say: 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