centos7上oracle数据存储乱码

参考:https://blog.youkuaiyun.com/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

start