Quick Guide: Installing and Configuring Oracle 21c Instant Client on Linux for Qlik Replicate

john_wang — Thu, 26 Sep 2024 06:18:57 GMT

This guide provides a step-by-step process for installing and configuring the Oracle 21c Instant Client for use with Qlik Replicate. Note that Qlik Replicate should already be installed before proceeding.

For more information, Setting up Qlik Replicate on Linux, a comprehensive list of supported Linux platforms and prerequisites, refer to the Supported Linux Platforms section in the User Guide.

Environment

Qlik Replicate All versions
Oracle Server All Versions

Installation steps

Download the Oracle 21c Instant Client and upload it to your Linux Server

Basic Package (OL8 RPM) -- oracle-instantclient-basic-21.15.0.0.0-1.el8.x86_64.rpm (55,941,296 bytes) (cksum - 1362728982)

(optional) SQL*Plus Package (OL8 RPM) -- oracle-instantclient-sqlplus-21.15.0.0.0-1.el8.x86_64.rpm (726,996 bytes) (cksum - 4146549440)

While Qlik Replicate does not require SQLPlus, it is strongly recommended for troubleshooting connectivity issues.

If the Linux server running Qlik Replicate has internet access, you can download the Oracle Instant Client directly using curl commands. Follow the instructions below for a smooth installation process:
```
curl -O https://download.oracle.com/otn_software/linux/instantclient/2115000/oracle-instantclient-basic-21.15.0.0.0-1.el8.x86_64.rpm
curl -O https://download.oracle.com/otn_software/linux/instantclient/2115000/oracle-instantclient-sqlplus-21.15.0.0.0-1.el8.x86_64.rpm
```
Install the 2 rpm files:
- rpm -ivh oracle-instantclient-basic-21.15.0.0.0-1.el8.x86_64.rpm
- rpm -ivh oracle-instantclient-sqlplus-21.15.0.0.0-1.el8.x86_64.rpm
Confirm the installation folder:

rpm -qal|grep oracle | grep libclntsh.so
In this example we got: /usr/lib/oracle/21/client64/lib/libclntsh.so
Edit file /opt/attunity/replicate/bin/site_arep_login.sh

add /usr/lib/oracle/21/client64/bin to variable PATH
add /usr/lib/oracle/21/client64/lib to variable LD_LIBRARY_PATH
For example:

export PATH=$PATH:/opt/google-cloud-sdk/bin:/usr/lib/oracle/21/client64/bin

export LD_LIBRARY_PATH=/usr/lib64:/opt/attunity/replicate/lib:/opt/ibm/db2/V11.5/lib64:/usr/lib/oracle/21/client64/lib
Run the script file and restart the Qlik Replicate Service:

sudo su - attunity

cd /opt/attunity/replicate/bin
source arep_login.sh
./areplicate stop
./areplicate start
Access the Qlik Replicate console using the following URL

https://192.168.33.182:3552/attunityreplicate

Where 192.168.33.182 is the Qlik Replicate Linux Server IP Address.

Oracle client and server connectivity test

To verify the connectivity between the Oracle client and server, you can use SQLPlus by running the following commands:

sudo su - attunity

cd /opt/attunity/replicate/bin
source arep_login.sh
sqlplus scott/tiger@192.168.33.210:1521/orcl

In this example, scott/tiger@192.168.33.210:1521/orcl represents the Oracle connection string

article Quick Guide: Installing and Configuring Oracle 21c Instant Client on Linux for Qlik Replicate in Official Support Articles

Quick Guide: Installing and Configuring Oracle 21c Instant Client on Linux for Qlik Replicate

Environment

Installation steps

Oracle client and server connectivity test