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"菜单,见到如下界面,依据OCI library(oci.dll) 路径,导航到 navicat oci 目录下,备份里面的文件(通过在该目录新建bak文件夹,将“%dir%/Navicat Liteinstantclient_10_2”路径下的所有dll文件剪切到bak文件夹)。
去Oracle客户端目录下面(..oracleproduct10.2.0client_1BIN)将以下七个dll拷贝到%dir%/Navicat Liteinstantclient_10_2下面
-----------------------------------------------------------------------
oci.dll
orannzsbb10.dll
oraocci10.dll
oraocr10.dll
后面的四个好像可以不要
oraociicus10.dll(这个由navicat生成的,在%dir%/Navicat Liteinstantclient_10_2)
oraocrb10.dll
oraocrutl10.dll
-----------------------------------------------------------------------
重新启动navcat即可。
以上参考文献:http://blog.sina.com.cn/s/blog_6598c683010178nv.html
如果还出现oci初始化环境失败:"cannot create oci environment",请以管理员运行navicat!