1. 查看字符集
select userenv(‘language‘) from dual;
2. 修改字符集(逐条执行即可)
sqlplus "/as sysdba";
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 AL32UTF8;
shutdown immediate;
startup;
至此修改成功。