tags: oracle

flowchart TD A[rlwrap Installation] --> B[Oracle Instant Client Installation] click A "#rlwrap-installation" click B "#oracle-instant-client-installation"

rlwrap Installation:


kaau@compaq8100 ~ $ cd ${HOME}
kmaau@compaq8100 ~ $ wget --output-document=/tmp/rlwrap-0.47.1.tar.gz https://github.com/hanslub42/rlwrap/releases/download/v0.47.1/rlwrap-0.47.1.tar.gz
--2025-10-11 15:18:34--  https://github.com/hanslub42/rlwrap/releases/download/v0.47.1/rlwrap-0.47.1.tar.gz
Resolving github.com (github.com)... 140.82.114.3
Connecting to github.com (github.com)|140.82.114.3|:443... connected.
HTTP request sent, awaiting response... 302 Found
Location: https://release-assets.githubusercontent.com/.....nt-type=application%2Foctet-stream [following]
--2025-10-11 15:18:35--  https://release-assets.githubusercontent.com/github-production-release-asset/17113037/
Resolving release-assets.githubusercontent.com (release-assets.githubusercontent.com)...185.199.109.133,185.199.110.133,185.199.111.133,...
Connecting to release-assets.githubusercontent.com (release-assets.githubusercontent.com)|185.199.109.133|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 342629 (335K) [application/octet-stream]
Saving to: ‘/tmp/rlwrap-0.47.1.tar.gz’
/tmp/rlwrap-0.47.1.tar.gz      100%[=================================>] 334.60K  1.74MB/s    in 0.2s    
2025-10-11 15:18:35 (1.74 MB/s) - ‘/tmp/rlwrap-0.47.1.tar.gz’ saved [342629/342629]

kmaau@compaq8100 ~ $ ls -l /tmp/rlwrap-0.47.1.tar.gz
-rw-rw-r-- 1 kmaau kmaau 342629 Aug 22 03:36 /tmp/rlwrap-0.47.1.tar.gz

kaau@compaq8100 ~ $ sudo su -
root@compaq8100:~# whoami
root

root@compaq8100:~# tar -C /tmp -zxvf /tmp/rlwrap-0.47.1.tar.gz
rlwrap-0.47.1/
rlwrap-0.47.1/completions/
rlwrap-0.47.1/completions/testclient
rlwrap-0.47.1/completions/coqtop
::
::
::
rlwrap-0.47.1/INSTALL
rlwrap-0.47.1/NEWS
rlwrap-0.47.1/README.md
rlwrap-0.47.1/BUGS

#
# compilation:
#
root@compaq8100:~# cd /tmp/rlwrap-0.47.1
root@compaq8100:/tmp/rlwrap-0.47.1# ls -l
-rw-rw-r-- 1 kmaau kmaau  48645 Aug 22 03:28 aclocal.m4
-rw-rw-r-- 1 kmaau kmaau    982 Aug 20 12:10 AUTHORS
-rw-rw-r-- 1 kmaau kmaau   2353 Aug 20 12:10 BUGS
-rw-rw-r-- 1 kmaau kmaau    105 Aug 20 12:10 ChangeLog
drwxrwxr-x 2 kmaau kmaau   4096 Aug 22 03:28 completions
-rw-rw-r-- 1 kmaau kmaau   8845 Aug 22 03:28 config.h.in
-rwxrwxr-x 1 kmaau kmaau 282184 Aug 22 03:28 configure
-rw-rw-r-- 1 kmaau kmaau  21692 Aug 22 03:23 configure.ac
-rw-rw-r-- 1 kmaau kmaau  17992 Aug 20 12:10 COPYING
drwxrwxr-x 2 kmaau kmaau   4096 Aug 22 03:28 doc
drwxrwxr-x 2 kmaau kmaau   4096 Aug 22 03:29 filters
-rw-rw-r-- 1 kmaau kmaau   3763 Aug 20 15:10 INSTALL
-rw-rw-r-- 1 kmaau kmaau   2183 Aug 20 12:10 Makefile.am
-rw-rw-r-- 1 kmaau kmaau  44143 Aug 22 03:28 Makefile.in
-rw-rw-r-- 1 kmaau kmaau  27606 Aug 22 03:28 NEWS
-rw-rw-r-- 1 kmaau kmaau   3880 Aug 22 03:23 README.md
drwxrwxr-x 2 kmaau kmaau   4096 Aug 22 03:29 src
drwxrwxr-x 2 kmaau kmaau   4096 Aug 22 03:28 test
drwxrwxr-x 2 kmaau kmaau   4096 Aug 22 03:28 tools

root@compaq8100:/tmp/rlwrap-0.47.1# which make
/usr/bin/make

root@compaq8100:/tmp/rlwrap-0.47.1# ./configure
checking build system type... x86_64-pc-linux-gnu
checking host system type... x86_64-pc-linux-gnu
checking for a BSD-compatible install... /usr/bin/install -c
checking whether sleep supports fractional seconds... yes
::
::
checking whether gcc understands -c and -o together... yes
checking dependency style of gcc... gcc3
checking for ptytty_create in -lptytty... no
configure: error: libptytty not found, install it or specify  --without-libptytty                            ---oop!

root@compaq8100:/tmp/rlwrap-0.47.1# apt-get install --yes libptytty-dev
::
::

root@compaq8100:/tmp/rlwrap-0.47.1# ./configure 
checking build system type... x86_64-pc-linux-gnu
checking host system type... x86_64-pc-linux-gnu
checking for a BSD-compatible install... /usr/bin/install -c
::
::
checking for tgetent in -lcurses... no
checking for tgetent in -lncurses... no
checking for tgetent in -ltermcap... no
configure: error: No termcap nor curses library found                                                        ---oop!

root@compaq8100:/tmp/rlwrap-0.47.1# apt-get install libncurses5-dev libncursesw5-dev
::
::

root@compaq8100:/tmp/rlwrap-0.47.1# ./configure
checking build system type... x86_64-pc-linux-gnu
checking host system type... x86_64-pc-linux-gnu
checking for a BSD-compatible install... /usr/bin/install -c
checking whether sleep supports fractional seconds... yes
::
::
checking for tgetent in -ltinfo... yes
checking for readline in -lreadline... no
configure: error: 
You need the GNU readline library(ftp://ftp.gnu.org/gnu/readline/ ) to build this program!                   ---oop!

root@compaq8100:/tmp/rlwrap-0.47.1# apt-get install --yes libreadline-dev
::
::

root@compaq8100:/tmp/rlwrap-0.47.1# ./configure
checking build system type... x86_64-pc-linux-gnu
checking host system type... x86_64-pc-linux-gnu
checking for a BSD-compatible install... /usr/bin/install -c
checking whether sleep supports fractional seconds... yes
::
::
::
::
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@compaq8100:/tmp/rlwrap-0.47.1# make
make  all-recursive
make[1]: Entering directory '/tmp/rlwrap-0.47.1'
Making all in doc
make[2]: Entering directory '/tmp/rlwrap-0.47.1/doc'
sed -e 's#@DATADIR@#/usr/local/share#'  rlwrap.man > rlwrap.1
make[2]: Leaving directory '/tmp/rlwrap-0.47.1/doc'
Making all in src
::
::
::
make[2]: Entering directory '/tmp/rlwrap-0.47.1/filters'
make[2]: Nothing to be done for 'all'.
make[2]: Leaving directory '/tmp/rlwrap-0.47.1/filters'
make[2]: Entering directory '/tmp/rlwrap-0.47.1'
make[2]: Leaving directory '/tmp/rlwrap-0.47.1'
make[1]: Leaving directory '/tmp/rlwrap-0.47.1'

root@compaq8100:/tmp/rlwrap-0.47.1# make install
Making install in doc
make[1]: Entering directory '/tmp/rlwrap-0.47.1/doc'
make[2]: Entering directory '/tmp/rlwrap-0.47.1/doc'
make[2]: Nothing to be done for 'install-exec-am'.
::
::
::
::
chmod a+x /usr/local/share/rlwrap/filters/* 
make[3]: Leaving directory '/tmp/rlwrap-0.47.1'
make[2]: Leaving directory '/tmp/rlwrap-0.47.1'
make[1]: Leaving directory '/tmp/rlwrap-0.47.1'

root@compaq8100:/tmp/rlwrap-0.47.1# ls -l /usr/local/bin/rlwrap
-rwxr-xr-x 1 root root 363008 Oct 11 15:36 /usr/local/bin/rlwrap
root@compaq8100:/tmp/rlwrap-0.47.1# which rlwrap
/usr/local/bin/rlwrap
root@compaq8100:/tmp/rlwrap-0.47.1# exit
logout
  

Oracle Instant Client Installation:


#
# pre-requisite:
#
root@compaq8100:~# ldd --version
ldd (Ubuntu GLIBC 2.39-0ubuntu8.6) 2.39
Copyright (C) 2024 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
Written by Roland McGrath and Ulrich Drepper.

oracle@compaq8100:~$ apt-cache search libaio
libaio-dev - Linux kernel AIO access library - development files
libaio1t64 - Linux kernel AIO access library - shared library                                                ---this

oracle@compaq8100:~$ sudo apt-get install --yes libaio1t64
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
libaio1t64 is already the newest version (0.3.113-6build1.1).                                                ---why?
0 upgraded, 0 newly installed, 0 to remove and 3 not upgraded.

#
# refers: https://askubuntu.com/questions/227791/how-do-i-install-libaio
#
oracle@compaq8100:~$ cd /usr/lib/x86_64-linux-gnu
oracle@compaq8100:/usr/lib/x86_64-linux-gnu$ ls -l libaio.so.1t64
lrwxrwxrwx 1 root root 18 Oct  2  2024 libaio.so.1t64 -> libaio.so.1t64.0.2                                  ---chained symlink

oracle@compaq8100:/usr/lib/x86_64-linux-gnu$ sudo ln -nfs libaio.so.1t64 libaio.so.1
  

kmaau@compaq8100 ~ $ sudo su - oracle

oracle@compaq8100 ~ $ ls -l /tmp/instantclient-*.zip
-rwxr-xr-x 1 kmaau kmaau 134405774 Feb 28 14:43 /tmp/instantclient-basic-linux.x64-23.26.1.0.0.zip           ---this
-rwxr-xr-x 1 kmaau kmaau  75176589 Feb 28 14:43 /tmp/instantclient-basiclite-linux.x64-23.26.1.0.0.zip
-rwxr-xr-x 1 kmaau kmaau   1587909 Feb 28 14:43 /tmp/instantclient-jdbc-linux.x64-23.26.1.0.0.zip
-rwxr-xr-x 1 kmaau kmaau    817581 Feb 28 14:43 /tmp/instantclient-odbc-linux.x64-23.26.1.0.0.zip
-rwxr-xr-x 1 kmaau kmaau   1085730 Feb 28 14:43 /tmp/instantclient-sdk-linux.x64-23.26.1.0.0.zip
-rwxr-xr-x 1 kmaau kmaau   5641079 Feb 28 14:43 /tmp/instantclient-sqlplus-linux.x64-23.26.1.0.0.zip         ---this
-rwxr-xr-x 1 kmaau kmaau   1443430 Feb 28 14:43 /tmp/instantclient-tools-linux.x64-23.26.1.0.0.zip           ---this

#
# unzip sequemces:
#   unzip instantclient-basic-linux.x64-23.26.1.0.0.zip
#   unzip instantclient-sqlplus-linux.x64-23.26.1.0.0.zip
#   unzip instantclient-tools-linux.x64-23.26.1.0.0.zip
#
oracle@compaq8100:~$ sudo mkdir /opt/oracle
oracle@compaq8100:~$ (cd /opt/oracle; sudo unzip /tmp/instantclient-basic-linux.x64-23.26.1.0.0.zip)
Archive:  /tmp/instantclient-basic-linux.x64-23.26.1.0.0.zip
  inflating: META-INF/MANIFEST.MF    
  inflating: META-INF/ORACLE_C.SF    
  inflating: META-INF/ORACLE_C.RSA   
  inflating: instantclient_23_26/adrci  
  inflating: instantclient_23_26/BASIC_LICENSE  
  inflating: instantclient_23_26/BASIC_README  
  ::
  ::
  ::
  instantclient_23_26/libocci.so.20.1 -> libocci.so.23.1
  instantclient_23_26/libocci.so.21.1 -> libocci.so.23.1
  instantclient_23_26/libocci.so.22.1 -> libocci.so.23.1

oracle@compaq8100:~$ (cd /opt/oracle; sudo unzip /tmp/instantclient-sqlplus-linux.x64-23.26.1.0.0.zip)
Archive:  /tmp/instantclient-sqlplus-linux.x64-23.26.1.0.0.zip
replace META-INF/MANIFEST.MF? [y]es, [n]o, [A]ll, [N]one, [r]ename: A
  inflating: META-INF/MANIFEST.MF    
  inflating: META-INF/ORACLE_C.SF    
  inflating: META-INF/ORACLE_C.RSA   
  inflating: instantclient_23_26/glogin.sql  
  inflating: instantclient_23_26/libsqlplusic.so  
  inflating: instantclient_23_26/libsqlplus.so  
  inflating: instantclient_23_26/sqlplus  
  inflating: instantclient_23_26/SQLPLUS_LICENSE  
  inflating: instantclient_23_26/SQLPLUS_README  

oracle@compaq8100:~$ (cd /opt/oracle; sudo unzip /tmp/instantclient-tools-linux.x64-23.26.1.0.0.zip)
Archive:  /tmp/instantclient-tools-linux.x64-23.26.1.0.0.zip
replace META-INF/MANIFEST.MF? [y]es, [n]o, [A]ll, [N]one, [r]ename: A
  inflating: META-INF/MANIFEST.MF    
  inflating: META-INF/ORACLE_C.SF    
  inflating: META-INF/ORACLE_C.RSA   
  inflating: instantclient_23_26/exp  
  inflating: instantclient_23_26/expdp  
  inflating: instantclient_23_26/imp  
  inflating: instantclient_23_26/impdp  
  inflating: instantclient_23_26/libnfsodm.so  
  inflating: instantclient_23_26/libopcodm.so  
  inflating: instantclient_23_26/sqlldr  
  inflating: instantclient_23_26/TOOLS_LICENSE  
  inflating: instantclient_23_26/TOOLS_README  
  inflating: instantclient_23_26/wrc  

oracle@compaq8100:~$ ls -l /opt/oracle
drwxr-xr-x 3 root root 4096 Feb 28 15:08 instantclient_23_26
drwxr-xr-x 2 root root 4096 Feb 28 15:08 META-INF
oracle@compaq8100:~$ sudo chown -R oracle:oinstall /opt/oracle
oracle@compaq8100:~$ ls -l /opt/oracle
drwxr-xr-x 3 oracle oinstall 4096 Feb 28 15:08 instantclient_23_26
drwxr-xr-x 2 oracle oinstall 4096 Feb 28 15:08 META-INF

oracle@compaq8100:~$ ls -l /opt/oracle/instantclient_23_26
-rwxr-xr-x 1 oracle oinstall     42768 Jan 17 03:54 adrci
-rw-r--r-- 1 oracle oinstall      6506 Jan 17 03:54 BASIC_LICENSE
-rw-r--r-- 1 oracle oinstall       406 Jan 17 03:54 BASIC_README
-rwxr-xr-x 1 oracle oinstall    662288 Jan 17 03:55 exp
-rwxr-xr-x 1 oracle oinstall    247600 Jan 17 03:55 expdp
-rwxr-xr-x 1 oracle oinstall   3470528 Jan 17 03:54 fips1403.so
-rwxr-xr-x 1 oracle oinstall   2127184 Jan 17 03:54 fips.so
-rwxr-xr-x 1 oracle oinstall     72888 Jan 17 03:54 genezi
-rw-r--r-- 1 oracle oinstall       342 Jan 17 03:55 glogin.sql
-rwxr-xr-x 1 oracle oinstall    372528 Jan 17 03:55 imp
-rwxr-xr-x 1 oracle oinstall    251216 Jan 17 03:55 impdp
-rwxr-xr-x 1 oracle oinstall   7444688 Jan 17 03:54 legacy.so
lrwxrwxrwx 1 oracle oinstall        21 Feb 28 15:00 libclntshcore.so -> libclntshcore.so.23.1
lrwxrwxrwx 1 oracle oinstall        21 Feb 28 15:00 libclntshcore.so.12.1 -> libclntshcore.so.23.1
lrwxrwxrwx 1 oracle oinstall        21 Feb 28 15:00 libclntshcore.so.18.1 -> libclntshcore.so.23.1
lrwxrwxrwx 1 oracle oinstall        21 Feb 28 15:00 libclntshcore.so.19.1 -> libclntshcore.so.23.1
lrwxrwxrwx 1 oracle oinstall        21 Feb 28 15:00 libclntshcore.so.20.1 -> libclntshcore.so.23.1
lrwxrwxrwx 1 oracle oinstall        21 Feb 28 15:00 libclntshcore.so.21.1 -> libclntshcore.so.23.1
lrwxrwxrwx 1 oracle oinstall        21 Feb 28 15:00 libclntshcore.so.22.1 -> libclntshcore.so.23.1
-rwxr-xr-x 1 oracle oinstall   5502848 Jan 17 03:54 libclntshcore.so.23.1
lrwxrwxrwx 1 oracle oinstall        17 Feb 28 15:00 libclntsh.so -> libclntsh.so.23.1
lrwxrwxrwx 1 oracle oinstall        17 Feb 28 15:00 libclntsh.so.10.1 -> libclntsh.so.23.1
lrwxrwxrwx 1 oracle oinstall        17 Feb 28 15:00 libclntsh.so.11.1 -> libclntsh.so.23.1
lrwxrwxrwx 1 oracle oinstall        17 Feb 28 15:00 libclntsh.so.12.1 -> libclntsh.so.23.1
lrwxrwxrwx 1 oracle oinstall        17 Feb 28 15:00 libclntsh.so.18.1 -> libclntsh.so.23.1
lrwxrwxrwx 1 oracle oinstall        17 Feb 28 15:00 libclntsh.so.19.1 -> libclntsh.so.23.1
lrwxrwxrwx 1 oracle oinstall        17 Feb 28 15:00 libclntsh.so.20.1 -> libclntsh.so.23.1
lrwxrwxrwx 1 oracle oinstall        17 Feb 28 15:00 libclntsh.so.21.1 -> libclntsh.so.23.1
lrwxrwxrwx 1 oracle oinstall        17 Feb 28 15:00 libclntsh.so.22.1 -> libclntsh.so.23.1
-rwxr-xr-x 1 oracle oinstall  98345128 Jan 17 03:54 libclntsh.so.23.1
-rwxr-xr-x 1 oracle oinstall     70112 Jan 17 03:55 libnfsodm.so
-rwxr-xr-x 1 oracle oinstall  12587072 Jan 17 03:54 libnnz.so
lrwxrwxrwx 1 oracle oinstall        15 Feb 28 15:00 libocci.so -> libocci.so.23.1
lrwxrwxrwx 1 oracle oinstall        15 Feb 28 15:00 libocci.so.10.1 -> libocci.so.23.1
lrwxrwxrwx 1 oracle oinstall        15 Feb 28 15:00 libocci.so.11.1 -> libocci.so.23.1
lrwxrwxrwx 1 oracle oinstall        15 Feb 28 15:00 libocci.so.12.1 -> libocci.so.23.1
lrwxrwxrwx 1 oracle oinstall        15 Feb 28 15:00 libocci.so.18.1 -> libocci.so.23.1
lrwxrwxrwx 1 oracle oinstall        15 Feb 28 15:00 libocci.so.19.1 -> libocci.so.23.1
lrwxrwxrwx 1 oracle oinstall        15 Feb 28 15:00 libocci.so.20.1 -> libocci.so.23.1
lrwxrwxrwx 1 oracle oinstall        15 Feb 28 15:00 libocci.so.21.1 -> libocci.so.23.1
lrwxrwxrwx 1 oracle oinstall        15 Feb 28 15:00 libocci.so.22.1 -> libocci.so.23.1
-rwxr-xr-x 1 oracle oinstall   1356472 Jan 17 03:54 libocci.so.23.1
-rwxr-xr-x 1 oracle oinstall 205734352 Jan 17 03:54 libociei.so
-r-xr-xr-x 1 oracle oinstall    164328 Jan 17 03:54 libocijdbc23.so
-rwxr-xr-x 1 oracle oinstall     78120 Jan 17 03:55 libopcodm.so
-rwxr-xr-x 1 oracle oinstall  23306808 Jan 17 03:55 libsqlplusic.so
-rwxr-xr-x 1 oracle oinstall   1136128 Jan 17 03:55 libsqlplus.so
-r-xr-xr-x 1 oracle oinstall     18792 Jan 17 03:54 libtfojdbc1.so
drwxr-xr-x 3 oracle oinstall      4096 Jan 17 03:54 network
-rw-r--r-- 1 oracle oinstall   7645262 Jan 17 03:54 ojdbc11.jar
-rw-r--r-- 1 oracle oinstall   7646705 Jan 17 03:54 ojdbc17.jar
-rw-r--r-- 1 oracle oinstall   7514786 Jan 17 03:54 ojdbc8.jar
-rwxr-xr-x 1 oracle oinstall   7470008 Jan 17 03:54 pkcs11.so
-rwxr-xr-x 1 oracle oinstall   2299328 Jan 17 03:55 sqlldr
-rwxr-xr-x 1 oracle oinstall     41568 Jan 17 03:55 sqlplus
-rw-r--r-- 1 oracle oinstall      6506 Jan 17 03:55 SQLPLUS_LICENSE
-rw-r--r-- 1 oracle oinstall       412 Jan 17 03:55 SQLPLUS_README
-rw-r--r-- 1 oracle oinstall      6506 Jan 17 03:55 TOOLS_LICENSE
-rw-r--r-- 1 oracle oinstall       406 Jan 17 03:55 TOOLS_README
-rw-r--r-- 1 oracle oinstall   1568154 Jan 17 03:54 ucp11.jar
-rw-r--r-- 1 oracle oinstall   1568398 Jan 17 03:54 ucp17.jar
-rw-r--r-- 1 oracle oinstall   1514114 Jan 17 03:54 ucp.jar
-rwxr-xr-x 1 oracle oinstall    183696 Jan 17 03:54 uidrvci
-rwxr-xr-x 1 oracle oinstall    866776 Jan 17 03:55 wrc
-rw-r--r-- 1 oracle oinstall     32669 Jan 17 03:54 xstreams.jar

oracle@compaq8100:~$ file /opt/oracle/instantclient_23_26/sqlplus
/opt/oracle/instantclient_23_26/sqlplus: ELF 64-bit LSB pie executable, x86-64, version 1 (SYSV), dynamically linked, 
interpreter /lib64/ld-linux-x86-64.so.2, for GNU/Linux 3.2.0, BuildID[sha1]=4e0bf649ee03f53e99fbaaba46fa6d48e0ffb018, not stripped

oracle@compaq8100:~$ ldd /opt/oracle/instantclient_23_26/sqlplus
        linux-vdso.so.1 (0x00007ffe05782000)
        libsqlplus.so => not found
        libclntsh.so.23.1 => not found
        libclntshcore.so.23.1 => not found
        libnnz.so => not found
        libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007f53afd7d000)
        libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f53afc92000)
        libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f53afc8d000)
        librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007f53afc88000)
        libaio.so.1 => /lib/x86_64-linux-gnu/libaio.so.1 (0x00007f53afc83000)
        libresolv.so.2 => /lib/x86_64-linux-gnu/libresolv.so.2 (0x00007f53afc70000)
        libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f53afa00000)
        /lib64/ld-linux-x86-64.so.2 (0x00007f53afda0000)

#
# configure ${HOME}/.profile
#
oracle@compaq8100:~$ vi ${HOME}/.profile
::
::

oracle@compaq8100:~$ cat ${HOME}/.profile
::
::
::
::
export INSTANTCLIENT_HOME=/opt/oracle/instantclient_23_26
export PATH=${PATH}:${INSTANTCLIENT_HOME}
export LD_LIBRARY_PATH=${INSTANTCLIENT_HOME}
alias sqlplus='rlwrap sqlplus'

oracle@compaq8100:~$ source ~/.profile

oracle@compaq8100:~$ ldd /opt/oracle/instantclient_23_26/sqlplus
        linux-vdso.so.1 (0x00007ffd49352000)
        libsqlplus.so => /opt/oracle/instantclient_23_26/libsqlplus.so (0x00007d1be2271000)
        libclntsh.so.23.1 => /opt/oracle/instantclient_23_26/libclntsh.so.23.1 (0x00007d1bdc800000)
        libclntshcore.so.23.1 => /opt/oracle/instantclient_23_26/libclntshcore.so.23.1 (0x00007d1bdc200000)
        libnnz.so => /opt/oracle/instantclient_23_26/libnnz.so (0x00007d1bdb600000)
        libdl.so.2 => /lib/x86_64-linux-gnu/libdl.so.2 (0x00007d1be2259000)
        libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007d1bdc717000)
        libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007d1be2252000)
        librt.so.1 => /lib/x86_64-linux-gnu/librt.so.1 (0x00007d1be224d000)
        libaio.so.1 => /lib/x86_64-linux-gnu/libaio.so.1 (0x00007d1be2248000)
        libresolv.so.2 => /lib/x86_64-linux-gnu/libresolv.so.2 (0x00007d1bdc1ed000)
        libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007d1bdb200000)
        /lib64/ld-linux-x86-64.so.2 (0x00007d1be2386000)

oracle@compaq8100:~$ which sqlplus
/opt/oracle/instantclient_23_26/sqlplus
oracle@compaq8100:~$ sqlplus -version
SQL*Plus: Release 23.26.1.0.0 - Production
Version 23.26.1.0.0
  

Clean up:


oracle@compaq8100:~$ sudo rm -f /tmp/instantclient-*.zip