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

Source: Internet
Author: User

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.

 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.