方法一:
sql / as sysdba
shutdown immediate;
startup mount;
alter session set sql_trace=ture;
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;
alter session set sql_trace=false;
shutdown immediate;;
startup;
方法二:
sql / as sysdba
shutdown immediate;
startup;
update props$ set VALUE$='UTF8' where NAME='NLS_NCHAR_CHARACTERSET';
原文博客:https://blog.csdn.net/liu__________/article/details/51542516