Oracle Character Set modification ____oracle

1. View Oracle Encoding command

Select Userenv (' language ') Nls_lang from dual;

2. The Change Order is as follows

sql> Conn/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 ZHS16GBK; (or Al32utf8)
Ora-12712:new Character set must is a superset of old character set
Tip Our Character set: The new character set must be a superset of the old character set, at which point we can skip the check of the superset to make changes:
Sql> ALTER DATABASE Character set Internal_use ZHS16GBK;
--we see that this process is exactly the same as the internal process of an ALTER DATABASE CHARACTER set operation, meaning that the help that Internal_use provides is that the Oracle database bypasses the checksum of subsets and superset.
sql> shutdown immediate;

Sql> Startup

3.cmd in garbled

CMD appears in Chinese garbled, temporarily can use the command: Set nls_lang=simplified Chinese_china. ZHS16GBK can temporarily solve the problem