查看字符集SQL:
select * from v$nls_parameters;
更改为UTF-8:
sqlplus /nolog
conn / as sysdba
SHUTDOWN IMMEDIATE;
STARTUP MOUNT EXCLUSIVE;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE UTF8;
SHUTDOWN immediate;
startup;
![](https://i-blog.csdnimg.cn/blog_migrate/079229074246cb571afea2d2fa6fd724.png)
![](https://i-blog.csdnimg.cn/blog_migrate/50d18d603bc2035767cab310d12e1c98.png)
更改为ZHS16GBK:
![](https://i-blog.csdnimg.cn/blog_migrate/4d32d5e02a914089f156c9c34c75b515.png)
sqlplus /nolog
conn /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 ZHS16GBK;
SHUTDOWN IMMEDIATE;
STARTUP