Setting up SQL*Plus

tested on bionic

The new school

Grab some client that is ready already (ZIP)

Oracle Instant Client Downloads https://www.oracle.com/technetwork/database/database-technologies/instant-client/downloads/index.html https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html

#unzip instantclient-basiclite-linux.x64-19.6.0.0.0dbru.zip
#unzip instantclient-sqlplus-linux.x64-19.6.0.0.0dbru.zip
#cd instantclient_19_6/
#...

The old school

RPM for Debian/Ubuntu

apt install alien

#alien -i oracle-instantclient18.3-basiclite-18.3.0.0.0-1.x86_64.rpm 
#alien -i oracle-instantclient18.3-sqlplus-18.3.0.0.0-1.x86_64.rpm
#echo /usr/lib/oracle/18.3/client64/lib >> /etc/ld.so.conf.d/oracle.conf

#alien -i oracle-instantclient19.6-basiclite-19.6.0.0.0-1.x86_64.rpm
#alien -i oracle-instantclient19.6-sqlplus-19.6.0.0.0-1.x86_64.rpm
alien -i oracle-instantclient19.6-basic-19.6.0.0.0-1.x86_64.rpm
alien -i oracle-instantclient19.6-sqlplus-19.6.0.0.0-1.x86_64.rpm
alien -i oracle-instantclient19.6-tools-19.6.0.0.0-1.x86_64.rpm
alien -i oracle-instantclient19.6-devel-19.6.0.0.0-1.x86_64.rpm #contains oci.h
#--scripts
ls -lF /usr/lib/oracle/19.6/client64/lib/
cat /etc/ld.so.conf.d/oracle-instantclient.conf
ldconfig
updatedb
locate oci.h

Ready to go

sqlplus64 DBUSER/PASSWORD@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=x.x.x.x)(Port=1521))(CONNECT_DATA=(SID=dbname)))

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

Resources

Install SQL*Plus https://gist.github.com/tcnksm/7316877

Instant Client Downloads for Linux AMD64 https://www.oracle.com/technetwork/topics/linux-amd64-093390.html

Instant Client Downloads for Linux x86-64 (64-bit) https://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html

What is the difference between amd64 and linux 64 versions? [duplicate] https://askubuntu.com/questions/650867/what-is-the-difference-between-amd64-and-linux-64-versions

How to use sqlplus to connect to an Oracle Database located on another host without modifying my own tnsnames.ora https://dba.stackexchange.com/questions/13075/how-to-use-sqlplus-to-connect-to-an-oracle-database-located-on-another-host-with

Creating an Oracle 8i database on NT from the command line only http://www.adp-gmbh.ch/ora/admin/creatingdbmanually8.html


HOME | GUIDES | BENCHMARKS | html