-- SQL commands
shutdown immediate;
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 internal_use UTF8;
shutdown immediate;
startup;

-- check result
select * from nls_database_parameters
where PARAMETER='NLS_CHARACTERSET';

10g改字符集