centos7 修改oracle的字符集
查询oracle服务端的字符集:
select userenv('language') from dual;
修改:
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;#AMERICAN_AMERICA.AL32UTF8
shutdown immediate;
startup
在oracle环境变量中修改客户端字符集:
NLS_LANG:INTERNAL_USE ZHS16GBK
AMERICAN_AMERICA.AL32UTF8,INTERNAL_USE AL32UTF8;
export NLS_LANG=en_US.AL32UTF8