In the following article, I will show you how to install Oracle instant client on Ubuntu 20.04. When this article is written, the latest version or Oracle instant client is version 19.8. Instant client is a special software built for Oracle users that can be used to connect to the Oracle database server. If you are planning to migrate or just testing the Oracle database, you can follow my guide below to install Oracle Database.
Once you have the server set up. You may want to connect to the server from the network. Let’s say from a Ubuntu 20.04 machine. In order to connect, you must install and configure instant client and sqlplus (optional).
Steps to Install Oracle Instant Client on Ubuntu 20.04
Step 1. Update Ubuntu
It is recommended to update the Ubuntu system. Use the update command below.
sudo apt update && sudo apt upgrade
Step 2. Download Required Packages
There are two packages we need to download. Please use the link below to obtain the instant client and sqlplus installation files
- https://download.oracle.com/otn_software/linux/instantclient/19800/instantclient-basic-linux.x64-126.96.36.199.0dbru.zip?xd_co_f=fae07a5a-ae5f-4c1a-8ce0-f41ed4a394c5 (instant client package)
- https://download.oracle.com/otn_software/linux/instantclient/19800/instantclient-sqlplus-linux.x64-188.8.131.52.0dbru.zip (sqlplus package)
Save it to your download location such as your Downloads folder.
Step 3. Extract the Packages
Before we extract, we need to create a new directory for the Oracle Instant Client installation files. In this case, I would create a directory below for this purpose
You can change it to your liking.
sudo mkdir /opt/oracle
Now let’s extract the zip file to /opt/oracle directory. You should modify the command below if you use different directory as your destination.
sudo unzip instantclient-basic-linux.x64-184.108.40.206.0dbru.zip -d /opt/oracle
sudo unzip instantclient-sqlplus-linux.x64-220.127.116.11.0dbru.zip -d /opt/oracle/
After this extract command, you should have a new directory (instantclient_19_8) under /opt/oracle folder.
Step 4. Configure SQLPlus
sqlplus is a command-line utility that can be used to connect and manage the Oracle database. In this step we need to set the LD Library path. We need to add these two lines into the profile. So, open Terminal and then open the ~/.profile file.
And then copy and paste these lines to the end of the file
Close and save the file. Now execute this command
Now try to reboot Ubuntu and make sure this edit is permanently saved. Upon reboot, try to connect to the Oracle using SQLplus
Step 5. Connect to Oracle
Open Terminal and then use sqlplus