topic Re: Oracle in Qlik Replicate

Oracle

sardarabdullahkhawar — Wed, 20 Dec 2023 08:03:19 GMT

Hi all,

hope you guys are doing well. I am trying to connect Oracle database as my source and another Oracle database as my target. Replicate is on another server. I got this error "

SYS-E-HTTPFAIL, Stream component initialization function has failed for component 'Oracle', type 'Oracle'..
SYS,GENERAL_EXCEPTION,Stream component initialization function has failed for component 'Oracle', type 'Oracle'.,Cannot load <oci.dll, >: The operation completed successfully. Cannot load <oci.dll>: The specified module could not be found."

and the answer i found is this to install oracle client on my QDI server? and add path to local oracle client?? Could anyone explain this in simple terms. Thanks!

Re: Oracle

john_wang — Wed, 20 Dec 2023 08:36:44 GMT

Hello @sardarabdullahkhawar ,

Welcome to Qlik Community forum and thanks for reaching out here!

Qlik Replicate is zero-footprint for most of the source and target systems thereby reducing the intrusion in the databases and data systems. In your scenario, 64-bit Oracle client is required to install on Replicate Server, see detailed information in User Guide section Install Oracle Instant Client. Qlik Replicate connect to Oracle server via Oracle client components.

Hope this helps.

Regards,

John.

Re: Oracle

john_wang — Wed, 20 Dec 2023 09:31:54 GMT

Hello @sardarabdullahkhawar ,

Please troubleshoot the connectivity issue by using Oracle SQLPLus (run it on the Replicate server), it's much easier than trace the issue within Qlik Replicate. If SQLPlus works then Replicate will work as well. The classic command likes:

sqlplus scott/tiger@192.168.33.212:1521/orcl

where scott/tiger is the username/password, IP, port number and instance name is the Oracle connection string.

Please have a look at other helpful links:

1. run SQLPLus on the Replicate server to troubleshoot

2. install instant client

Good luck,

John.

Re: Oracle

sardarabdullahkhawar — Thu, 21 Dec 2023 08:29:43 GMT

Thank you, John_wang, for your reply. We are using an enterprise license, and the installation is on Linux. I have reached out to the database administrator, and he mentioned that there is no need for a separate installation. However, I am considering the possibility that the issue may be related to the lack of permissions for the Oracle database user provided to us.

If I obtain the permissions outlined for the source DB user in the documentation (https://help.qlik.com/en-US/replicate/May2023/Content/Global_Common/Content/SharedReplicateHDD/Oracle/OracleDBSource_Security.htm), do you think this could resolve the issue?

Thanks for your assistance

Re: Oracle

Heinvandenheuvel — Fri, 22 Dec 2023 02:38:27 GMT

>> If obtain the permissions outlined for the source DB... do you think this could resolve the issue?

NO absolutely not. You are not connecting the the DB. It does not yet know the username nor its privs trying to connect.

READ the error message: ...Cannot load <oci.dll, >:

Typically that's an issue with PATH or LD_LIBRARY_PATH environment variable in the REPCTL process context.

It can also be a privilege/protection issue for the Replicate username to touch the Oracle files on the Replicate server.

Did you try to access using SQLplus as adviced? READ, Answer.

Regards,

Hein.