topic Re: Error while connecting to Oracle Endpoint in Qlik Replicate

Error while connecting to Oracle Endpoint

Anismohamed32 — Sat, 16 Nov 2024 00:00:04 GMT

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.

Re: Error while connecting to Oracle Endpoint

Madhavi_Konda — Thu, 10 Sep 2020 12:36:03 GMT

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

Re: Error while connecting to Oracle Endpoint

Bill_Steinagle — Fri, 11 Nov 2022 14:04:56 GMT

Hi,

Thank you for the post to the QDI Forums. For the Linux Setup and connecting to Oracle Source you need to ensure the ODBCINST.ini and ODBC.ini files are updates properly and you can connect via using the UnixODBC sample Program isql connecting to the Datasource. To check the location of the ODBC installation and the variables to the ODBCINST and ODBC file you can run the odbcinst -j command from the ODBC bin directory. Make sure the path is correct and the libraries are defined correctly.

Thanks!

Bill