linux下oralce更改字符集，发现乱码问题，一查发现所装的oracle不是中文字符集，更改之。。。

?

查询当前的字符集

select userenv('language') from dual; 

?

修改为zhs16gbk字符集

conn / as sysdba;  
shutdown immediate;  
startup mount;  
alter system enable restricted session ;  
alter system set JOB_QUEUE_PROCESSES=0;  
alter system set AQ_TM_PROCESSES=0;  
alter database open;  
alter database character set internal_use zhs16gbk;  
shutdown immediate;  
startup;