Linux下安装完Oracle 11g后使用sqlplus出现乱码解决

2014-11-24 18:14:20 · 作者: · 浏览: 0

[oracle@localhost ~]$ rlwrap sqlplus / as sysdba


SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 23 15:25:02 2013


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



:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL> alter user hr identified by sys123;
alter user hr identified by sys123
*
1 :
ORA-01109:
SQL> startup
ORA-01081: ORACLE -
SQL> alter database mount;
alter database mount
*
1 :
ORA-01102: EXCLUSIVE


解决方法:


我使用的是secureCRT软件,可以在optios(字符)——session options下的terminal(终端)下的education(仿真)中把terminal(终端)一栏改为‘linux’把appearance(外观)——character encoding(字符编码)一栏,选择default,normal fonts(字体)选择新宋体,应该是没问题的!
如果不是,就是字符设置的问题!


上面是在secureCRT下的乱码现象!!!如果是终端如下的乱码问题



解决办法:修改终端的编码格式



修改后退出sqlplus重新登陆一下就没问题了