Install Oracle InstantClient and SQL*Plus from source on Ubuntu 20.04

README.md

Download InstantClient

mkdir -p /opt/oracle
cd /opt/oracle
wget https://download.oracle.com/otn_software/linux/instantclient/218000/instantclient-basic-linux.x64-21.8.0.0.0dbru.zip
unzip instantclient-basic-linux.x64-21.8.0.0.0dbru.zip

Download SQLPlus

wget https://download.oracle.com/otn_software/linux/instantclient/218000/instantclient-sqlplus-linux.x64-21.8.0.0.0dbru.zip
unzip instantclient-sqlplus-linux.x64-21.8.0.0.0dbru.zip

After you unzip sqlplus package, you will see both lib files and sqlplus command inside directory instantclient_21_8

ls -la /opt/oracle/instantclient_21_8

Install Ubuntu dependency package

sudo apt install libaio1

Autoload LD_LIBRARY_PATH

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

Add follow code to ~/.bashrc

export LD_LIBRARY_PATH=/opt/oracle/instantclient_21_8:$LD_LIBRARY_PATH
export PATH=/opt/oracle/instantclient_21_8:$PATH

Then logout and login again or run source ~/.bashrc to reload $PATH environment

Test connection

Use SQLPlus

sqlplus username:password@host:port/service_name

# password promt (better)
sqlplus username@host:port/service_name

Use Python

Install dependencies

pip install cx_Oracle

Connect to Oracle python script

import cx_Oracle as Database
user = 'username'
password = 'password'
dsn = Database.makedsn('host', 'port', service_name='service_name')
conn = Database.connect(user=user, password=password, dsn=dsn, encoding='UTF-8')

Django Database settings

Use service name

DATABASES = {
  'ENGINE': 'django.db.backends.oracle',
  'NAME': 'host:port/service_name',
  'USER': 'username',
  'PASSWORD': 'password',
}

Use SID

DATABASES = {
  'ENGINE': 'django.db.backends.oracle',
  'NAME': 'sid',
  'USER': 'username',
  'PASSWORD': 'password',
  'HOST': 'host',
  'PORT': 'port',
}

References

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

first line: after mkdir -p /opt/oracle add cd /opt/oracle

first line: after mkdir -p /opt/oracle add cd /opt/oracle

@alessandrofuda DONE! Thanks for point it out.

after completion it is asking for username and password and i am using my ubuntu username and passwword showing error
ORA-12162: TNS:net service name is incorrectly specified

after completion it is asking for username and password and i am using my ubuntu username and passwword showing error ORA-12162: TNS:net service name is incorrectly specified

please provide your command or code

Good morning,
I have done all the installation to the letter, but at the time of entering username and password, I do not know which username and password to enter. If I enter the user of the computer after running

sqlplus 

I get

ORA-12162: TNS:net service name is incorrectly specified

and instead if I run

sqlplus username:password@localhost:1521/service_name

I get

ORA-12541: TNS:no listener

I would appreciate any help, thank you very much