What should I do if navicat fails to connect to oracle?

The connection failed when Navicat connected to the oracle database, and an ORA-28547 error occurred.

Cause: The OCi version of navicat Primium is inconsistent with the OCI version of the local database.

Solution:

1. Replace the oci.dll that comes with the navicat Primium version with the oci.dll in the local Oracle installation path.

My local navicat Primium version comes with the oci.dll path: F:\Navicat Premium\instantclient_10_2\oci.dll

##Related recommendations: "

Navicat for mysql graphic tutorial》

2. Find the oci.dll in the local Oracle installation path, and modify the OCI path that comes with the navicat Primium version to the OCI path in the local Oracle installation path. .

My local Oracle oci.dll path is: F:\Oracle_11g_R2\product\11.2.0\dbhome_1\BIN\oci.dll

Modify OCi path for navicat Primium version.

The above is the detailed content of What should I do if navicat fails to connect to oracle?. For more information, please follow other related articles on the PHP Chinese website!