Linux 修改Oracle数据库字符集实例，oracle字符集

Linux 修改Oracle数据库字符集实例，oracle字符集

1.在SQL*PLUS 中，以DBA登录

conn / as sysdba

>shutdown immediate; (把database停了)  
>startup mount; (把database重开去可更改情況)  
>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 utf8;  
  或者  
>alter database character set internal_use utf8;  
  或者  
>alter database character set internal_use ZHS16GBK ;      
>shutdown immediate;  
>startup; (重开正常oracle)  
  
>select userenv('language') from dual;  
  
常见的Oracle字符集有ZHS16GBK、AL32UTF8、US7ASCII等。