Prerequisites
The following section describes the prerequisites for working with the Qlik Replicate Oracle endpoint.
Support for the XMLTYPE data type requires the full Oracle Client.
Replicate On Windows
Install Oracle Instant Client for Microsoft Windows (x64) Version 12.0 or later.
Replicate On Linux
Install Oracle Instant Client for Linux (x86-64) Version 12.0 or later.
In addition, if not already included in your system, you need to create a symbolic link in the $Oracle_Home\lib directory. This link should be called libclntsh.so, and should point to a specific version of this file.
For example, on an Oracle 12c client:
lrwxrwxrwx 1 oracle oracle 63 Oct 2 14:16 libclntsh.so -> /u01/app/oracle/home/lib/libclntsh.so.12.1
Additionally, append the LD_LIBRARY_PATH environment variable to the Oracle lib directory by copying the driver location to the site_arep_login.sh file as follows:
echo "export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/u01/app/oracle/home/lib/" > site_arep_login.sh
When Replicate is installed on Red Hat 8.1, you must install Oracle Instant Client for Linux (x86-64) Version 12.