Qlik Community

Qlik Replicate

Discussion board for collaboration on Qlik Replicate.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Anismohamed32
Partner
Partner

Error while connecting to Oracle Endpoint

The replicate server is installed on Linux and i am trying to connect to a oracle database as source which is on a different server. While testing the connection i am getting the attached error message. Kindly let me know the root cause of this.

1 Reply
Madhavi_Konda
Support
Support

Hi,
On Linux systems, install Oracle Instant Client for Linux (x86-64) Version 11.2.0.3.0
and above.
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

Thanks,
Madhavi