以DBA身份進(jìn)入SQLPLUS

SQL> sqlplus sys/sys as sysdba;

……

SQL> shutdown immediate;
SQL> startup mount;
SQL> alter system enable restricted session;
SQL> alter system set job_queue_PRocesses=0;
SQL> alter system set aq_tm_processes=0;

SQL> alter database open;
SQL> alter database character set internal_use AL32UTF8;(ZHS16GBK)
SQL> shutdown immediate;
SQL> startup;

這樣就可以講Oracle的字符集修改為UTF8，如果需要修改為GBK只需將alter database character set internal_use AL32UTF8;(ZHS16GBK)這句最后的AL32UTF8修改為ZHS16GBK即可。