Home  >  Article  >  Database  >  What should I do if navicat fails to connect to oracle?

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

爱喝马黛茶的安东尼
爱喝马黛茶的安东尼Original
2019-08-15 11:02:325890browse

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.

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

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

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

##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

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

Modify OCi path for navicat Primium version.

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

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn