Oracle使用SQLPLUS命令回调与上下左右键的时候乱码解决

  rlwrap是一个“readline包装器”，它使用GNU readline库来允许编辑其他任何命令的键盘输入，每次调用时都会记住输入历史记录，每个命令分别记录一次，可以通过上下键获取指定的bash或命令的历史记录。

1. CentOS 6系统

[root@yun156 softwares]# yum -y install readline*
[root@yun156 softwares]# wget http://rpmfind.net/linux/epel/6/x86_64/Packages/r/rlwrap-0.42-1.el6.x86_64.rpm
[root@yun156 softwares]# rpm -ivh rlwrap-0.42-1.el6.x86_64.rpm
[oracle@yun156 ~]$ vim ~/.bash_profile
#For sqlplus 
alias sqlplus='rlwrap sqlplus' 
alias rman='rlwrap rman'
[oracle@yun156 ~]$ source ~/.bash_profile

2. CentOS 7系统

[root@dbtest ~]# yum -y install readline*
[root@dbtest ~]# cd /home/softwares/
[root@dbtest softwares]# wget http://rpmfind.net/linux/epel/7/x86_64/Packages/r/rlwrap-0.42-1.el7.x86_64.rpm

或者wget ftp://ftp.pbone.net/mirror/ftp5.gwdg.de/pub/opensuse/repositories/home:/Ledest:/misc/CentOS_7/x86_64/rlwrap-0.42-1.1.x86_64.rpm

[root@dbtest softwares]# rpm -ivh rlwrap-0.42-1.el7.x86_64.rpmerror: Failed dependencies:    perl(Data::Dumper) is needed by rlwrap-0.42-1.el7.x86_64
[root@dbtest softwares]# yum -y install autoconf
[root@dbtest softwares]# rpm -ivh rlwrap-0.42-1.el7.x86_64.rpm
Preparing...                          ################################# [100%]
Updating / installing...
   1:rlwrap-0.42-1.el7                ################################# [100%]
[oracle@dbtest ~]$ vim ~/.bash_profile
#For sqlplus
alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'
[oracle@dbtest ~]$ source ~/.bash_profile

3. Oracle使用SQLPLUS回车键^H问题

[oracle@yun156 ~]$ vim ~/.bash_profile
#backspace
stty erase ^H
[oracle@yun156 ~]$ source ~/.bash_profile