Oracle sqlplus快捷键、上下键、删除键

Linux中安装完Oracle后，默认的 sqlplus 上下键是不能用的，安装了 rlwrap 之后就能通过上下键翻回历史命令了

1、下载地址

https://github.com/hanslub42/rlwrap/releases

2、安装依赖

yum install -y readline*

3、上传包、解压、编译安装

[root@zfb-jhdsj-sjkserver9 rlwrap-0.30]# ./configure && make && make install

编译安装报错：
[root@zfb-jhdsj-sjkserver9 rlwrap-0.30]# ./configure && make && make install
checking build system type... Invalid configuration `x86_64-unknown-linux-': machine `x86_64-unknown-linux' not recognized
configure: error: /bin/sh tools/config.sub x86_64-unknown-linux- failed

更新下gcc，重新编译安装即可
[root@zfb-jhdsj-sjkserver9 rlwrap-0.30]# yum -y install gcc gcc-c++

4、配置shell以及快捷键

cat  >>  /home/oracle/.bash_profile << "EOF"
alias sql='sqlplus / as sysdba'
alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'
alias lsnrctl='rlwrap lsnrctl'
alias asmcmd='rlwrap asmcmd'
EOF

6、刷新下

source /home/oracle/.bash_profile

完成