- The people who are accustomed to the key fallback history input in Linux must also hope to achieve the same effect in sqlplus, but unfortunately, Sqlplus does not provide many convenient shortcuts, this time we need to install another plugin to implement this idea.
- This plugin is called: rlwrap
- Go to Rlwrap's official website to download this plugin: http://utopia.knoware.nl/~hlub/uck/rlwrap/
- After downloading, unzip the operation Tar-zxf rlwrap-0.41.tar.gz
- Unzip to get rlwrap this folder, into which.
- Give configure the right to empower
# chmod +x Configure
- After the empowerment:
#./configure
- This time the configuration is unsuccessful: Hint: Rlwrap installation error You need the GNU readline ...
Rlwrap The installation of this program, need to rely on two packages, one is: ReadLine one is: Libtermcap-devel Workaround: cd/media/rhel_5.5x86_64 dvd/serverrpm-IVH readline-5.1-3. el5.i386.rpm--nodeps rpm-IVH readline-5.1-3. el5.x86_64.rpm--nodepsrpm-IVH readline-devel-5.1-3. el5.i386.rpm--nodepsrpm-IVH readline-devel-5.1-3. el5.x86_64.rpm--nodepsrpm-IVH libtermcap-2.0.8-46.1. i386.rpm--nodepsrpm-IVH libtermcap-2.0.8-46.1. x86_64.rpm--nodepsrpm-IVH libtermcap-devel-2.0.8-46.1. i386.rpm--nodepsrpm-IVH libtermcap-devel-2.0.8-46.1. x86_64.rpm--Nodeps After the installation is complete, go back to the Rlwrap installation program to install it!
- Execute again./configure
configure:creating./config.statusconfig.status:creating Makefileconfig.status:creating filters/ Makefileconfig.status:creating Doc/Makefileconfig.status:creating src/makefileconfig.status: Creating Doc/is does: Make (or gmake) to build Rlwrap make Check For instructions what to test it make install to install it
- This result occurs, which executes:
# Make && make install
- So we can use Rlwrap.
- $ rlwrap Sqlplus/as SYSDBA
- If you need to input rlwrap every time feel trouble, you can also add to the. Bash_profile, you do not have to enter each time
VI. Bash_profile writes the following: alias sqlplus='rlwrap sqlplus'alias Rman=' rlwrap rman'
Solve the problem that the back key display ^h, the upper and lower keys are invalid and the ctrl+l cannot clear the screen under the Linux Oracle entering Sqlplus environment "Weber Produce must be a boutique"