oracle11g modifying the character set to ZHS16GBK

Ext.: http://www.cnblogs.com/jay-xu33/p/5210098.html

oracle11g modifying the character set to ZHS16GBK
1.cmd, CD to the server side of Oracle database software such as: D:\app\Administrator\product\11.2.0\dbhome_1\BIN

2. Enter set oracle_sid= the SID of the database you want to enter

3. Enter Sqlplus/nolog

4. Launch the database into restricted mode to make the character set changes:

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;

System altered.

sql> ALTER SYSTEM SET aq_tm_processes=0;

System altered.

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 the old character set

Hint to our character set: The new character set must be a superset of the old character set, and we can skip over the superset check to make the change:

Sql> ALTER DATABASE Character set Internal_use ZHS16GBK;

Database altered.

Sql> select * from V$nls_parameters;

Slightly

Rows selected.

Reboot checks for changes to complete:

sql> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

Sql> Startup

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.

Database opened.

Sql> select * from V$nls_parameters;

oracle11g Modify the character set to ZHS16GBK