Install Oracle Client with SQL Loader in RHEL / CentOS

Submitted by Dickens A S on Sat, 04/23/2022 - 02:49

This article explains how to install oracle client using RPM files

which ever version you want to choose you can choose for example 21.6

oracle-instantclient-basic-21.6.0.0.0-1.x86_64.rpm
oracle-instantclient-devel-21.6.0.0.0-1.x86_64.rpm
oracle-instantclient-jdbc-21.6.0.0.0-1.x86_64.rpm
oracle-instantclient-sqlplus-21.6.0.0.0-1.x86_64.rpm
oracle-instantclient-tools-21.6.0.0.0-1.x86_64.rpm

Download all these and issue the below RPM command lines

sudo rpm -ivh oracle-instantclient-basic-21.6.0.0.0-1.x86_64.rpm
sudo rpm -ivh oracle-instantclient-devel-21.6.0.0.0-1.x86_64.rpm
sudo rpm -ivh oracle-instantclient-jdbc-21.6.0.0.0-1.x86_64.rpm
sudo rpm -ivh oracle-instantclient-sqlplus-21.6.0.0.0-1.x86_64.rpm
sudo rpm -ivh oracle-instantclient-tools-21.6.0.0.0-1.x86_64.rpm

Then set the LD_LIBRARY_PATH and PATH

export LD_LIBRARY_PATH=LD_LIBRARY_PATH:/usr/lib64/oracle/21/client/lib
export PATH=$PATH:/usr/lib64/oracle/21/client/bin

Then execute command like sqlldr, sqlplus, imp, exp .... Etc

That's All :)

Add new comment