Use Rlwrap to implement sqlplus up and down keys to scroll through the Lost Oracle history commands

Beginner Oracle the students may be in Linux under Use SecureCRT to connect to the server, using the Sqlplus It is not possible to execute the command as entered before the call.

the same problem must have been met by the seniors, so it Google a moment, and found the Rlwrap This tool, let's take a look at it together:

Rlwrap : http://utopia.knoware.nl/~hlub/uck/rlwrap/#rlwrap

First, installation ReadLine Package

We can easily find packages that match our own version on the system's CD-ROM.

#rpm-qa| grep ReadLine

// first check if the system has been installed

#rpm-UVH readline-5.1-3.el5.i386.rpm

// Prompt to install readline-devel-5.1-3.el5.i386.rpm

#rpm-IVH readline-devel-5.1-3.el5.i386.rpm readline-5.1-3.el5.i386.rpm

Second, installation Rlwrap

download from the link above Rlwrap and put the bag in your system.

# TAR-ZVXF RLWRAP-0.37.TAR.GZ#CD Rlwrap-0.37#./configure#make#make install#vim/home/oracle/.bash_profile

Add the following two lines of aliases after you save the exit:

Alias sqlplus= ' Rlwrapsqlplus ' Alias rman= ' Rlwrap Rman '

Third, the use

$sqlplus/as sysdbasql>

OK, so now we can easily invoke the history command with the up and down keys.

Use Rlwrap to implement sqlplus up and down keys to scroll through the Lost Oracle history commands