Oracle查询中文乱码

1.查询Oracle服务端字符集

SQL> select userenv('language') from dual ;

USERENV('LANGUAGE')
--------------------------------------------------------------------------------
AMERICAN_AMERICA.AL32UTF8

　2.设置Oracle客户端字符集

export NLS_LANG=AMERICAN_AMERICA.UTF8

3.设置操作系统字符集

vi /etc/sysconfig/i18n

LANG="zh_CN.UTF-8"

source /etc/sysconfi/i18n