Add Rlwrap to Sqlplus and Rman under CentOS

In Linux Sqlplus and Rman are unable to use the arrow keys and BACKSPACE to wake up some changes to the statement as we do in the shell.

This is really a very distressing thing. But there are rlwrap to Sqlplus and Rman to do some expansion, so that my operation is not so hard to force. Here's how to install Rlwarp in CENTOS6. 1. Installing Readline-develShell>su-rootShell>yum Install Readline-devel 2. Download RlwrapFind the latest Rlwrap source package in http://utopia.knoware.nl/~hlub/uck/rlwrap/Shell> wgethttp://utopia.knoware.nl/~hlub/uck/rlwrap/rlwrap-0.41.tar.gz3. Unzip the build installationshell> tar zxvfRlwrap-0.41.tar.gzshell>./configureShell>make & make install
 4. If the above steps are not error-free, we can add rlwrap support for Sqlplus, the following example for Oracle users Shell>su-oracle
    Shell>vim ~/.bash_profile    For Sqlplus andRman adds Rlwrap support and adds the following in Bash_profile    Alias sqlp= ' Rlwrap sqlplus ' Alias rman= ' Rlwrap Rman ' 5. Re-login with Oracle This user, or we apply. Bash_profile, use SQLP and Rman again to find out which direction to use     Keys and BACKSPACE keys. Two ways to apply. Bash_profile Shell>./.bash_profileShell>source. Bash_profile

Add Rlwrap to Sqlplus and Rman under CentOS