Yesterday download installed Navicat 9.0 Premium (Advanced English edition), connect MySQL normal, see He also support Oracle, SQLite and PostgreSQL, also want to connect Oracle, for centralized management.
1, but the connection is first reported a listening error, unable to resolve the Oracle SID identifier, I use Sqlplus and plsql connection is normal ... This indicates that my configuration file is not a problem.
2, reconnect the way from TNS to Basic, then fill in the connection information sequentially, but finally burst the "ora-12737:instant Client light:unsupported Server character set CHS16GBK" error.
3, to determine the character set is a problem, Google found a similar solution:
Ora-12737:instant Client light:unsupported Server character Set CHS16GBK
Google, explained as follows:
ORA-12737:
Instant Client light:unsupported Server Character Set string
Cause:the Character set specified is isn't allowed for this operation or is invalid. Instant Client Light has only minimal character sets.
Action:do not with Instant Client Light for this character set
4, after the reason is clear, how to solve. Modifying the server's character set is not realistic. Later I studied OCI, knowing that instance Client 10 does not support encodings other than English (if you download the Chinese version of Navicat you may not have this problem).
5, to the Oracle website download the latest version of the oci:http://www.oracle.com/technetwork/topics/winsoft-085727.html
6, at the same time on the Oracle online found instance Client 11 is much larger than 10, download the completion of the decompression of the core of the Oci11 3 files to replace the original oci10 3 files. (Remember to make a backup)
Replacement method: In Navicat, the tool-> option->MISCELLANEOUS->OCI. Re-specify the location for the Oci.dll, and then restart the navicat to be OK.
Reboot Navicat finally proves that instance Client 11 does not have a character set problem.
Ps:
This is the XP SP3 system, and Oracle is the 10.2,navicat 9.0 Premium 中文版 version.
At the same time thanks to netizens Gloomsky case sharing: http://hi.baidu.com/%F2%A9%F1%FC%E4%EB%E4%A7/blog/item/87f00e547468f9113b293570.html
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.
