Rlwrap resolving garbled issues with Oracle Sqlplus in Linux context switching

" This article declined to reprint Original from http://990487026.blog.51cto.com"

Rlwrap Official website:

http://utopia.knoware.nl/~hlub/uck/rlwrap/

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M02/86/A7/wKioL1fGkiTC9ymmAAClyF2GjdY178.png "title=" linux_ Sqlplus000.png "alt=" Wkiol1fgkitc9ymmaaclyf2gjdy178.png "/>

Let's get to work!

System Properties:

CentOS 6.8_x64, desktop-based, additional developer kit installation.

download source, compile, install:

[[Email protected] ~]$ mkdir /tmp/mytest[[email protected] ~]$ cd /tmp /mytest[[email protected] mytest]$ wget http://utopia.knoware.nl/~hlub/uck/rlwrap/ Rlwrap-0.42.tar.gz[[email protected] mytest]$ echo $?0[[email protected] mytest] $ tar xf rlwrap-0.42.tar.gz [[email protected] mytest]$ cd rlwrap-0.42 [[Email protected] rlwrap-0.42]$ ./configure you need the gnu readline  library (ftp://ftp.gnu.org/gnu/readline/ )  to buildthis program! [[email protected] rlwrap-0.42]$ echo $?1 prompts me to lack readline library, switch to root [[email  PROTECTED] ~]# YUM INSTALL -Y READLINE-DEVEL[[EMAIL PROTECTED] RLWRAP-0.42] $ ./CONFIGURE [[EMAIL PROTECTED] RLWRAP-0.42]$ ECHO $?0 compilation environment Check through! So long to start compiling it: [[email  protected] rlwrap-0.42]$ Make[[email protected] rlwrap-0.42]$ echo $?0root permissions to install [[email protected] ~]#  cd /tmp/mytest/rlwrap-0.42[[email protected] rlwrap-0.42]# make install [[ Email protected] rlwrap-0.42]# echo $?0

Test:

[[Email protected] rlwrap-0.42]# rlwrap usage: rlwrap [options] command &NBSP, ..... options:  -a[password prompt]        --always-readline[ =password prompt]  -a                          --ansi-colour-aware  - b  <chars>                 --break-chars=<chars>  -c                          -- complete-filenames  -c  <name| N>               --command-name= <name| N>  -d  <0|1|2>                --history-no-dupes=<0|1|2>   -e  <char| " >              -- Extra-char-after-completion=<char| " >  -f  <completion list>      --file=< completion list>  -g  <regexp>                --forget-matching=<regexp>  -h                           --help  -H  <file>                  --history-filename=<file>  - I                         --case-insensitive  -i                           --pass-sigint-as-sigterm  -l  <file>                  --logfile=<file>   -m[newline substitute]     --multi-line[=newline substitute]   -M  <.ext>                  --multi-line-ext=<.ext>  -n                           --no-warnings  -N                          --no-children  -o                           --one-shot  -O  <regexp>                --only-cook=<regexp>  -p[colour]                  --prompt-colour[=colour]   -P  <input>                 --pre-given=<input>  -q  <chars>                 --quote-characters=< chars>  -r                          --remember  -r                          --renice   -s  <N>                     --histsize=<N>  (negative: readonly)   -s   <prompt>                --substitute-prompt=<prompt>  -t  <name>                  --set-term-name=<name>   -U                          --mirror-arguments  -v                           --version   -w  <N>                     --wait-before-prompt=<N>  (msec, <0   : patient mode)   -W                          --polling   -z  <filter command>       --filter=<filter  command>  (-z listing lists installed filters) bug reports,  suggestions, updates:http://utopia.knoware.nl/~hlub/uck/rlwrap/

To set an alias:

[[email protected] rlwrap-0.42]$ echo "Alias sqlplus= ' Rlwrap sqlplus '" >>/home/oracle/.bashrc[[email protected] rlwrap-0.42]$ Cd[[email protected] ~]$ source. BASHRC

Test my top and bottom keys:

[Email protected] ~]$ sqlplus/nologsql*plus:release 11.2.0.1.0 Production on Wed 16:08:43 2016Copyright (c) 1982  , and Oracle. All rights reserved. Sql> Conn/as sysdbaconnected to an idle instance. Sql> sql> Conn as Sysdba

Up and down key back

650) this.width=650; "src=" Http://s5.51cto.com/wyfs02/M00/86/A7/wKioL1fGkxOxOKBFAABhhlU2P_w505.png "title=" linux_ Sqlplus.png "alt=" Wkiol1fgkxoxokbfaabhhlu2p_w505.png "/>

This article from "Soul Bucket Luo" blog, declined reprint!

Rlwrap resolving garbled issues with Oracle Sqlplus in Linux context switching