linux oracle 中文乱码解决方案

linux oracle 中文乱码解决方案

su - oracle

cd /home/oracle

1.查看客户端编码

env |grep LANG

2.修改客户端编码

vi  .bash_profile

修改/加入如下配置：

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

source .bash_profile

env |grep LANG

3.查看数据库默认语言

sqlplus / as sysdba

select userenv('language') from dual;

例如：AMERICAN_AMERICA.WE8MSWIN1252

4.修改数据库默认语言

shutdown immediate;

startup mount;

alter system enable restricted session;

alter system set job_queue_processes=0;

alter database open;

alter database character set internal_use AL32UTF8;  或者  ALTER DATABASE character set INTERNAL_USE ZHS16GBK;

shutdown immediate;

startup;

alter system disable restricted session;

select userenv('language') from dual;