rlwrap,找回原来的那个SQL*Plus-优快云博客

本文介绍如何使用rlwrap工具改善Linux环境下SQLPlus的用户体验。首先从GitHub获取rlwrap源码并部署到服务器，解决依赖问题后进行编译安装。通过配置.bash_profile文件，使SQLPlus和RMAN命令通过rlwrap运行，实现命令历史记录等功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

如果你无法忍受linux下SQLPlus的蹩脚，就赶快拥抱 rlwrap吧！
去GitHub下载最新版本
https://github.com/hanslub42/rlwrap/releases

上传到Server上解压
[root@db01 ~]# tar -xzvf rlwrap-0.43.tar.gz
...

[root@db01 rlwrap-0.43]# ./configure; make install

...

如果出现如下错误：
configure: checking for pty ranges...
checking for tgetent... no
checking for tgetent in -ltinfo... yes
checking for readline in -lreadline... no
configure: error:
You need the GNU readline library(ftp://ftp.gnu.org/gnu/readline/ ) to build
this program!

你一定是缺少这个包： readline-devel
因为 rlwrap="readline wrapper"

[root@db01 rlwrap-0.43]# yum install readline
Package readline-6.2-9.el7.x86_64 already installed and latest version
Nothing to do
[root@db01 rlwrap-0.43]# yum install readline*
Package readline-6.2-9.el7.x86_64 already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package readline-devel.x86_64 0:6.2-9.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
readline-devel x86_64 6.2-9.el7 local 138 k

Transaction Summary
================================================================================
Install 1 Package

Total download size: 138 k
Installed size: 259 k
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : readline-devel-6.2-9.el7.x86_64 1/1
Verifying : readline-devel-6.2-9.el7.x86_64 1/1

Installed:
readline-devel.x86_64 0:6.2-9.el7

Complete!

[root@db01 rlwrap-0.43]# rpm -qa | grep readline
readline-6.2-9.el7.x86_64
readline-devel-6.2-9.el7.x86_64

再次安装，顺利通过
[root@db01 rlwrap-0.43]# ./configure; make install

最后，编辑 /home/oracle/.bash_profile，添加两行：
alias sqlplus="rlwrap sqlplus"
alias rman="rlwrap rman"

重新登录oracle用户，熟悉的SQLPlus回来了~~

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12707874/viewspace-2140168/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12707874/viewspace-2140168/