Solaris的sqlplus history功能实现rlwrap

You may consider to use rlwrap for comfortable wor with sqlplus. Package for Solaris 10 (x86) release you can download . Note rlwrap is dependent on readline library which should be installed first. readline library package.

su -
# gunzip readline-5.1-solaris-x86.gz
# gunzip rlwrap-solaris-x86.gz
# pkgadd -d readline-5.1-solaris-x86 rlwrap-solaris-x86
# exit
echo "alias sqlplus='/usr/local/bin/rlwrap sqlplus'" >> /export/home/oracle/.bash_profile
. /export/home/oracle/.bash_profile
=================
bash-3.00# /usr/local/bin/rlwrap
ld.so.1: rlwrap: fatal: libreadline.so.5: open failed: No such file or directory
Killed

安装完成以后验证，报错，执行如下两条命令：
bash-3.00# cp /usr/local/lib/libreadline* /lib
bash-3.00# cp /usr/local/lib/libreadline* /usr/lib/

bash-3.00# /usr/local/bin/rlwrap
Usage: rlwrap [options] command ...

Options:
  -a              --always-readline[=password:]
  -b                  --break_chars=
  -c                         --complete-filenames
  -C                 --command-name=
  -f        --file=
  -h                         --help
  -H                   --history-filename=
  -i                         --case-insensitive
  -l                   --logfile=
  -n                         --no-warnings
  -P                  --pre-given=
  -m     --multi-line[=newline substitute]
  -r                         --remember
  -v                         --version
  -s                      --histsize= (negative: readonly)

bug reports, suggestions, updates:
~hlub/uck/rlwrap/
bash-3.00#

-----------到oracle用户下添加到环境变量---------
alias sqlplus='/usr/local/bin/rlwrap sqlplus'