Navicat Premium Connection to Oracle database configuration

Navicat Premium Connection to Oracle database configuration

1. Oracle database server Download

Oracle official Website Download database latest version: Http://www.oracle.com/technetwork/cn/database/enterprise-edition/downloads/index.html

2, Navicat premium_11.2.7 Simplified Chinese version (32-bit and 64-bit) download

http://download.csdn.net/detail/ahgaoyong/9482314

3, Oracle Instant Client Download ( Note To download the basic version, do not download Basiclite (Basic Lite) )

Http://www.oracle.com/technetwork/cn/database/features/instant-client/index-092699-zhs.html,

which

Instant Client Downloads for Microsoft Windows (32-bit) :

Http://www.oracle.com/technetwork/topics/winsoft-085727.html

Instant Client Downloads for Microsoft Windows (x64):

Http://www.oracle.com/technetwork/cn/topics/winx64soft-101515-zhs.html

using the 32-bit navicat Premium, download the 32-bit instant client and use the 64-bit navicat premium to download 64-bit Instant client, most of which says Navicat Premium does not support 64-bit, download 32-bit instant Client, because this machine is a 64-bit operating system, installed 64-bit navicat Premium, downloaded multiple versions of the 32-bit instant client can not connect to the database, Download the 64-bit instant Client to solve the problem successfully.

4. Navicat Premium Configuration

4.1. Open Navicat Premium, click Connect to select Oracle

4.2. fill in the connection information

There are two types of connection for Oracle in NAVICAT Premium: Basic and TNS.

In Basic mode, Oracle is connected through the Oracle call Interface (OCI). OCI is an application interface that allows program developers to access the Oracle database and control the stages in which all SQL statements run by using the third-generation language legacy process or function call. OCI is a standard database access library and a dynamic link library form retrieval function. Basic mode requires a host name or IP address, port, and service name or SID.

In TNS mode, you need to use an alias item in the Tnsnames.ora file to connect to an Oracle server through Oracle call Interface (OCI). The TNS mode only needs to select the network service name, but before you need to create a new Tnsnames.ora and configure the database service. It is recommended to use a more concise basic mode, which eliminates complex tnsnames configurations. The basic model is used in this article. In the "New Connection" interface, enter the connection name, connection type, hostname or IP address, port, service name or SID, username and password, and click OK to connect to the database.

Click on the connection test to test success and prove the connection is successful!

5. Summary of Issues

Described above is the smooth connection of the connection steps, in the process of connection also encountered some problems, the following to summarize these questions:

5.1, question 1: ora-12737:instant Client light:unsupported server character Set ZHS16GBK

The problem is caused by the direct use of Navicat-instantclient_10_2. Comes with a basic lite version of the instantclient.

Lite version of Basic Lite:basic with only English error messages and Unicode, ASCII, and Western European character set support

Basic: All the files required to run the OCI, Occi, and JDBC-OCI applications, including the Chinese character set. The solution is to change the basic version of Instantclient.

5.2. Problem 2:only compatible with OCI vers and higherion 8.1 and higher

Reference Blog: http://blog.csdn.net/tfy1332/article/details/46429353

5.3. Problem 3:cannot Load OCI dll,193

 

This is due to the inconsistency between the Navicat version and the Navicat Premium, since Navicat Premium only supports the 32-bit instant client, check that you are downloading a 32-bit instant client.

Navicat Premium Connection to Oracle database configuration