Linux下oracle显示乱码解决
1.登录oracle用户，登录dba,显示乱码？？？# su - oracle
$ sqlplus / as sysdba
SQL*Plus:> Copyright (c) 1982, 2005, Oracle.All rights reserved.
???:
Oracle Database 10g Enterprise Edition> With the Partitioning, OLAP and Data Mining options
SQL> exit
$ echo $NLS_LANG //查看当前语言，返回为空
$ pwd
/home/oracle
$ cat .bash_profile//查看bash_profile文件
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
unset USERNAME
ORACLE_BASE=/u01/app/oracle
export ORACLE_BASE
ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export ORACLE_HOME
ORACLE_SID=jiagulun
export ORACLE_SID
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
$ vi .bash_profile //编号并添加如下2行：
export LANG=en_US.UTF-8
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
$ exit //退出再登录oracle用户
logout
# su - oracle
$ sqlplus/ as sysdba//显示正常无???
SQL*Plus:> Copyright (c) 1982, 2005, Oracle.All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition> With the Partitioning, OLAP and Data Mining options
SQL> show user;
USER is "SYS"
页:
[1]