oracle11g changing the character set Al32utf8 to ZHS16GBK
When the original installation of Oracle selected by default installation, the result character set is not used in the 16GBK, to change the character set, from the Internet to find a method and try it, sure enough!
Specific as follows:
Sign in to SQL Plus
The commands in SQL Puls are as follows:
Sql> Conn/as SYSDBA
is connected.
sql> shutdown immediate;
The database is closed.
The database has been uninstalled.
Sql> Startup Mount
The Oracle routine has been started.
...... ..................
..............................
The database is loaded.
sql> ALTER SYSTEM ENABLE RESTRICTED SESSION;
The system has changed.
sql> ALTER SYSTEM SET job_queue_processes=0;
The system has changed.
sql> ALTER SYSTEM SET aq_tm_processes=0;
The system has changed.
sql> ALTER DATABASE open;
The database has changed.
sql> ALTER DATABASE CHARACTER SET ZHS16GBK;
An error occurred on line 1th:
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;
The database has changed.
--we see that this process is identical to the internal procedure of the ALTER DATABASE CHARACTER set operation, which means that the help provided by Internal_use is to get the Oracle database to bypass the checksum of the subset and the superset.
Sql> select * from V$nls_parameters;
Rarameter
VALUE
Nas_language
Simplified Chinese
Nls_territory
China
......
sql> shutdown immediate;
Sql> Startup
ORA-01081:??????? ORACLE-??????? This means that you cannot start a running Oracle, please close it first
Sql> select * from V$nls_parameters;
At this point, the modification of the character set is complete, we can verify by the input command, the result has become ZHS16GBK.
Sql> Select Userenv (' language ') from dual;
It seems that in the future when installing oracle11g, it is best to choose a custom installation, the character set of things in advance.
Oracle 11g modified Character set Al32utf8 to ZHS16GBK