Home > Developer > Oracle

Navicat Connecting to Oracle database will error

Source: Internet
Author: User
Tags unsupported
Developer on Alibaba Coud: Build your first app with APIs, SDKs, and tutorials on the Alibaba Cloud. Read more ＞
NAVICAT Direct Connect Oracle Database error ORA-12737 Instant Client light:unsupported Server character set ZHS16GBK use Navicat to connect to Oracle database today reported the following error: "ORA-12737 Instant client light:unsupported server character set ZHS16GBK" From this error, you can know that the client does not support the server-side character set caused by, But modifying the server-side character set is unrealistic, so 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 can be found 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\ The following files are found under 11.1.0\db_1\bin:

The replacement is 4. After restarting the Navicat replacement file, restart Navicat is required and a new version of OCI can be applied after a reboot.

Navicat Connecting to Oracle database will error

This article is an English version of an article which is originally in the Chinese language on aliyun.com and is provided for information purposes only. This website makes no representation or warranty of any kind, either expressed or implied, as to the accuracy, completeness ownership or reliability of the article or any translations thereof. If you have any concerns or complaints relating to the article, please send an email, providing a detailed description of the concern or complaint, to info-contact@alibabacloud.com. A staff member will contact you within 5 working days. Once verified, infringing content will be removed immediately.

Related Keywords:
error connecting to mysql connecting website to database error connecting to mysql fix connecting to mysql database in php oracle database error logs navicat export database verification failed error connecting to apple id server
Related Article
Oracle SQL Tuning Database optimization steps Graphic tutorial

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.

What's Trending
Top 10 Tags
datastax versions naming convention zookeeper client class definition md5 microsoft sql server 2005 data structures exception handling error handling
Top 10 Keywords
microsoft download center down wordpress address url site address url wordpress address url windows installer 4 0 download 302 not found web address url definition site address url wordpress db2 integer mac os installation step by step pdf abbreviation for return

A Free Trial That Lets You Build Big!

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

Get Started for Free

  • Sales Support

    1 on 1 presale consultation

    Chat Contact Sales

  • After-Sales Support

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

    Open a Ticket

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

    Learn More