Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Oracle_client is required to connect to remote Oracle databases. For Oracle Foreign Data Wrapper, this installation needs to be done as follows.
First of all, we download the rpm package from oracle’s site at the link below.
https://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html
We download the rpm package from the link below to our machine.
Run the following command to install the rpm package.
1 | sudo yum install oracle-instantclient18.3-basic-18.3.0.0.0-1.x86_64.rpm |
Installation has completed. But we need to do the following configuration for the client to work properly.
First we update the link.
1 | sudo sh -c "echo /usr/lib/oracle/18.3/client64/lib > \ /etc/ld.so.conf.d/oracle-instantclient.conf" |
After this process, we execute the following command.
1 | sudo ldconfig |
We define the environment LD_LIBRARY_PATH;
1 | export LD_LIBRARY_PATH=/usr/lib/oracle/18.3/client64/lib:$LD_LIBRARY_PATH |
After installing the above Rpm package, I recommend that you install the following packages to avoid problems.
Since I installed the Oracle client version 18.3, I downloaded below versions and you should download them according to your version.
- oracle-instantclient18.3-sqlplus-18.3.0.0.0-1.x86_64.rpm
- oracle-instantclient18.3-devel-18.3.0.0.0-1.x86_64.rpm
