rlwrap,找回原來的那個SQL*Plus

hai503發表於2017-06-01
如果你無法忍受linux下SQLPlus的蹩腳,就趕快擁抱rlwrap吧!
去GitHub下載最新版本



上傳到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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章