64-bit Navicat Premium-11.2.7 (64bit) access to 64-bit Oracle Servers

1 Install navicat Premium-11.2.7 (64bit) on Windows 10 64-bit operating systems.

2 Install 64-bit Oracle (WIN64_11GR2_DATABASE) on the server.

3 Download the environment required for OCI and sqlplus in http://www.oracle.com/technetwork/cn/topics/winx64soft-101515-zhs.html, download the instance client, There is no need to download the full Oracle client, but there is a problem with installing Oracle client reconfiguration.

OCI Environment:

Sqlplus Environment:

Unzip to the specified folder after download, such as Create directory OracleClient on D disk, extract Instantclient-basic-win-x86-64-11.2.0.1.0.zip to D:\OracleClient, Unzip the instantclient-sqlplus-win-x86-64-11.2.0.1.0.zip to the D:\OracleClient\sqlplus directory. Such as:

Note: You do not need to download Oracle Client (Oracle Database 2 Client (11.2.0.1.0) for Microsoft Windows (x64 ))

After downloading this installation, the OCI and Sqlplus configured in Navicat will prompt cannot load OCI dll,87 193 error.

4 Open the Navicat configuration OCI and Sqlplus path, in Navicat Tools-Options, select OCI Configuration item, configure the path that was unzipped in the previous step.

5 The Oracle connection is configured in Navicat and can be connected to the Oracle server properly.

64-bit Navicat Premium-11.2.7 (64bit) access to 64-bit Oracle Servers