参考:https://blog.csdn.net/zhbzhbzhbbaby/article/details/81355580
1. 查看oracle服务端的字符集
(1) 登录
sqlplus /nolog
conn /as sysdba
(2) 查看字符集
select userenv('language') from dual;
2. 查看oracle客户端的字符集
echo $NLS_LANG
3. 修改oracle服务端的字符集
(1) 登录
sqlplus /nolog
conn /as sysdba
(2) 启动RESTRICTED模式
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