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

Oracle uses the sqlplus tool, which is very inconvenient. Now it is convenient and practical to use the rlwrap tool to realize the historical command of switching between the up and down keys.

First, install the required packages

Yum install ncurses-devel-y

Yum install readline-devel-y

2. Decompression and installation

Tar-zxvf rlwrap-0.42.tar.gz

Cd rlwrap-0.42/

. / configure

Configure succeeds if the following prompt appears:

Now do:

Make (or gmake) to build rlwrap

Make check for instructions how to test it

Make install to install it

Make

Make check

Make install

# which rlwrap

/ usr/local/bin/rlwrap

3. Edit user environment variables

Switch to the oracle user and add the following to the .bash _ profile file

Su-oracle

Vim / .bash_profile

Alias sqlplus='rlwrap sqlplus'

Alias rman='rlwrap rman'

Make the configuration effective

Source / .bash_profile

Connect to the database: sqlplus "/ as sysdba"

Can be used immediately

Switch to the grid user and add the following to the .bash _ profile file

Su-grid

Vim / .bash_profile

Alias asmcmd='rlwrap asmcmd'

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.