instantclient
This is an old revision of the document!
Table of Contents
Oracle Instant Client
Installation
sudo apt install -y libaio1 mkdir oracle && cd "$_" wget https://download.oracle.com/otn_software/linux/instantclient/2370000/instantclient-basic-linux.x64-23.7.0.25.01.zip wget https://download.oracle.com/otn_software/linux/instantclient/2370000/instantclient-sqlplus-linux.x64-23.7.0.25.01.zip unzip instantclient-basic-linux.x64-23.7.0.25.01.zip unzip instantclient-sqlplus-linux.x64-23.7.0.25.01.zip export LD_LIBRARY_PATH=$PWD/instantclient_23_7:$LD_LIBRARY_PATH export PATH=$PWD/instantclient_23_7:$PATH
Easy Connect using SQL Plus
With Password
sqlplus user/password@host:port/db_service_name
The port number does not need to be specified if it is 1521
Without Password
If using the bash shell you may get an error if you do not wish to type the password on the command prompt.
In this case you need to quote your connect string and escape the quotes with backslashes.
sqlplus user@\"host:port/db_service_name\"
instantclient.1743090635.txt.gz · Last modified: 2025/03/27 15:50 by z0hpvk