Setting up SQL*Plus

tested on bionic

The new school

Grab some client that is ready already (ZIP)

Oracle Instant Client Downloads

#cd instantclient_19_6/

The old school

RPM for Debian/Ubuntu

apt install alien

#alien -i oracle-instantclient18.3-basiclite- 
#alien -i oracle-instantclient18.3-sqlplus-
#echo /usr/lib/oracle/18.3/client64/lib >> /etc/

#alien -i oracle-instantclient19.6-basiclite-
#alien -i oracle-instantclient19.6-sqlplus-
alien -i oracle-instantclient19.6-basic-
alien -i oracle-instantclient19.6-sqlplus-
alien -i oracle-instantclient19.6-tools-
alien -i oracle-instantclient19.6-devel- #contains oci.h
ls -lF /usr/lib/oracle/19.6/client64/lib/
cat /etc/
locate oci.h

Ready to go


change DBUSER,PASSWORD,x.x.x.x


Install SQL*Plus

Instant Client Downloads for Linux AMD64

Instant Client Downloads for Linux x86-64 (64-bit)

What is the difference between amd64 and linux 64 versions? [duplicate]

How to use sqlplus to connect to an Oracle Database located on another host without modifying my own tnsnames.ora

Creating an Oracle 8i database on NT from the command line only