PLSQL developer远程连接Oracle

时间:2022-11-27 07:43:27

Database character set (AL32UTF8) and Client character set (ZHS16GBK) are different.
Character set conversion may cause unexpected results.

Note: you can set the client character set through the NLS_LANG environment variable or the NLS_LANG registry key in
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraClient11g_home2.


在安装PLSQLdeveloper的主机上安装oracle实例,下载一个orcale的instantclient_11_2包,复制安装的oracel的tnsnames.ora到里面,修改Host为oracel所在主机的IP;

修改系统变量path,添加instantclient_11_2的位置,新建NLS_LANG值为:SIMPLIFIED CHINESE_CHINA.AL32UTF8

修改注册表:

打开注册表,‘开始’-‘运行’ 输入‘regedit’-确定。


找到提示中给出的路径,


找到 NLS_LANG 键,他的值原来是:SIMPLIFIED CHINESE_CHINA.ZHS16GBK


修改为:SIMPLIFIED CHINESE_CHINA.AL32UTF8


重新打开plsql ,登录,好了。