An error occurred when connecting to the Oracle database with Navicat: ORA-28547: connection to server failed, probable Oracle Net admin error

An error occurred when connecting to the Oracle database with Navicat: ORA-28547: connection to server failed, probable Oracle Net admin error

The following error occurs when you use Navicat to connect to the Oracle database:

The version of oci. dll is incorrect. Because Navicat connects to the Oracle server through the Oracle Client, there are two types of Oracle clients: Standard Edition and simplified edition, that is, Oracle Install Client. When we use Navicat, we usually include multiple versions of OCI under our own installation path. If a ORA-28547 error occurs when we use Navicat to connect to the Oracle server, most of the reasons are that the local OCI version of Navicat does not match the Oracle server. So what we need to do is download OCI to make it consistent with the Oracle server we have installed.

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

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

Note that for Oracle9i or later, Install Client11 or below; for Oracle8 or 8i servers, Install Client10 or below. This is not a big problem, because our current Oracle is 10 or 11, just pay attention to it.

Configure the tool in Navicat and select the tool-option.

Select other-OCI in the left-side navigation pane.

Find OCI. dll in the downloaded folder in oci library

In this way, the Navicat configuration is completed, so that the oci. dll version in Navicat is consistent with that in Oracle. You must restart Navicat to take effect. This completes the configuration.