使用rlwarp包装Oracle命令工具sqlplus和rman

深藏阁楼爱情的钟 2022-12-24 00:55 205阅读 0赞

在Linux Shell环境中维护Oracle数据库经常使用sqlplus和rman命令，在sqlplus和rman命令环境中，不能记录历史执行的SQL命令，使用起来不太方便，借助rlwrap库可以实现sqlplus，rman记录历史执行的命令，使用上下方向键可以找出以前执行的命令，可以方便管理Oracle数据库。

rlwrap-0.37可从云盘地址下载  
链接：https://pan.baidu.com/s/1Ojbyabw3AZLld7Jh59XlEg  
提取码：0vcl

安装配置步骤如下：

## 1、配置Linux Yum环境 ##

可以直接使用Ali的yum源，根据你的Linux版本下载相应的Yum源配置  
CentOS 5  
wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-5.repo

CentOS 6  
wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-6.repo

CentOS 7  
wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo

## 2、解压rlwrap-0.37.zip ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FpeGlhbmdfY2hlbg_size_16_color_FFFFFF_t_70_pic_center]

## 3、使用yum安装readline库 ##

yum install readline\*  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FpeGlhbmdfY2hlbg_size_16_color_FFFFFF_t_70_pic_center 1]

## 4、编译rlwrap-0.37 ##

[root@localhost rlwrap-0.37]# ./configure
    checking build system type... x86_64-unknown-linux-gnu
    checking host system type... x86_64-unknown-linux-gnu
    checking for a BSD-compatible install... /usr/bin/install -c
    checking whether build environment is sane... yes
    checking for a thread-safe mkdir -p... /bin/mkdir -p
    checking for gawk... gawk
    checking whether make sets $(MAKE)... yes
    checking whether make sets $(MAKE)... (cached) yes
    checking whether build environment is sane... yes
    checking for style of include used by make... GNU
    checking for gcc... gcc
    checking for C compiler default output file name... a.out
    checking whether the C compiler works... yes
    checking whether we are cross compiling... no
    checking for suffix of executables... 
    checking for suffix of object files... o
    checking whether we are using the GNU C compiler... yes
    checking whether gcc accepts -g... yes
    checking for gcc option to accept ISO C89... none needed
    checking dependency style of gcc... gcc3
    checking how to run the C preprocessor... gcc -E
    checking for grep that handles long lines and -e... /bin/grep
    checking for egrep... /bin/grep -E
    checking for ANSI C header files... yes
    checking for sys/types.h... yes
    checking for sys/stat.h... yes
    checking for stdlib.h... yes
    checking for string.h... yes
    checking for memory.h... yes
    checking for strings.h... yes
    checking for inttypes.h... yes
    checking for stdint.h... yes
    checking for unistd.h... yes
    checking minix/config.h usability... no
    checking minix/config.h presence... no
    checking for minix/config.h... no
    checking whether it is safe to define __EXTENSIONS__... yes
    checking for gcc... (cached) gcc
    checking whether we are using the GNU C compiler... (cached) yes
    checking whether gcc accepts -g... (cached) yes
    checking for gcc option to accept ISO C89... (cached) none needed
    checking dependency style of gcc... (cached) gcc3
    checking how to run the C preprocessor... gcc -E
    checking for perl... /usr/bin/perl
    checking for strip... strip
    checking for ANSI C header files... (cached) yes
    checking for sys/wait.h that is POSIX.1 compatible... yes
    checking errno.h usability... yes
    checking errno.h presence... yes
    checking for errno.h... yes
    checking fcntl.h usability... yes
    checking fcntl.h presence... yes
    checking for fcntl.h... yes
    checking libutil.h usability... no
    checking libutil.h presence... no
    checking for libutil.h... no
    checking for stdlib.h... (cached) yes
    checking for string.h... (cached) yes
    checking sched.h usability... yes
    checking sched.h presence... yes
    checking for sched.h... yes
    checking sys/ioctl.h usability... yes
    checking sys/ioctl.h presence... yes
    checking for sys/ioctl.h... yes
    checking for sys/wait.h... (cached) yes
    checking sys/resource.h usability... yes
    checking sys/resource.h presence... yes
    checking for sys/resource.h... yes
    checking stddef.h usability... yes
    checking stddef.h presence... yes
    checking for stddef.h... yes
    checking termios.h usability... yes
    checking termios.h presence... yes
    checking for termios.h... yes
    checking for unistd.h... (cached) yes
    checking for stdint.h... (cached) yes
    checking time.h usability... yes
    checking time.h presence... yes
    checking for time.h... yes
    checking getopt.h usability... yes
    checking getopt.h presence... yes
    checking for getopt.h... yes
    checking regex.h usability... yes
    checking regex.h presence... yes
    checking for regex.h... yes
    checking curses.h usability... yes
    checking curses.h presence... yes
    checking for curses.h... yes
    checking termcap.h usability... yes
    checking termcap.h presence... yes
    checking for termcap.h... yes
    checking for term.h... yes
    checking for ncurses/term.h... yes
    checking argument type of tputs putc function... int
    checking whether your getopt() correctly understands double colons in option string... yes
    checking for an ANSI C-conforming const... yes
    checking for pid_t... yes
    checking whether time.h and sys/time.h may both be included... yes
    checking whether gcc needs -traditional... no
    checking return type of signal handlers... void
    checking for getopt_long... yes
    checking for getopt_long... (cached) yes
    checking for isastream... yes
    checking for mkstemp... yes
    checking for pselect... yes
    checking for putenv... yes
    checking for readlink... yes
    checking for sched_yield... yes
    checking for setenv... yes
    checking for setitimer... yes
    checking for setsid... yes
    checking for setrlimit... yes
    checking for sigaction... yes
    checking for snprintf... yes
    checking for strlcpy... no
    checking for strlcat... no
    checking for strnlen... yes
    checking for system... yes
    checking for openpty in -lutil... yes
    checking for openpty... yes
    checking for getpty... no
    checking for grantpt... yes
    checking for unlockpt... yes
    checking for getpt... yes
    checking for pty/tty type... checking pty.h usability... yes
    checking pty.h presence... yes
    checking for pty.h... yes
    OPENPTY
    configure: checking for pty ranges...
    checking for tgetent... no
    checking for tgetent in -lcurses... yes
    checking for readline in -lreadline... yes
    checking whether your readline headers know about rl_set_screen_size... yes
    checking whether your readline library knows about rl_set_screen_size... checking for rl_set_screen_size... yes
    checking whether your readline knows about rl_variable_value... yes
    checking whether your readline knows about rl_readline_version... yes
    Will rlwrap find command's working directory under /proc/<commands pid>/cwd? let's see...
    checking for /proc/7227/cwd/configure.ac... yes
    
    
    configure: creating ./config.status
    config.status: creating Makefile
    config.status: creating filters/Makefile
    config.status: creating doc/Makefile
    config.status: creating src/Makefile
    config.status: creating doc/rlwrap.man
    config.status: creating config.h
    config.status: executing depfiles commands
    
    Now do:
        make (or gmake)  to build rlwrap
        make check       for instructions how to test it
        make install     to install it
    
    [root@localhost rlwrap-0.37]#

编译安装

[root@localhost rlwrap-0.37]# make & make install
    [1] 9077
    make  all-recursive
    Making install in doc
    make[1]: Entering directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37' Making all in doc make[1]: Entering directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37/doc' sed -e 's#@DATADIR@#/usr/local/share#' rlwrap.man > rlwrap.1
    make[2]: Entering directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37/doc' sed -e 's#@DATADIR@#/usr/local/share#' rlwrap.man > rlwrap.1 make[2]: Leaving directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37/doc' Making all in src make[2]: Entering directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37/doc' make[2]: Nothing to be done for `install-exec-am'.
    test -z "/usr/local/share/man/man1" || /bin/mkdir -p "/usr/local/share/man/man1"
    make[2]: Entering directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37/src' gcc -DHAVE_CONFIG_H -I. -I.. -DDATADIR=\"/usr/local/share\" -g -O2 -MT main.o -MD -MP -MF .deps/main.Tpo -c -o main.o main.c /usr/bin/install -c -m 644 rlwrap.1 '/usr/local/share/man/man1' make[2]: Leaving directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37/doc' make[1]: Leaving directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37/doc' Making install in src make[1]: Entering directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37/src'
    gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT main.o -MD -MP -MF .deps/main.Tpo -c -o main.o main.c
    mv -f .deps/main.Tpo .deps/main.Po
    gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT signals.o -MD -MP -MF .deps/signals.Tpo -c -o signals.o signals.c
    mv -f .deps/main.Tpo .deps/main.Po
    gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT signals.o -MD -MP -MF .deps/signals.Tpo -c -o signals.o signals.c
    mv -f .deps/signals.Tpo .deps/signals.Po
    gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT readline.o -MD -MP -MF .deps/readline.Tpo -c -o readline.o readline.c
    mv -f .deps/signals.Tpo .deps/signals.Po
    gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT readline.o -MD -MP -MF .deps/readline.Tpo -c -o readline.o readline.c
    mv -f .deps/readline.Tpo .deps/readline.Po
    gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT pty.o -MD -MP -MF .deps/pty.Tpo -c -o pty.o pty.c
    mv -f .deps/readline.Tpo .deps/readline.Po
    gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT pty.o -MD -MP -MF .deps/pty.Tpo -c -o pty.o pty.c
    mv -f .deps/pty.Tpo .deps/pty.Po
    gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT completion.o -MD -MP -MF .deps/completion.Tpo -c -o completion.o completion.c
    mv -f .deps/pty.Tpo .deps/pty.Po
    gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT completion.o -MD -MP -MF .deps/completion.Tpo -c -o completion.o completion.c
    mv -f .deps/completion.Tpo .deps/completion.Po
    gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT term.o -MD -MP -MF .deps/term.Tpo -c -o term.o term.c
    mv -f .deps/completion.Tpo .deps/completion.Po
    gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT term.o -MD -MP -MF .deps/term.Tpo -c -o term.o term.c
    mv -f .deps/term.Tpo .deps/term.Po
    gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT ptytty.o -MD -MP -MF .deps/ptytty.Tpo -c -o ptytty.o ptytty.c
    mv -f .deps/term.Tpo .deps/term.Po
    gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT ptytty.o -MD -MP -MF .deps/ptytty.Tpo -c -o ptytty.o ptytty.c
    mv -f .deps/ptytty.Tpo .deps/ptytty.Po
    gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT utils.o -MD -MP -MF .deps/utils.Tpo -c -o utils.o utils.c
    mv -f .deps/ptytty.Tpo .deps/ptytty.Po
    gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT utils.o -MD -MP -MF .deps/utils.Tpo -c -o utils.o utils.c
    mv -f .deps/utils.Tpo .deps/utils.Po
    gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT string_utils.o -MD -MP -MF .deps/string_utils.Tpo -c -o string_utils.o string_utils.c
    mv -f .deps/utils.Tpo .deps/utils.Po
    gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT string_utils.o -MD -MP -MF .deps/string_utils.Tpo -c -o string_utils.o string_utils.c
    string_utils.c: In function 鈉olourless_strlen?
    string_utils.c:626: warning: assignment discards qualifiers from pointer target type
    string_utils.c: In function 鈉olourless_strlen?
    string_utils.c:626: warning: assignment discards qualifiers from pointer target type
    mv -f .deps/string_utils.Tpo .deps/string_utils.Po
    gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT malloc_debug.o -MD -MP -MF .deps/malloc_debug.Tpo -c -o malloc_debug.o malloc_debug.c
    mv -f .deps/string_utils.Tpo .deps/string_utils.Po
    gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT malloc_debug.o -MD -MP -MF .deps/malloc_debug.Tpo -c -o malloc_debug.o malloc_debug.c
    mv -f .deps/malloc_debug.Tpo .deps/malloc_debug.Po
    gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT filter.o -MD -MP -MF .deps/filter.Tpo -c -o filter.o filter.c
    mv -f .deps/malloc_debug.Tpo .deps/malloc_debug.Po
    gcc -DHAVE_CONFIG_H -I. -I..    -DDATADIR=\"/usr/local/share\"  -g -O2 -MT filter.o -MD -MP -MF .deps/filter.Tpo -c -o filter.o filter.c
    mv -f .deps/filter.Tpo .deps/filter.Po
    gcc -DDATADIR=\"/usr/local/share\"  -g -O2   -o rlwrap main.o signals.o readline.o pty.o completion.o term.o ptytty.o utils.o string_utils.o malloc_debug.o filter.o  -lutil  -lreadline -lcurses
    mv -f .deps/filter.Tpo .deps/filter.Po
    gcc -DDATADIR=\"/usr/local/share\"  -g -O2   -o rlwrap main.o signals.o readline.o pty.o completion.o term.o ptytty.o utils.o string_utils.o malloc_debug.o filter.o  -lutil  -lreadline -lcurses
    make[2]: Leaving directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37/src' Making all in filters make[2]: Entering directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37/filters' make[2]: Nothing to be done for `all'. make[2]: Leaving directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37/filters'
    make[2]: Entering directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37' make[2]: Leaving directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37' make[1]: Leaving directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37' make[2]: Entering directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37/src'
    test -z "/usr/local/bin" || /bin/mkdir -p "/usr/local/bin"
      /usr/bin/install -c rlwrap '/usr/local/bin'
    make[2]: Nothing to be done for `install-data-am'. make[2]: Leaving directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37/src' make[1]: Leaving directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37/src' Making install in filters make[1]: Entering directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37/filters'
    make[2]: Entering directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37/filters' make[2]: Nothing to be done for `install-exec-am'. test -z "/usr/local/share/man/man3" || /bin/mkdir -p "/usr/local/share/man/man3" /usr/bin/install -c -m 644 RlwrapFilter.3pm '/usr/local/share/man/man3'
    make[2]: Leaving directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37/filters' make[1]: Leaving directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37/filters' make[1]: Entering directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37' make[2]: Entering directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37'
    make[2]: Nothing to be done for `install-exec-am'. test -z "/usr/local/share/rlwrap" || /bin/mkdir -p "/usr/local/share/rlwrap" /bin/mkdir -p '/usr/local/share/rlwrap/filters' /usr/bin/install -c -m 644 filters/README filters/RlwrapFilter.pm filters/RlwrapFilter.3pm filters/count_in_prompt filters/pipeto filters/logger filters/null filters/unbackspace filters/pipeline filters/ftp_filter filters/history_format filters/simple_macro filters/template filters/scrub_prompt filters/paint_prompt filters/censor_passwords filters/listing '/usr/local/share/rlwrap/filters' /bin/mkdir -p '/usr/local/share/rlwrap/completions' /usr/bin/install -c -m 644 completions/testclient completions/coqtop '/usr/local/share/rlwrap/completions' make install-data-hook make[3]: Entering directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37' chmod a+x /usr/local/share/rlwrap/filters/* make[3]: Leaving directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37' make[2]: Leaving directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37'
    make[1]: Leaving directory `/mnt/hgfs/soft/oracle/rlwrap-0.37/rlwrap-0.37'
    [1]+  Done                    make
    [root@localhost rlwrap-0.37]#

5、配置Oracle用户环境变量文件.bash\_profile

文件尾部增加  
alias sqlplus=’rlwrap sqlplus’  
alias rman=’rlwrap rman’

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FpeGlhbmdfY2hlbg_size_16_color_FFFFFF_t_70_pic_center]: /images/20221120/a3bc335503284c298d8a3b33dc89078b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FpeGlhbmdfY2hlbg_size_16_color_FFFFFF_t_70_pic_center 1]: /images/20221120/0ed62ad0034d4ac995a9d6ec186cf4ea.png