快上网专注成都网站设计 成都网站制作 成都网站建设
成都网站建设公司服务热线:028-86922220

网站建设知识

十年网站开发经验 + 多家企业客户 + 靠谱的建站团队

量身定制 + 运营维护+专业推广+无忧售后,网站问题一站解决

rlwrap,找回原来的那个SQL*Plus-创新互联

如果你无法忍受linux下SQLPlus的蹩脚,就赶快拥抱rlwrap吧!
去GitHub下载最新版本
https://github.com/hanslub42/rlwrap/releases
rlwrap,找回原来的那个SQL*Plus
上传到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回来了~~

分享名称:rlwrap,找回原来的那个SQL*Plus-创新互联
分享链接:http://6mz.cn/article/cspjgh.html

其他资讯