您好,登錄后才能下訂單哦!
1.登錄oracle用戶,登錄dba,顯示亂碼???
[root@redhat4 ~]# su - oracle
[oracle@redhat4 ~]$ 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
[oracle@redhat4 ~]$ echo $NLS_LANG //查看當(dāng)前語(yǔ)言,返回為空
[oracle@redhat4 ~]$ pwd
/home/oracle
[oracle@redhat4 ~]$ 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
[oracle@redhat4 ~]$ vi .bash_profile //編號(hào)并添加如下2行:
export LANG=en_US.UTF-8
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
[oracle@redhat4 ~]$ exit //退出再登錄oracle用戶
logout
[root@redhat4 ~]# su - oracle
[oracle@redhat4 ~]$ sqlplus / as sysdba //顯示正常無(wú)???
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"
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。