Skip to content

How to install oracle DB client Linux

Oracle client for Linux sqlplus

  • Tested on ubuntu 20.
Bash
sudo mkdir /opt/oracle
sudo chown $USER:$USER /opt/oracle

cd /opt/oracle
wget https://download.oracle.com/otn_software/linux/instantclient/219000/instantclient-basic-linux.x64-21.9.0.0.0dbru.zip
wget https://download.oracle.com/otn_software/linux/instantclient/219000/instantclient-sqlplus-linux.x64-21.9.0.0.0dbru.zip

unzip instantclient-basic-linux.x64-21.9.0.0.0dbru.zip
unzip instantclient-sqlplus-linux.x64-21.9.0.0.0dbru.zip

rm *.zip

sudo apt install -y libaio1

sudo sh -c "echo /opt/oracle/instantclient_21_9 > /etc/ld.so.conf.d/oracle-instantclient.conf"
sudo ldconfig

Add to profile or run

export PATH=/opt/oracle/instantclient_21_9:$PATH

How to use

Connect to remote oracle DB.

  • Connect as DBA
Bash
sqlplus sys/YourPassword@//hostname:1521/FREE as sysdba
  • other example
Bash
sqlplus system/<password>@//10.1.50.78:1521/FREE
Bash
sqlplus system/YourSecurePassword123@'//192.168.1.100:1521/FREE'
Bash
sqlplus system/MyPassword123@//<container-ip>:1521/FREE