昨天下载安装了navicat 9.0 Premium(高级英文版),连接mysql正常,看到他同时支持oracle、sqlite和postgresql,也想来连接一下oracle,进行集中管理。 1、但是连接时候先是报出监听错误、不能解析oracle SID标识符,我用sqlplus和plsql连接却是正常的!!!这说明我的配置文件是没有问题的。 2、重新将连接方式由TNS改为BASIC,然后依次填写连接信息,最后却爆出了“ORA-12737: Instant Client Light: unsupported server character set CHS16GBK”的错误。 3、确定是字符集问题后,google上查到类似的解决方案:
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