Oracle 10g字符编码

pl/sql developer查询数据时出现乱码，主要检查如下：

 select * from v$nls_parameters;

 select * from nls_database_parameters;

select userenv('language') from dual;  

 select * from v$nls_valid_values; 

参照/home/oracle/.bash_profile 相关语言设置 系统环境变量加入

LANG=zh_CN.GBK  
NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK

sql> conn user/password as sysdba;
sql> shutdown immediate;database closed.database dismounted.oracle instance shut down.
sql> startup mount;oracle instance started.total system global area 135337420 bytesfixed size 452044 bytesvariable size 109051904 bytesdatabase buffers 25165824 bytesredo buffers 667648 bytesdatabase mounted.
sql> alter system enable restricted session;system altered.
sql> alter system set job_queue_processes=0;system altered.
sql> alter system set aq_tm_processes=0;system altered.
sql> alter database open;database altered.
sql> alter database character set internal_use ZHS16GBK;(可以设置: UTF8\AL32UTF8\ZHS16GBK )，注意跟上面的统一，全部统一UTF-8也是可以的
sql> shutdown immediate;
sql> startup;