rlwrap可以在SQL plus里进行上下键翻命令，和windows一样
1、首先安装readline
# wget ftp://ftp.gnu.org/gnu/readline/readline-6.2.tar.gz
# tar -xzvf readline-6.2.tar.gz
# cd readline-6.2
# ./configure
# make
# make install
# wget ftp://ftp.gnu.org/gnu/readline/readline-6.2.tar.gz
# tar -xzvf readline-6.2.tar.gz
# cd readline-6.2
# ./configure
# make
# make install
2、安装rlwrap
#wget http://utopia.knoware.nl/~hlub/uck/rlwrap/rlwrap-0.42.tar.gz
# tar -xzvf rlwrap-0.42
# cd rlwrap-0.42
# ./configure
#wget http://utopia.knoware.nl/~hlub/uck/rlwrap/rlwrap-0.42.tar.gz
# tar -xzvf rlwrap-0.42
# cd rlwrap-0.42
# ./configure
configure: error:
You need the GNU readline library(ftp://ftp.gnu.org/gnu/readline/ ) to build
this program!
You need the GNU readline library(ftp://ftp.gnu.org/gnu/readline/ ) to build
this program!
解决办法：
安装这个包
安装这个包
# yum install libtermcap-devel
下面继续安装rlwrap
# make
# make
# make install
3、 .bash_profile中进行设置。
alias sqlplus='/usr/local/bin/rlwrap sqlplus'
alias rman='/usr/local/bin/rlwrap rman'
alias sqlplus='/usr/local/bin/rlwrap sqlplus'
alias rman='/usr/local/bin/rlwrap rman'
4、修改一下
[root@localhost readline-6.2]# cp /etc/ld.so.conf /etc/ld.so.conf.bak
[root@localhost readline-6.2]# vi /etc/ld.so.conf
添加一行
[root@localhost readline-6.2]# cp /etc/ld.so.conf /etc/ld.so.conf.bak
[root@localhost readline-6.2]# vi /etc/ld.so.conf
添加一行
/usr/local/lib
5、使得生效
[root@localhost readline-6.2]# ldconfig
[root@localhost readline-6.2]# ldconfig
6、验证
[root@localhost readline-6.2]# su - oracle
[oracle@localhost ~]$ sqlplus
[root@localhost readline-6.2]# su - oracle
[oracle@localhost ~]$ sqlplus
SQL*Plus: Release 12.2.0.1.0 Production on Tue May 1 04:13:00 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31536355/viewspace-2154853/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
linux配置主机名
下一篇：
oracle审计
请登录后发表评论
登录
全部评论
