CentOS Modified Oracle Character Set

1. First log in as Sysdba conn/as SYSDBA
2. Close the database shutdown immediate;
3. Use mount to hit the database, startup mount
4. Set session
Sql>alter SYSTEM ENABLE RESTRICTED SESSION;
sql> ALTER SYSTEM SET job_queue_processes=0;
sql> ALTER SYSTEM SET aq_tm_processes=0;
5. Start the database
ALTER DATABASE open;
6. Modifying the character Set
ALTER DATABASE Character Set Internal_use ZHS16GBK;
The help provided by Internal_use causes Oracle to bypass the validation of subsets and superset, which is exactly the same as the internal operation of the statement above.
7. Shutdown, restart
Sql>shutdown immediate;
Sql> Startup

CentOS Modified Oracle Character Set