Navicat Connect Oracle Error: ORA-12737 Instant Client light:unsupported server character Set ZHS16GBK

Today, using Navicat to connect to the Oracle database, the following error was reported: "ORA-12737 Instant Client light:unsupported server character Set ZHS16GBK"

From this error, it can be known that the client does not support the server-side character set caused, but to modify the server-side character set is not realistic, we can only find the reason from the client. We know that Navicat connected to Oracle using the OCI mode, and I installed Navicat Premium using the OCI Instant Client 10 is not supported in addition to the English character set, Therefore, replacing the DLL file of the OCI used by Navicat can solve this problem.

1.Navicat OCI Reference Location

You can find it from the Navicat menu bar "Tools"-"Options"-"OCI" as shown in:

Files replaced by 2.Navicat

3.ORACLE new version of DLL file

I have the Oracle Enterprise full version of the database, so it contains the DLL files required to connect the Oracle client, so in my native Oracle directory: D:\ProgramFiles\Oracle\product\11.1.0\db_1\BIN

The following files are found:

Replaced with a can

4. Restart Navicat

After you replace the file, you need to restart the navicat and then restart to apply the new version of OCI.

Navicat Connect Oracle Error: ORA-12737 Instant Client light:unsupported server character Set ZHS16GBK