SQLPLUS 提示信息一直是英文

Question

  我系统的当前环境如下：
   1.
  
[root@localhost ~]# cat /etc/sysconfig/i18n
LANG="zh_CN.UTF-8"
SYSFONT="lat0-sun16"
[root@localhost ~]#2.ORACLE用户下的NLS_LANG设置：
  
[oracle@localhost ~]$ env | grep NLS
NLS_LANG=simplified chinese_china.zhs16gbk
3.oracle参数配置：SQL> show parameter nls;NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_calendar                         string
nls_comp                             string
nls_currency                         string
nls_date_format                      string      yyyy-mm-dd hh24:mi:ss
nls_date_language                    string
nls_dual_currency                    string
nls_iso_currency                     string
nls_language                         string      SIMPLIFIED CHINESE
nls_length_semantics                 string      BYTE
nls_nchar_conv_excp                  string      FALSE
nls_numeric_characters               stringNAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_sort                             string
nls_territory                        string      CHINA
  
SQL> select userenv('language') from dual;USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBKSQL>
   现在我SQLPLUS下的提示信息还是英文 我还应该设置点什么才能让我的提示符成中文啊

Answer 1

#export NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
#sqlplus /nologsql>这样子进去之后，还是英文？

Answer 2

环境变量生效了吗？$export NLS_LANG="simplified chinese_china.zhs16gbk"
$source .profle 试试..

Answer 3

[oracle@localhost ~]$ echo $NLS_LANG
SIMPLIFIED CHINESE_CHINA.ZHS16GBK
[oracle@localhost ~]$ sqlplus eht/product@htdzSQL*Plus: Release 10.2.0.1.0 - Production on 星期四 4月 1 10:32:27 2010Copyright (c) 1982, 2005, Oracle.  All rights reserved.
连接到: 
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> select areaid from area where rownum<=10;    AREAID
----------
         1
         2
         3
         4
         5
         6
         7
         8
         9
        10已选择10行。SQL> exit
从 Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开
[oracle@localhost ~]$ export  NLS_LANG=american_america.ZHS16GBK
[oracle@localhost ~]$ echo $NLS_LANG
american_america.ZHS16GBK
[oracle@localhost ~]$ sqlplus eht/product@htdzSQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 1 10:33:09 2010Copyright (c) 1982, 2005, Oracle.  All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> select areaid from area where rownum<=10;    AREAID
----------
         1
         2
         3
         4
         5
         6
         7
         8
         9
        1010 rows selected.SQL> 
RedHat Linux AS 4.0你首先要搞清楚，你的LINUX系统是否安装中文语言包。

Answer 4

[oracle@localhost ~]$ locale
locale: Cannot set LC_CTYPE to default locale: No such file or directory
locale: Cannot set LC_MESSAGES to default locale: No such file or directory
locale: Cannot set LC_ALL to default locale: No such file or directory
LANG=simplified chinese_china.zhs16gbk
LC_CTYPE=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
LC_NUMERIC="simplified chinese_china.zhs16gbk"
LC_TIME="simplified chinese_china.zhs16gbk"
LC_COLLATE="simplified chinese_china.zhs16gbk"
LC_MONETARY="simplified chinese_china.zhs16gbk"
LC_MESSAGES="simplified chinese_china.zhs16gbk"
LC_PAPER="simplified chinese_china.zhs16gbk"
LC_NAME="simplified chinese_china.zhs16gbk"
LC_ADDRESS="simplified chinese_china.zhs16gbk"
LC_TELEPHONE="simplified chinese_china.zhs16gbk"
LC_MEASUREMENT="simplified chinese_china.zhs16gbk"
LC_IDENTIFICATION="simplified chinese_china.zhs16gbk"
LC_ALL=