NavicatPremium connecting to the Oracle database

Source: Internet
Author: User
NavicatPremium is a multi-Connection database management tool that allows you to connect to MySQL, SQLite, Oracle, and PostgreSQL databases with a single program 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 is a brief introduction of how NavicatPremium connects to the oracle client.

Navicat Premium is a multi-Connection database management tool that allows you to connect to MySQL, SQLite, Oracle, and PostgreSQL databases with a single program 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 is a brief introduction of how Navicat Premium connects to the oracle client.

Navicat PremiumIt is a database management tool that supports multiple connections. It allows you to connect to MySQL, SQLite, Oracle, and PostgreSQL databases with a single program 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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.