Solutions for Navicat connection to Oracle reporting ORA-12737 set CHS16GBK errors

Download and install navicat 9.0 Premium (Advanced English version) and connect to mysql normally. We can see that it supports both Oracle, sqlite and postgresql, and want to connect to oracle for centralized management.

1. However, a listener error is reported during connection and the oracle SID identifier cannot be parsed. It is normal for me to connect with sqlplus and plsql !!! This indicates that my configuration file is correct.

2. Change the connection mode from TNS to BASIC again, and then fill in the connection information in sequence, but finally broke the error of "ORA-12737: Instant Client Light: unsupported server character set CHS16GBK.

3. After determining the character set problem, google found a similar solution:

ORA-12737: Instant Client Light: unsupported server character set CHS16GBK
Google:
ORA-12737:
Instant Client Light: unsupported server character set string
Cause: The character set specified is not allowed for this operation or is invalid. Instant Client Light has only minimal character sets.
Action: Do not use Instant Client Light for this character set

4. What should I do after the reason is clear. It is unrealistic to modify the server character set. Later I studied OCI and learned that Instance Client 10 does not support code other than English (if you download the Chinese version of navicat, this problem may not occur ).
5. Go to oracle official website to download the latest version of OCI: http://www.oracle.com/technetwork/topics/winsoft-085727.html
6. At the same time, we found that Instance Client 11 is much larger than 10 on the Oracle official website, after the download is complete, replace the three files of the extracted core oci11 with the three files of the original oci10. (Remember to make a backup)
Solution: In Navicat, choose tools> Options> Miscellaneous> OCI. Specify the location for oci. dll and restart navicat.
Restarting Navicat finally proves that Instance Client 11 has no character set problem.

 


 

PS: The local xp SP3 system, Oracle 10.2, navicat 9.0 Premium English version.

1 2 Next Page