Navicat several problems and solutions for connecting Oracle

1. Using Navicat to connect Oracle database times wrong ora-28547:connection to server failed,probable Oracle Net admin Error

Solution:

On the Internet, it turns out that the Oci.dll version is wrong. Because Navicat is connected to Oracle servers through Oracle clients, Oracle's clients are divided into two, one standard and one compact, the Oracle Install client. When we use Navicat, we usually include multiple versions of OCI under our own installation path, and if we use Navicat to connect to an Oracle server ORA-28547 error occurs, most of the Navicat local OCI version does not match the Oracle Server server. So all we have to do is download the OCI to match the Oracle server we installed.

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

It is important to note that whether you are using a 32-bit system or a 64-bit system, you should download the 32-bit install Client.

It is also important to note that oracle9i or the above version, to be installed install Client11 or below, Oracle8 or 8i server, requires installation of install CLIENT10 or below. This is not a big problem, because we now have 10 or 11 Oracle, just be careful.

Then configure it in Navicat, select Tools-Options

Then select the other-oci in the Left tab.

In the OCI library, locate the Oci.dll in the folder you just downloaded.

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

2.

2. First of all, you have to have oci.dll this file.

   There are two ways to get:

4. 3

   Method One, if you have Oracle on this machine, then you can use it directly. E:\app\Administrator\product\11.2.0\dbhome_1\BIN

6. 4

   Method two, according to Navicat official document, actually only need to download Oracle's Instance Client. This package contains only a few DLL files, no need to install decompression.

   To download the Instance Client version according to different Oracle versions, the corresponding relationship is as follows:

   Oracle 9i or newer version requires the use of the Instance client 11 version of Oracle 8 and 8i with Instance client 10.

   It is also important to note that only the 32-bit version can be downloaded because Navicat does not support the 64-bit version, but also to download the basic version (40M), rather than the basic Lite version (11 MB), because the basic Lite version does not support Chinese, the connection will tell you that the server side The encoding is not supported.

   Unzip to any directory when you are finished downloading.

   Download Oracle Instance Client for example.

8. 5

   Then, tools, options, and other->oci find this location, in the OCI library place Select (Extract directory or Oracle directory) oci.dll file, OK.

10. 6

    Finally, restart Navicat Premium.

Navicat several problems and solutions for connecting Oracle