Shulou(Shulou.com)06/01 Report--

Editor to share with you how Navicat Premium connects to the Oracle database. I hope you will get something after reading this article. Let's discuss it together.

PostgreSQL database, which makes it easier to manage different types of databases. The most important thing is that it does not have to install the Oracle client. The following is a brief introduction to how Navicat Premium connects to the oracle client.

If you already have an Oracle database installed on your machine, it's simple. Navicat Premium can connect directly to Oracle.

If not installed, then Navicat will prompt you to install Oracle client, if not necessary, do not install Oracle client, not to mention its large size, four or five megabytes, it is difficult to uninstall clean after installation.

According to Navicat's official documentation, all you need to do is download Oracle's Instance Client. This package contains only some dll files and does not need to be unzipped by installation.

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

Oracle 9i or later, Instance Client 11 is required.

Oracle 8 and 8i use Instance Client 10 version.

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

(11 megabytes), because the Basic Lite version does not support Chinese, the connection will tell you that the server-side encoding is not supported. 、

Download Oracle Instance Client as follows

After downloading, extract it to any directory, and then open Navicat-> tools-> options-> OCI, as shown below:

Select the oci.dll file under the unzipped directory in OCI library, and then confirm it.

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

As shown in the following figure:

Finally, the Navicat Premium download address:

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

Registration code: NAVC-N7T9-WG9L-7U9B

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

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

SID:testeos corresponds to SID in navicat. SID and Service Name are not case sensitive.

After reading this article, I believe you have a certain understanding of "how Navicat Premium connects to Oracle database". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.