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

[john_wang]

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

1. 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

   
   
2. 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
     
     
3. Confirm the installation folder:
   
   rpm -qal|grep oracle | grep libclntsh.so
   In this example we got: /usr/lib/oracle/21/client64/lib/libclntsh.so
4. 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
   
   
5. 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
   
   
6. 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