windows下sqlplus提示信息乱码处理

在windows下提示信息乱码，信息如下：

C:\Users\Administrator>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on ╨╟╞┌╥╗ 4╘┬ 28 09:55:47 2014
Copyright (c) 1982, 2010, Oracle.  All rights reserved.
┴¼╜╙╡╜:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
SQL>

检查数据库字符集

SQL> select * from nls_database_parameters where parameter in ('NLS_LANGUAGE','N
LS_CHARACTERSET');
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_LANGUAGE
AMERICAN

NLS_CHARACTERSET
ZHS16GBK

检查系统NLS_LANG参数 ->运行regedit进入注册表

处理：在进入sqlplus前，运行

C:\Users\Administrator>set NLS_LANG=AMERICAN

在进入sqlplus提示信息正常

C:\Users\Administrator>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon Apr 28 09:59:20 2014

Copyright (c) 1982, 2010, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

SQL>
SQL> select * from v$aaa;
select * from v$aaa
              *
ERROR at line 1:
ORA-00942: table or view does not exist

也可以修改注册表，是NLS_LANG与数据库中值保持一致。