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
