oracle11g 修改字元集 修改為ZHS16GBK

1.cmd下,cd到oracle資料庫軟體的伺服器端 如：D:\app\Administrator\product\11.2.0\dbhome_1\BIN

2.輸入set ORACLE_SID=你想進入的資料庫的那個sid

3.輸入 sqlplus /nolog

4.将資料庫啟動到RESTRICTED模式下做字元集更改： 

SQL> conn /as sysdba 

Connected. 

SQL> shutdown immediate; 

Database closed. 

Database dismounted. 

ORACLE instance shut down. 

SQL> startup mount 

ORACLE instance started. 

Total System Global Area  236000356 bytes 

Fixed Size                   451684 bytes 

Variable Size             201326592 bytes 

Database Buffers           33554432 bytes 

Redo Buffers                 667648 bytes 

Database mounted. 

SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION; 

System altered. 

SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; 

SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0; 

SQL> alter database open; 

Database altered. 

SQL> ALTER DATABASE CHARACTER SET ZHS16GBK; 

ALTER DATABASE CHARACTER SET ZHS16GBK 

* 

ERROR at line 1: 

ORA-12712: new character set must be a superset of old character set 

提示我們的字元集：新字元集必須為舊字元集的超集，這時我們可以跳過超集的檢查做更改： 

SQL> ALTER DATABASE character set INTERNAL_USE ZHS16GBK; 

SQL> select * from v$nls_parameters; 

略 

19 rows selected. 

重新開機檢查是否更改完成： 

SQL> startup 

Database opened.