Rlwrap, find the old SQL*Plus.
If you can't stand the crappy SQLPlus under linux, hug rlwrap quickly!
Download the latest version from GitHub
Https://github.com/hanslub42/rlwrap/releases
Upload it to Server for decompression
[root@db01 ~] # tar-xzvf rlwrap-0.43.tar.gz
...
[root@db01 rlwrap-0.43] #. / configure; make install
...
If the following error occurs:
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!
You must be missing this bag: readline-devel
Because 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 0RU 6.2-9.el7 will be installed
-> Finished Dependency Resolution
Dependencies Resolved
=
Package Arch Version Repository Size
=
Installing:
Readline-devel x86 million 64 6.2-9.el7 local 138k
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 Compact 1
Verifying: readline-devel-6.2-9.el7.x86_64 1 Compact 1
Installed:
Readline-devel.x86_64 0RO 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
Install again and pass smoothly
[root@db01 rlwrap-0.43] #. / configure; make install
Finally, edit / home/oracle/.bash_profile and add two lines:
Alias sqlplus= "rlwrap sqlplus"
Alias rman= "rlwrap rman"
Log in to the oracle user again, and the familiar SQLPlus is back ~ ~
