oracle 数据库连接显示？？？？

最新推荐文章于 2022-05-08 11:53:48 发布

原创最新推荐文章于 2022-05-08 11:53:48 发布 · 647 阅读

1 ·

CC 4.0 BY-SA版权

其它专栏收录该内容

12 篇文章

订阅专栏

本文介绍如何在 Oracle Database 12c 中配置使用简体中文环境，并通过设置 NLS_LANG 参数来实现 SQL*Plus 输出的中文显示。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[oracle@SVR-29-151 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Wed Jan 10 17:44:18 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
???:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> select userenv('language') from dual;

USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.AL32UTF8
SQL> exit
? Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production ??
[oracle@SVR-29-151 ~]$
[oracle@SVR-29-151 ~]$ export NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"
[oracle@SVR-29-151 ~]$ echo $NLS_LANG
SIMPLIFIED CHINESE_CHINA.AL32UTF8
[oracle@SVR-29-151 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on 星期三 1月 10 17:45:58 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
连接到:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> exit
从 Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production 断开
[oracle@SVR-29-151 ~]$
[oracle@SVR-29-151 ~]$ vi .bash_profile ###永久生效
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH
# Oracle Settings
export TMP=/tmp
export TMPDIR=$TMP

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.2.0.1/db_1
export ORACLE_SID=orcl

export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

".bash_profile" 26L, 645C 已写入
[oracle@SVR-29-151 ~]$
[oracle@SVR-29-151 ~]$
[oracle@SVR-29-151 ~]$
[oracle@SVR-29-151 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on 星期三 1月 10 17:46:43 2018

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

连接到:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production