DB Wiki

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
wget https://download.oracle.com/otn_software/linux/instantclient/2370000/instantclient-sdk-linux.x64-23.7.0.25.01.zip
wget https://download.oracle.com/otn_software/linux/instantclient/2370000/instantclient-jdbc-linux.x64-23.7.0.25.01.zip

unzip instantclient*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

Newer versions of Ubuntu no longer have the libaio1 package.
Instead it is called libaio1t64. Install this package and create a symbolic link.

sudo apt install -y libaio1t64
sudo ln -s /usr/lib/x86_64-linux-gnu/libaio.so.1t64 /usr/lib/x86_64-linux-gnu/libaio.so.1

sqlplus user/password@host:port/db_service_name

The port number does not need to be specified if it is 1521

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\"

wget https://download.oracle.com/otn_software/linux/instantclient/2370000/instantclient-tools-linux.x64-23.7.0.25.01.zip
perl -p -i.bak -e 's#__SUB__CWD__#'$(pwd)'#g' *.sql */*.sql */*.dat