Using rlwrap to get command history of Oracle sqlplus and RMAN


These are what I’m using:

  • VMware Workstation 5.5
    host: Windows XP
    guest: Red Hat Advanced Server 2.1
    using Shared folder to exchange data between host and guest.
  • Oracle 9i

By default, Oracle sqlplus and RMAN don’t have command history under Linux OS. You have to type the same command over and over again. But you can use rlwrap to get command history for sqlplus and RMAN. Follow these steps:

  1. Download rlwrap (use browser downloader, cannot use download software).
  2. Extract the .tar.gz file.
  3. Login as root user.
  4. From root home, run the configure file.
    [root@eric root]# /mnt/hgfs/Share/rlwrap-0.30/configure
    [root@eric root]# make install
  5. now you can connect to sqlplus and RMAN using rlwrap:
    $ rlwrap sqlplus / as sysdba
    $ rlwrap rman target /
  6. Now you can use your previous command history by pressing up or down arrow.

Have fun…

One response to “Using rlwrap to get command history of Oracle sqlplus and RMAN”

  1. linuxindetails says :

    Nice tutorial

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: