DB Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
===== Oracle Instant Client =====
==== Installation ====

<code>
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
</code>

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

<code>
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
</code>

==== Easy Connect using SQL Plus ====
=== With Password ===

<code>sqlplus user/password@host:port/db_service_name</code>
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.\\

<code>sqlplus user@\"host:port/db_service_name\"</code>

==== Oracle Sample Schemas ====
<code>
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
</code>