Navicat Premium Connect Oracle Database

Navicat Premium is a multi-connection database management tool that allows you to connect to MySQL, SQLite, Oracle, and PostgreSQL databases in a single program, making it easier to manage different types of databases. The most important thing is that it doesn't have to be an Oracle client. Below is a brief introduction to how Navicat Premium connects to Oracle clients.

If your machine already has an Oracle database, it's simple, Navicat Premium can connect directly to Oracle.

do not install Oracle client , first of all, it is a large size, there are four hundred or five hundred trillion, after loading you can not uninstall clean.

only needs to download Oracle's Instance Client . This package contains only a few DLL files, no need to install decompression.

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

Oracle 9i or newer, requires the Instance Client 11 version

Oracle 8 and 8i with Instance Client version 10.

Also note that only the 32-bit version can be downloaded because Navicat does not support the 64-bit version, but also to download the basic version (40M), rather than the basic Lite version (11 MB), because the basic Lite version does not support Chinese, the connection will tell you that the service The code on the server side is not supported.

Download Oracle Instance Client as

　　

After downloading, unzip to any directory, and then open the OCI, Options, Navicat, tools, as shown in:

　　

in the OCI library place select the extracted directory under the Oci.dll file, OK.

The next step is to create a new Oracle connection, note that the connection type must choose Basic, otherwise you'll have to make a lot of configuration files.

As shown in the following:

　　

Finally,Navicat Premium:

Registration code: NAVC-N7T9-WG9L-7U9B

Ps:2011-7-8,service the difference between name and Sid, as shown in:

　　

Global database name: Testeos.xuwei corresponds to service name in Navicat

Sid:testeos corresponds to the SID in the Navicat. The SID and service name are case insensitive.

　　Navicat Chinese official website: www.formysql.com

Navicat Premium Connect Oracle Database