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