linux上更改oralce字符集

linux下更改oralce字符集

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;