oracle database connection

[RSajith1692193231]

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]

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]

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 · Accepted solution]

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.

[SushilKumar]

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