Navicat premium connection to Oracle Database

References: http://blog.sina.com.cn/s/blog_5157093c0100mrez.html

Navicat premiumIs a multi-Connection database management tool that allows youProgramConnect to MySQL, SQLite, Oracle, and PostgreSQL databases 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

PS: 2011-7-8. The difference between service name and Sid is shown in:

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 case insensitive.