Shulou(Shulou.com)06/02 Report--

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 ~ ~

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.