Oracle Instant Client on Debian / Ubuntu

Documentazione ufficiale

Oracle Instant Client Downloads

https://www.oracle.com/it/database/technologies/instant-client/downloads.html

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

https://www.oracle.com/it/database/technologies/instant-client/linux-x86-64-downloads.html

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

https://www.oracle.com/it/database/technologies/instant-client/linux-x86-64-downloads.html#ic_x64_inst

Installazione personalizzata

Versione 19.27.0.0 (@2025-07-10)

Setup

sudo -i
apt install libaio1 unzip
mkdir -p /opt/oracle/src

Download

cd /opt/oracle/src
T=$(mktemp -d -p .)
cd ${T}

curl -sS -O https://download.oracle.com/otn_software/linux/instantclient/1927000/instantclient-basic-linux.x64-19.27.0.0.0dbru.zip
curl -sS -O https://download.oracle.com/otn_software/linux/instantclient/1927000/instantclient-sqlplus-linux.x64-19.27.0.0.0dbru.zip
curl -sS -O https://download.oracle.com/otn_software/linux/instantclient/1927000/instantclient-tools-linux.x64-19.27.0.0.0dbru.zip
curl -sS -O https://download.oracle.com/otn_software/linux/instantclient/1927000/instantclient-sdk-linux.x64-19.27.0.0.0dbru.zip

V=$(zipinfo -1 instantclient-basic-linux*.zip | awk -F / '/^instantclient_/ {print $1}' | uniq)

cd ..
mv ${T} ${V}

Unzip

cd /opt/oracle
unzip "src/${V}/*zip" "${V}/*"

ln -fnsv ${V} instantclient

echo /opt/oracle/instantclient > /etc/ld.so.conf.d/instantclient.conf
ldconfig -v

Config

cd /opt/oracle
mkdir -p etc instantclient/network/admin
touch etc/tnsnames.ora
ln -fsv /opt/oracle/etc/tnsnames.ora instantclient/network/admin/

Extra

Add /opt/oracle/instantclient to PATH in ~/.bashrc