NavicatPremium connecting to the Oracle database

NavicatPremium is a multi-Connection database management tool that allows you to connect to MySQL, SQLite, Oracle, and PostgreSQL databases with a single program at the same time, making it easier to manage different types of databases. The most important thing is that it does not have to install an Oracle client. The following is a brief introduction of how NavicatPremium connects to the oracle client.

Navicat Premium is a multi-Connection database management tool that allows you to connect to MySQL, SQLite, Oracle, and PostgreSQL databases with a single program at the same time, making it easier to manage different types of databases. The most important thing is that it does not have to install an Oracle client. The following is a brief introduction of how Navicat Premium connects to the oracle client.

Navicat PremiumIt is a database management tool that supports multiple connections. It allows you to connect to MySQL, SQLite, Oracle, and PostgreSQL databases with a single program at the same time, making it easier to manage different types of databases. The most important thing is that it does not have to install an Oracle client. The following describes how to connect Navicat Premium to the oracle client.

If your machine is already equipped with an Oracle database, it is very simple that Navicat Premium can be directly connected to Oracle.

If it is not installed, Navicat will prompt you to install the Oracle client. If not,NEVER install an Oracle clientNot to mention that the block size is very large, with a size of 400 or 500 mb. It is difficult for you to uninstall it after installation.

According to the official documents of NavicatYou only need to download the Oracle Instance Client.. This package only contains some dll files, without installation and decompression.

Download the Instance Client version based on different Oracle versions. The relationship is as follows:

You must use Instance Client 11 for Oracle 9i or later versions.
Oracle 8 and 8i use Instance Client Version 10.

In addition, you must note that you can only download the 32-bit version. Because Navicat does not support the 64-bit version, you must also download the Basic version (40 MB) instead of the Basic Lite version (11 Mb ), because Basic Lite does not support Chinese characters, the server encoding is not supported during connection.

Download the Oracle Instance Client, as shown in figure

Decompress the downloaded package to any directory and open Navicat> tool> Option> OCI, as shown in:

In the OCI library, select the oci. dll file in the decompressed directory and click OK.

The next step is to create an Oracle connection. Note that you must select Basic as the connection type. Otherwise, you will need to create many configuration files.

As shown in:

Finally,Navicat Premium:

Http://download.navicat.com/download/navicat9_premium_cs.exe

The registration code: NAVC-N7T9-WG9L-7U9B