Navicat connects to Oracle database (graphic tutorial)

Navicat premium is a database management tool. It is a multi-connection database management tool. It allows you to connect to MySQL, SQLite, Oracle and PostgreSQL databases at the same time with a single program, allowing you to manage different types of databases. The database is more convenient.

1. Software that needs to be prepared

1.Navicat premium 32-bit

Official download address: http://www.navicat.com.cn/products/navicat-premium

2.Instant Client12.1.0.2.0 32-bit

Instant Client is a streamlined version of the client launched by Oracle.

32-bit download address: http://www.oracle.com/technetwork/topics/winsoft-085727.html

Note: Regardless of your Whether Navicat is 32-bit or 64-bit, your Instant Client must download the 32-bit version, because Navicat only supports 32-bit clients.

2. Installation and configuration

1. Unzip Instant Client to

F:\gome\instantclient_12_1

2. Configure Navicat premium’s oci

Navicat Premium comes with default instantclient_10_2, but it is the base lite version (Basic Lite: a streamlined version of Basic, which only has English error messages and Unicode, ASCII and Western European character set support), does not support Chinese character sets, and the server-side oracle in this article It happens to be a Chinese character set, instantclient_10_2 is not suitable, so you need to download the base version.

Set the OCI library in Navicat Premium to F:/gome/instantclient_12_1/oci.dll, and then restart to take effect.

3. Connect to Oracle

1. Open Navicat Premium, click on the connection to select Oracle

##2. Fill in the connection information

There are two connection types for oracle in Navicat Premium: Basic and TNS.

In Basic mode, connect to Oracle through Oracle Call Interface (OCI). OCI is an application programming interface that allows program developers to use native processes or function calls in third-generation languages ​​to access Oracle databases and control the execution stages of all SQL statements. OCI is a standard database access library and dynamic link library form retrieval functions. Basic mode requires entering the host name or IP address, port and service name or SID.

In TNS mode, you need to use the alias entry in the tnsnames.ora file to connect to the Oracle server through the Oracle Call Interface (OCI). In TNS mode, you only need to select the network service name, but you need to create a new tnsnames.ora and configure the database service before.

It is recommended to use the more concise Basic mode, which can save complex tnsnames configuration. This article uses Basic mode.

In the "New Connection" interface shown below, enter the connection name, connection type, host name or IP address, port, service name or SID, user name and password, and click OK to connect to the database.

Click on the connection test, it will prompt that the test is successful, proving that the connection is successful!

3. Problem summary

The above describes the situation when the connection is smooth. During the connection steps, we also encountered some problems. Let’s summarize these problems:

1. Problem 1: ORA-12737: Instant Client Light: unsupported server character set ZHS16GBK

This problem is caused by directly using the instantclient_10_2 that comes with Navicat. The one that comes with it is the Basic Lite version of instantclient.

Basic Lite: A stripped-down version of Basic with only English error messages and Unicode, ASCII, and Western European character set support

Basic: Runs OCI, OCCI, and JDBC -All files required by OCI applications, including Chinese character sets. The solution is to change to the Basic version of instantclient.

2. Question 2: only compatible with oci vers and higherion 8.1 and higher

When connecting to local oracle, there is generally no problem. Both sqlplus and oci come with local Oracle. (Settings: Tools->Options->oci) are:

oci: D:\app\pcman\product\11.2.0\dbhome_1\ BIN\oci.dll

Sqlplus: D:\app\pcman\product\11.2.0\dbhome_1\BIN\sqlplus.exe.

If you are connecting to a remote server, make sure that the local and remote Oracle versions are consistent. If it is 11g, use 11g to prevent problems caused by mismatch between sqlplus and oci. In addition, Navicat seems to only be able to use 32-bit oci. , you can download it from here (http://www.oracle.com/technetwork/topics/winsoft-085727.html.)

3. Question 3: Cannot load OCI DLL,193

This is caused by the inconsistent version of Navicat and Navicat Premium, because Navicat Premium only supports 32-bit Instant Client. Check whether the one you downloaded is a 32-bit Instant Client.

Recommended tutorial: "Oracle Tutorial"

The above is the detailed content of Navicat connects to Oracle database (graphic tutorial). For more information, please follow other related articles on the PHP Chinese website!