Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
RSajith1692193231
Partner - Contributor
Partner - Contributor

oracle database connection

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?
Labels (2)
1 Solution

Accepted Solutions
john_wang
Support
Support

Hello @RSajith1692193231 ,

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

Cannot create Oracle NLS environment for charset 873 and ncharset 1000 (see my comments there)

or

Cannot load <oci.dll, >

Hope this helps.

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!

View solution in original post

4 Replies
Heinvandenheuvel
Specialist III
Specialist III

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
Partner - Contributor
Partner - Contributor
Author

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
Support
Support

Hello @RSajith1692193231 ,

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

Cannot create Oracle NLS environment for charset 873 and ncharset 1000 (see my comments there)

or

Cannot load <oci.dll, >

Hope this helps.

John.

Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
SushilKumar
Support
Support

Hello @RSajith1692193231 

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.

Installing Oracle Instant Client Using Zip Files

Regards,

Sushil Kumar