topic Re: oracle database connection in Qlik Replicate

oracle database connection

RSajith1692193231 — Fri, 15 Mar 2024 11:52:50 GMT

Getting the following error while creating an oracle connection a the source

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.

where do I have to add the oci.dll file?

Heinvandenheuvel — Fri, 15 Mar 2024 11:57:17 GMT

Oci.dll comes with a proper Oracle client install. If this is a fresh client install then you need to restart the Replicate service.

For improper (copy!) Installs you'll need the add the path to the system path or Replicate user context and restart the service.

Be sure to read up on the Oracle requirements in the Replicate User Guide.

Hein.

RSajith1692193231 — Fri, 15 Mar 2024 12:32:30 GMT

i did the client install and restarted the server, but the error still persists. Do I have to change the location of the oracle install?

john_wang — Fri, 15 Mar 2024 12:39:56 GMT

Besides @Heinvandenheuvel comment, I'd like suggest you remove the existing installation, and install the instant client, see relevant articles:

Hope this helps.

John.

SushilKumar — Fri, 22 Mar 2024 02:07:35 GMT

Set the LD_LiBRARY_PATH in the Site_arep_login.sh under bin directory

and follow the Prerequisite section of Client install. it may require some soft link creation as well.

Regards,

Sushil Kumar