Linux下安裝完Oracle 11g後使用sqlplus出現如下亂碼解決
[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重新登陸一下就沒問題了