Linux下oracle顯示亂碼解決

標籤：oracle   linux   使用者   

1.登入oracle使用者，登入dba,顯示亂碼？？？

[[email protected] ~]# su - oracle

[[email protected] ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 22 18:27:40 2014

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

???: 

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

SQL> exit

[[email protected] ~]$ echo $NLS_LANG //查看當前語言，返回為空白

[[email protected] ~]$ pwd

/home/oracle  

[[email protected] ~]$ 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

[[email protected] ~]$ vi .bash_profile   //編號並添加如下2行：

export LANG=en_US.UTF-8

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

[[email protected] ~]$ exit //退出再登入oracle使用者

logout

[[email protected] ~]# su - oracle

[[email protected] ~]$ sqlplus  / as sysdba  //顯示正常無???

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 22 18:33:14 2014

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

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

SQL> show user;

USER is "SYS"

本文出自 “放開去博、活出精彩！” 部落格，請務必保留此出處http://ibmcn.blog.51cto.com/510174/1441865

Linux下oracle顯示亂碼解決