rlwrap,找回原來的那個SQL*Plus
如果你無法忍受linux下SQLPlus的蹩腳,就趕快擁抱rlwrap吧!
去GitHub下載最新版本
上傳到Server上解壓
[root@db01 ~]# tar -xzvf rlwrap-0.43.tar.gz
...
去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回來了~~
如果出現如下錯誤:
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- rlwrap sqlplus in linuxSQLLinux
- 【rlwrap】Linux上實現Windows的SQL*Plus儲存SQL歷史記錄功能LinuxWindowsSQL
- 代替uniread的另外一個支援SQL Plus命令回顯的小程式:rlwrap,只有24KBSQL
- Linux上實現Windows的SQL*Plus儲存SQL歷史記錄功能---rlwrap(轉)LinuxWindowsSQL
- rlwrap sqlplus下的回顯工具SQL
- rlwrap的安裝使用 [SQLPlus上下鍵]SQL
- SD卡被格式化後如何找回原來的影片SD卡
- rlwrap - 支援oracle下sqlplus歷史命令的回撥功能OracleSQL
- rlwrap實現sqlplus環境 方向鍵等使用SQL
- rlwrap 的安裝使用(實現sqlplus下命令列history編輯)SQL命令列
- 蘋果iPhone 6s plus丟失怎麼找回蘋果6被偷如何定位找回蘋果iPhone
- 使用sql*plus時的一個安全小問題SQL
- 安裝rlwrap(解決Sqlplus 方向鍵出現亂碼)SQL
- linux下sqlplus調出歷史命令--rlwrap介紹LinuxSQL
- 常用的sql*plus命令:SQL
- 【SQL*Plus】使用SQL*Plus的Preliminary方式連線資料庫SQL資料庫
- 【SQL*Plus】使用SQL*Plus的-S選項精簡輸出資訊SQL
- 使用SQL*PlusSQL
- plustrce.sql的作用SQL
- SQL/PLUS命令的使用大全SQL
- SQL*PLUS命令的使用大全SQL
- 設定sql plus 的autotraceSQL
- 【SQL*Plus】處理 SQL*Plus的標頭無法顯示問題SQL
- 【rlwrap】讓rlwrap工具更加的生動有趣——快捷鍵的嘗試
- 桌面程式刪除了,如何找回來
- 那個做出《鯉》的團隊,帶著新遊戲來了遊戲
- rlwrap 是一個好東西 for linuxLinux
- 調優: 一個SQL現在30分鐘,而原來只要2秒SQL
- 【sqlplus】SQL*Plus命令使用大全SQL
- SQL*Plus安全(一)SQL
- SQL*Plus安全(二)SQL
- SQL*PLUS安全(三)SQL
- SQL*PLUS安全(四)SQL
- SQL*Plus Substitution VariablesSQL
- set autotrace in SQL*PlusSQL
- sql*plus入門SQL
- 原來那個騷擾電話是AI打的!315晚會曝光的這“鍋”AI背不背?AI
- 【SQL*Plus】直接X掉視窗對SQL*Plus中的操作結果的影響SQL