SYS-E-HTTPFAIL, Stream component initialization function has failed for component 'Oracle', type 'Oracle'..

[SaranyaK]

All - I am getting  a following error in my Oracle connection

• 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.

Any idea what is causing this?

[SwathiPulagam · Accepted solution]

Hi Saranya,

for the error :

The operation completed successfully. Cannot load <oci.dll>

1. make sure you have the Oracle client install, and then Restart the Replicate windows services.

2. This looks like a missing path to the latest oracle client.

2 of the paths Is the ORACLE_HOME system level environment variable

3. we have a similar case :
it was resolved by removing/renaming the oci.dll from system32. After removing the dll, please restart the replicate service and try again.

Thanks,

Swathi

[SaranyaK]

Thank you Swathi!!! That fixed it!