oracle字符集修改

1. make sure parallel_server = false.

2. shutdown database
   do a full database backup
3.
SQLPLUS> STARTUP MOUNT;
SQLPLUS> ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQLPLUS> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQLPLUS> ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SQLPLUS> ALTER DATABASE OPEN;
SQLPLUS> ALTER DATABASE [NATIONAL] CHARACTER SET INTERNAL_USE [INTERNAL_CONVERT] <new_character_set>;
SQLPLUS> SHUTDOWN IMMEDIATE; -- OR NORMAL
SQLPLUS> STARTUP RESTRICT;

4. shutdown database
   startup db