转:http://www.blogjava.net/coundy/archive/2011/06/18/352577.html
关于navicat连接oracle 报 ORA-12737 set CHS16GBK错误的解决
参考资料: http://apps.hi.baidu.com/share/detail/32733067
1、原因:
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
2、首先,我们打开“tools”-->"options"菜单,见到如下界面,依据OCI library(oci.dll) 路径,导航到 navicat oci 目录下,备份里面的文件(通过在该目录新建bak文件夹,将“%dir%/Navicat Lite\instantclient_10_2”路径下的所有dll文件剪切到bak文件夹)。
3、在oracle 客户端安装目录bin/目录下,找到如下几个.dll文件
4、将上面所列文件放置到“%dir%/Navicat Lite\instantclient_10_2” 目录下,重新启动navcat即可。
1、原因:
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
2、首先,我们打开“tools”-->"options"菜单,见到如下界面,依据OCI library(oci.dll) 路径,导航到 navicat oci 目录下,备份里面的文件(通过在该目录新建bak文件夹,将“%dir%/Navicat Lite\instantclient_10_2”路径下的所有dll文件剪切到bak文件夹)。
3、在oracle 客户端安装目录bin/目录下,找到如下几个.dll文件
4、将上面所列文件放置到“%dir%/Navicat Lite\instantclient_10_2” 目录下,重新启动navcat即可。