oracle 英文都乱码了~~~~~~~~~~~~~~~

Question

今天下午新建了个实例. 结果提示都变成乱码了. 求问各位大神那里的问题啊?
效果如下.

Answer 1

是不是字符集的问题？
客户端查看注册表nls_lang.

Answer 2

我的系统是centOS.... 要在哪看啊？

Answer 3

不对啊~ 一直没改过 .bash_profile 之前好好的.

Answer 4

select userenv('language') from dual
SQL> select * from v$nls_parameters;
 
 
PARAMETER                                                        VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
NLS_LANGUAGE                                                     SIMPLIFIED CHINESE
NLS_TERRITORY                                                    CHINA
NLS_CURRENCY                                                     RMB
NLS_ISO_CURRENCY                                                 CHINA
NLS_NUMERIC_CHARACTERS                                           .,
NLS_CALENDAR                                                     GREGORIAN
NLS_DATE_FORMAT                                                  DD-MON-YY
NLS_DATE_LANGUAGE                                                SIMPLIFIED CHINESE
NLS_CHARACTERSET                                                 ZHS16GBK
NLS_SORT                                                         BINARY
NLS_TIME_FORMAT                                                  HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT                                             DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT                                               HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT                                          DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY                                                RMB
NLS_NCHAR_CHARACTERSET                                           AL16UTF16
NLS_COMP                                                         BINARY
NLS_LENGTH_SEMANTICS                                             BYTE
NLS_NCHAR_CONV_EXCP                                              FALSE
 
19 rows selected
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK

Answer 5

SQL> select * from v$nls_parameters;PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_LANGUAGE
SIMPLIFIED CHINESENLS_TERRITORY
CHINANLS_CURRENCY
?
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_ISO_CURRENCY
CHINANLS_NUMERIC_CHARACTERS
.,NLS_CALENDAR
GREGORIAN
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_DATE_FORMAT
DD-MON-RRNLS_DATE_LANGUAGE
SIMPLIFIED CHINESENLS_CHARACTERSET
AL32UTF8
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_SORT
BINARYNLS_TIME_FORMAT
HH.MI.SSXFF AMNLS_TIMESTAMP_FORMAT
DD-MON-RR HH.MI.SSXFF AM
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_TIME_TZ_FORMAT
HH.MI.SSXFF AM TZRNLS_TIMESTAMP_TZ_FORMAT
DD-MON-RR HH.MI.SSXFF AM TZRNLS_DUAL_CURRENCY
?
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_NCHAR_CHARACTERSET
AL16UTF16NLS_COMP
BINARYNLS_LENGTH_SEMANTICS
BYTE
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_NCHAR_CONV_EXCP
FALSE
???19??

Answer 6

SQL> select * from v$nls_parameters;PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_LANGUAGE
SIMPLIFIED CHINESENLS_TERRITORY
CHINANLS_CURRENCY
?
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_ISO_CURRENCY
CHINANLS_NUMERIC_CHARACTERS
.,NLS_CALENDAR
GREGORIAN
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_DATE_FORMAT
DD-MON-RRNLS_DATE_LANGUAGE
SIMPLIFIED CHINESENLS_CHARACTERSET
AL32UTF8
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_SORT
BINARYNLS_TIME_FORMAT
HH.MI.SSXFF AMNLS_TIMESTAMP_FORMAT
DD-MON-RR HH.MI.SSXFF AM
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_TIME_TZ_FORMAT
HH.MI.SSXFF AM TZRNLS_TIMESTAMP_TZ_FORMAT
DD-MON-RR HH.MI.SSXFF AM TZRNLS_DUAL_CURRENCY
?
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_NCHAR_CHARACTERSET
AL16UTF16NLS_COMP
BINARYNLS_LENGTH_SEMANTICS
BYTE
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_NCHAR_CONV_EXCP
FALSE
???19??

Answer 7

SQL> select userenv('language') from dual;USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.AL32UTF8

Answer 8

对linux下修改客户端字符集不熟悉，帮你搜索的关于linux下修改客户端字符集方法：sudo gedit /etc/environment  在environment 文件中增加以下内容： NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8" export NLS_LANG  重新启动操作系统即可。或者尝试在windows系统下连接，修改注册表项：
HKEY_LOCAL_MACHINE/SOFTWARE/Oracle/HOME0
nls_lang＝SIMPLIFIED CHINESE_CHINA.AL32UTF8若还存在乱码，不妨尝试把nls_lang修改为AMERICAN_AMERICA.AL32UTF8试试.

Answer 9

NLS_NCHAR_CHARACTERSET                                           AL16UTF16这个参数能改吗？

Answer 10

 select * from NLS_DATABASE_PARAMETERS;