oracle11g 修改字符集 修改为ZHS16GBK

1.cmd下,cd到oracle数据库软件的服务器端如：D:\DevSofts\Oracle\app\oracle\product\11.2.0\server\bin

2.输入set ORACLE_SID=你想进入的数据库的那个sid

3.输入 sqlplus /nolog

4.将数据库启动到RESTRICTED模式下做字符集更改：

SQL>conn/as sysdba

Connected.

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 201326592bytes

Database Buffers 33554432bytes

Redo Buffers 667648 bytes

Database mounted.

SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;

System altered.

ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

ALTER SYSTEM SET AQ_TM_PROCESSES=0;

alter database open;

Database altered.

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 characterset

提示我们的字符集：新字符集必须为旧字符集的超集，这时我们可以跳过超集的检查做更改：ALTER DATABASE character set INTERNAL_USE ZHS16GBK;

SQL>select * from v$nls_parameters;

略

19 rows selected.

重启检查是否更改完成：startup

Database mounted.

Database opened.

select* from v$nls_parameters;