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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- SD卡被格式化後如何找回原來的影片SD卡
- rlwrap安裝
- matlab原來不但好用,還那麼好玩,Matlab
- 1.3.2. 關於SQL*PlusSQL
- 那個NB的中國移動,又回來了?
- 原來我就是那個以戰術勤奮掩蓋戰略懶惰的人啊。。。
- SQL*Plus Set引數詳解SQL
- 原來那個騷擾電話是AI打的!315晚會曝光的這“鍋”AI背不背?AI
- mybatis-plus匯入sql日誌MyBatisSQL
- 那個做出《鯉》的團隊,帶著新遊戲來了遊戲
- Angular等了三年,那個她已經來了Angular
- RabbitMQ 處理過慢,原來是一個 SQL 快取框架導致的 GC 頻繁觸發MQSQL快取框架GC
- 1.3.3.5.1. SQL*Plus 連線命令語法SQL
- 1.3.3.4. 步驟3:啟動SQL*PlusSQL
- 3.1.1.1 使用 SQL*Plus 啟動資料庫SQL資料庫
- Mybatis-plus核心功能-自定義SQLMyBatisSQL
- 前端如何用密文跟後端互通?原來那麼簡單!前端後端
- [20190108]rlwrap sqlplus tee相關問題.txtSQL
- Mybatis-Plus的應用場景及注入SQL原理分析MyBatisSQL
- 這 3 個 Set 集合的實現有點簡單,那來做個總結吧
- 那個從「四大」出來的小哥哥,後來怎麼樣了|ONES 人物
- 那個被大家用來用去的Ceph,終於成立了基金會
- 【小豬佩奇漫畫】| 複雜度分析原來那麼簡單!複雜度
- 14 個 SQL 拿來就用語句例項!SQL
- 終於找回這個部落格了
- 回憶裡的那個人……
- 1.3.3.1. 關於連線資料庫的SQL*Plus 工具描述資料庫SQL
- update誤操作後 通過undo記錄的scn找回原紀錄
- 1.3.3. 通過SQL*Plus 連線資料庫SQL資料庫
- 一個 MySQL sql 語句執行順序帶來的 bugMySql
- Dapper原來還可以直接這樣寫SQL,很強大哦APPSQL
- 我把Linux系統上面誤刪的資料找回來了Linux
- [20190110]rlwrap sqlplus tee相關問題3.txtSQL
- [20200309]rlwrap: error: Cannot execute sqlplus: Too many levels of symbolic linErrorSQLSymbol
- 誤刪了電腦資料怎麼找回來?
- [20190401]那個更快的疑問.txt
- 揪出那個無主鍵的表
- springboot+druid+mybatis plus的多資料來源配置Spring BootUIMyBatis
- 多資料來源結合mybatis-plus的使用MyBatis