Thursday, April 24, 2014

How do I enable SQL *Plus Up and down arrow keys on Linux ?

How do I enable SQL *Plus Up and down arrow keys on Linux ? 


Below are the steps are involved under root user.

1) Download gqlplus-1.15.tar.gz from below link.

http://gqlplus.sourceforge.net/

[root@production ~]# tar -xvf gqlplus-1.15.tar.gz ---  It will create gqlplus-1.15 folder
'
'
'
'
gqlplus-1.15/readline/support/mkdirs
gqlplus-1.15/readline/rltty.h
gqlplus-1.15/readline/tilde.c
gqlplus-1.15/readline/display.c
gqlplus-1.15/readline/rlshell.h
gqlplus-1.15/readline/nls.c
gqlplus-1.15/readline/rlmbutil.h
gqlplus-1.15/readline/aclocal.m4
gqlplus-1.15/readline/compat.c
gqlplus-1.15/readline/complete.c
gqlplus-1.15/readline/USAGE
gqlplus-1.15/readline/rlwinsize.h
gqlplus-1.15/readline/keymaps.c
gqlplus-1.15/readline/vi_keymap.c
gqlplus-1.15/readline/MANIFEST
gqlplus-1.15/readline/rlconf.h
gqlplus-1.15/readline/chardefs.h
gqlplus-1.15/readline/xmalloc.h
gqlplus-1.15/readline/search.c
gqlplus-1.15/readline/posixjmp.h
gqlplus-1.15/readline/input.c
gqlplus-1.15/readline/Makefile.in
gqlplus-1.15/readline/shell.c
gqlplus-1.15/readline/configure.in
gqlplus-1.15/readline/readline.c
gqlplus-1.15/readline/funmap.c
gqlplus-1.15/readline/histsearch.c
gqlplus-1.15/readline/rlprivate.h
gqlplus-1.15/readline/util.c
gqlplus-1.15/readline/README
gqlplus-1.15/readline/terminal.c
gqlplus-1.15/readline/history.c
gqlplus-1.15/readline/configure
gqlplus-1.15/readline/rlstdc.h
gqlplus-1.15/readline/CHANGELOG
gqlplus-1.15/readline/callback.c
gqlplus-1.15/readline/tilde.h
gqlplus-1.15/readline/rldefs.h
gqlplus-1.15/readline/rltty.c
gqlplus-1.15/readline/doc/
gqlplus-1.15/readline/doc/history.0
gqlplus-1.15/readline/doc/readline.html
gqlplus-1.15/readline/doc/rluserman.texinfo
gqlplus-1.15/readline/doc/rluserman.html
gqlplus-1.15/readline/doc/history.dvi
gqlplus-1.15/readline/doc/readline.ps
gqlplus-1.15/readline/doc/readline.dvi
gqlplus-1.15/readline/doc/hsuser.texinfo
gqlplus-1.15/readline/doc/texi2html
gqlplus-1.15/readline/doc/rluserman.info
gqlplus-1.15/readline/doc/rltech.texinfo
gqlplus-1.15/readline/doc/history_3.ps
gqlplus-1.15/readline/doc/readline_3.ps
gqlplus-1.15/readline/doc/rluserman.ps
gqlplus-1.15/readline/doc/manvers.texinfo
gqlplus-1.15/readline/doc/texi2dvi
gqlplus-1.15/readline/doc/history.html
gqlplus-1.15/readline/doc/Makefile.in
gqlplus-1.15/readline/doc/rluser.texinfo
gqlplus-1.15/readline/doc/readline.3
gqlplus-1.15/readline/doc/history.3
gqlplus-1.15/readline/doc/readline.0
gqlplus-1.15/readline/doc/readline.info
gqlplus-1.15/readline/doc/texinfo.tex
gqlplus-1.15/readline/doc/rlman.texinfo
gqlplus-1.15/readline/doc/history.info
gqlplus-1.15/readline/doc/hist.texinfo
gqlplus-1.15/readline/doc/history.ps
gqlplus-1.15/readline/doc/hstech.texinfo
gqlplus-1.15/readline/doc/rluserman.dvi
gqlplus-1.15/readline/histfile.c
gqlplus-1.15/readline/misc.c
gqlplus-1.15/readline/examples/
gqlplus-1.15/readline/examples/manexamp.c
gqlplus-1.15/readline/examples/rlcat.c
gqlplus-1.15/readline/examples/excallback.c
gqlplus-1.15/readline/examples/readlinebuf.h
gqlplus-1.15/readline/examples/rlversion.c
gqlplus-1.15/readline/examples/Makefile.in
gqlplus-1.15/readline/examples/rlfe.c
gqlplus-1.15/readline/examples/fileman.c
gqlplus-1.15/readline/examples/rl.c
gqlplus-1.15/readline/examples/Inputrc
gqlplus-1.15/readline/examples/histexamp.c
gqlplus-1.15/readline/examples/rltest.c
gqlplus-1.15/readline/parens.c
gqlplus-1.15/readline/COPYING
gqlplus-1.15/readline/savestring.c
gqlplus-1.15/readline/rltypedefs.h
gqlplus-1.15/readline/config.h.in
gqlplus-1.15/readline/kill.c
gqlplus-1.15/readline/shlib/
gqlplus-1.15/readline/shlib/Makefile.in
gqlplus-1.15/readline/ansi_stdlib.h
gqlplus-1.15/readline/isearch.c
gqlplus-1.15/readline/mbutil.c
gqlplus-1.15/readline/histexpand.c
gqlplus-1.15/readline/tcap.h
gqlplus-1.15/readline/xmalloc.c
gqlplus-1.15/readline/text.c
gqlplus-1.15/readline/bind.c
gqlplus-1.15/readline/vi_mode.c
gqlplus-1.15/Makefile.am
gqlplus-1.15/missing
gqlplus-1.15/ChangeLog


[root@production ~]# cd gqlplus-1.15

[root@production gqlplus-1.15]# ls

ChangeLog     depcomp     LICENSE      missing        README
configure     gqlplus.c   Makefile.am  mkinstalldirs
configure.ac  install-sh  Makefile.in  readline

[root@production gqlplus-1.15]# ./configure

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 for gcc... gcc
checking whether the C compiler works... yes
checking for C compiler default output file name... a.out
checking for suffix of executables...
checking whether we are cross compiling... no
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 for style of include used by make... GNU
checking dependency style of gcc... gcc3
checking for ranlib... ranlib
checking for tgetnum in -lncurses... yes
checking for tputs in -lreadline... yes
configure: creating ./config.status
config.status: creating Makefile
config.status: executing depfiles commands

[root@production gqlplus-1.15]# make

CDPATH="${ZSH_VERSION+.}:" && cd . && /bin/sh /u02/DATAPUMP/gqlplus-1.15/missing                                                                                         --run aclocal-1.11
 cd . && /bin/sh /u02/DATAPUMP/gqlplus-1.15/missing --run automake-1.11 --foreig                                                                                        n
CDPATH="${ZSH_VERSION+.}:" && cd . && /bin/sh /u02/DATAPUMP/gqlplus-1.15/missing                                                                                         --run autoconf
/bin/sh ./config.status --recheck
running CONFIG_SHELL=/bin/sh /bin/sh ./configure --no-create --no-recursion
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 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 for style of include used by make... GNU
checking dependency style of gcc... gcc3
checking for a BSD-compatible install... /usr/bin/install -c
checking for ranlib... ranlib
checking for tgetnum in -lncurses... yes
checking for tputs in -lreadline... yes
configure: creating ./config.status
 /bin/sh ./config.status
config.status: creating Makefile
config.status: executing depfiles commands
gcc -DPACKAGE_NAME=\"gqlplus\" -DPACKAGE_TARNAME=\"gqlplus\" -DPACKAGE_VERSION=\                                                                                        "1.14\" -DPACKAGE_STRING=\"gqlplus\ 1.14\" -DPACKAGE_BUGREPORT=\"\" -DPACKAGE=\"                                                                                        gqlplus\" -DVERSION=\"1.14\" -DHAVE_LIBNCURSES=1 -DHAVE_LIBREADLINE=1 -I. -I.                                                                                            -g -O2 -MT gqlplus.o -MD -MP -MF .deps/gqlplus.Tpo -c -o gqlplus.o gqlplus.c
gqlplus.c:413:1: warning: "VERSION" redefined
<command-line>: warning: this is the location of the previous definition
gqlplus.c: In function âget_sql_promptâ:
gqlplus.c:2479: warning: assignment from incompatible pointer type
mv -f .deps/gqlplus.Tpo .deps/gqlplus.Po
gcc  -g -O2   -o gqlplus gqlplus.o  -lreadline -lncurses

[root@production gqlplus-1.15]# make install

make[1]: Entering directory `/u02/DATAPUMP/gqlplus-1.15'
test -z "/usr/local/bin" || /bin/mkdir -p "/usr/local/bin"
  /usr/bin/install -c gqlplus '/usr/local/bin'
make[1]: Nothing to be done for `install-data-am'.
make[1]: Leaving directory `/u02/DATAPUMP/gqlplus-1.15'

[root@production gqlplus-1.15]# su - oracle

[oracle@production ~]$ gqlplus

SQL*Plus: Release 11.2.0.3.0 Production on Thu Apr 24 23:04:43 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options


Thank you.......

No comments: