Detailed steps for connecting Navicat Premium to Oracle database

The content of this article is about the detailed steps for Navicat Premium to connect to the Oracle database. It has certain reference value. Friends in need can refer to it. I hope it will be helpful to you.

PostgreSQL database makes managing different types of databases more convenient. The most important thing is that it does not require installing the Oracle client. The following is a brief introduction to how Navicat Premium connects to the Oracle client.

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

If it is not installed, Navicat will prompt you to install the Oracle client. If it is not necessary, Never install the Oracle client, not to mention that it is very big, with four 5 MB, it is difficult to uninstall it after installation.

According to Navicat’s official documentation, in fact you only need to download Oracle’s Instance Client. This package only contains some dll files and does not require installation and decompression.

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

Oracle 9i or newer version, you need to use the Instance Client 11 version

Oracle 8 and 8i use Instance Client version 10.

In addition, it must be noted that you can only download the 32-bit version because Navicat does not support the 64-bit version. In addition, you must download the Basic version (40M), not the Basic Lite version

(11 MB), because the Basic Lite version does not support Chinese, it will tell you that the server-side encoding is not supported when connecting. ,

Download Oracle Instance Client as shown below

After downloading, extract it to any directory, then open Navicat -> Tools-> Options-> ; OCI, as shown below:

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

The next step is to create a new Oracle connection. Note that the connection type must be selected as Basic, otherwise you will have to create a lot of configuration files.

As shown below:

Finally, Navicat Premium download address:

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

Registration code: NAVC-N7T9-WG9L-7U9B

PS:2011-7-8, Service The difference between Name and SID is as shown in the following figure:

Global database name: testeos.xuwei corresponds to the Service Name in navicat

SID: testeos Corresponds to the SID in navicat. SID and Service Name are not case-sensitive.

The above is the detailed content of Detailed steps for connecting Navicat Premium to Oracle database. For more information, please follow other related articles on the PHP Chinese website!