Error when trying connecting to Oracle DB as Source

RTS23 — Thu, 24 Nov 2022 03:52:57 GMT

Hello, I'm trying to connect to oracle DB as source and give me this error

My oracle database is 19c client.

I already make symbolic link and also change site_arep_login.sh to my oracle lib location.

Thank you

Re: Error when trying connecting to Oracle DB as Source

SachinB — Thu, 24 Nov 2022 04:51:05 GMT

You will most likely find that the user didn't follow the prerequisites for oracle from the user guide. In this case most likely he didn't create a symbolic in the $Oracle_Home\lib directory and called it "libclntsh" and pointed the link towards another file like this but with a specific version.

Could you please cross-check on these steps :

Create a symbolic link in the $Oracle_Home\lib directory. This link should be called "libclntsh.so"
point that symbolic link to a specific version of the "libclntsh.so", based on the oracle client you have installed
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

This information can be found in Replicates user guide:
https://help.qlik.com/en-US/replicate/November2021/Content/Replicate/Main/Oracle/oracle_prerequisites.htm

Regards,

Sachin B

Re: Error when trying connecting to Oracle DB as Source

narendersarva — Mon, 28 Nov 2022 16:24:18 GMT

Hello @RTS23 ,

I agree with Sachin on the above recommendations.

Along with that, please try to restart the Replicate server in order for it to read the modified site_arep_login.sh file

Thanks
Naren

topic Error when trying connecting to Oracle DB as Source in Qlik Replicate

Error when trying connecting to Oracle DB as Source

Re: Error when trying connecting to Oracle DB as Source

Re: Error when trying connecting to Oracle DB as Source