Connecting to Oracle Database times Navicat ora-28547:connection to server failed, probable Oracle Net admin Error

Connecting to Oracle database times Navicat ora-28547:connection to server failed, probable Oracle Net admin Error

The following error occurred while connecting to the Oracle database with Navicat

On the Internet to check the original Oci.dll version is wrong. Because Navicat connects Oracle servers through Oracle clients, Oracle clients are divided into two types, one Standard Edition and one concise version, Oracle Install client. When we use Navicat, we usually include multiple versions of OCI under our own installation path, and most of the Navicat local OCI version does not match the Oracle Server server if you use Navicat to connect to the Oracle Server ORA-28547 error. So all we have to do is download the OCI to match the Oracle Server we have installed.

OCI Download Address: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

It is worth noting that no matter whether you are using a 32-bit system or a 64-bit system, you should download the 32-bit install Client.

There is also a point to note that oracle9i or above, to install install Client11 or above; Oracle8 or 8i server, you need to install install Client10 or below. This is not a big problem, because we now have Oracle 10 or 11, just pay attention.

Then configure it in Navicat, select Tools-Options

Then select the other-oci in the Left tab.

Find the Oci.dll in the folder you just downloaded in the OCI library

This completes the Navicat configuration and makes the Oci.dll version in Navicat consistent with the version in Oracle, which must be restarted for the navicat to take effect. So the entire configuration is complete.