Rlwrap can be used to support the callback function of sqlplus History commands in Oracle to improve efficiency. When installing rlwrap, you are prompted to install readline and use yuminstallreadline. 1. Download
Rlwrap can be used to support the callback function of sqlplus History commands in Oracle to improve efficiency.
When installing rlwrap, you are prompted to install readline
Use yum install readline.
1. Download
Free onHttp://linux.linuxidc.com/
Both the user name and password areWww.linuxidc.com
The specific download directory is in/Pub/2011/07/04/rlwrap/
Download rlwrap-0.37.tar.gz and upload it
/Tmp directory.
2. decompress and install
[Root @ localhosttmp] # tar-zxvf rlwrap-0.37.tar.gz
[Root @ localhosttmp] # rlwrap-0.37 cd
[Root@localhostrlwrap-0.37] # ls
[Root@localhostrlwrap-0.37] #./configure
# Make
[Root@localhostrlwrap-0.37] # make install
3. Verify the installation result
[Root @ localhost rlwrap-0.37] # su-oracle
[Oracle @ localhost ~] $ Rlwrap
Usage: rlwrap [options] command...
Options:
-A [password:] -- always-readline [= password:]
-A -- ansi-color-aware
[Oracle @ localhost ~] $ Rlwrap sqlplus/as sysdba;
SQL * Plus: Release 10.1.0.3.0-Production on ?? Listen 9? 3 12:49:42 2010
Copyright (c) 1982,200 4, Oracle. All rights reserved.
Connected:
Oracle Database 10g EnterpriseEdition Release 10.1.0.3.0-Production
With the Partitioning, OLAP and DataMining options
SQL> select status fromv $ instance;
STATUS
------------
OPEN
4. Installation Error
Rlwrap: error while loadingshared libraries: libreadline. so.5: cannot open shared object file: No suchfile or directory
Solution:
Add the/usr/local/bin PATH to $ PATH in. bash_profile in oracle.
PATH =/usr/local/bin: $ PATH; export PATH
5. Edit. bash_profile under the oracle user
Add
Alias sqlplus = 'maid sqlplus'
Alias rman = 'rlwrap rman'