linux 修改oracle字符集

--进入sqlplus
sqlplus / as sysdba
--  关闭数据库 
SHUTDOWN IMMEDIATE
-- 启动到Mount 
 STARTUP MOUNT; 
ALTER SYSTEM ENABLE RESTRICTED SESSION; 
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; 
ALTER SYSTEM SET AQ_TM_PROCESSES=0; 
ALTER DATABASE OPEN; 
ALTER DATABASE CHARACTER SET al32utf8;  --- ZHS16GBK
--这里可能会报错，提示我们的字符集：新字符集必须为旧字符集的超集，这时我们可以跳过超集的检查做更改
ALTER DATABASE CHARACTER SET internal_use al32utf8;
--重启
SHUTDOWN IMMEDIATE; 
STARTUP;