Use Navicat Lite to connect to the Oracle database

If your machine already has an Oracle database, it is very simple. Navicat can be directly connected to Oracle.

If it is not installed, Navicat will prompt you to install the Oracle client. If it is not necessary, do not install the Oracle client. If it is not necessary, do not say that it has a large header, with a size of 400 or 500 mb, after installation, it is difficult for you to uninstall it.

According to the official documents of Navicat, you only need to download the Instance Client of Oracle. 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 only the 32-bit version can be downloaded, because Navicat does not support the 64-bit version,

In addition, you need to download the Basic version (40 MB) instead of the Basic Lite version (11 Mb). Because the Basic Lite version does not support Chinese characters, the server encoding is not supported during connection.

Download Oracle Instance Client

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:

Below is the connected

Let's get started.