OCI Error Encountered – Oracle

Asked By 30 points N/A Posted on -

Hello TechyV buddies!

I am having some issue using Oracle. I was using BIDS(Visual Studio) 2008 R2 with Attunity Oracle Provider 1.1 (source SSIS component) against Oracle, Oracle Database 10g Enterprise Edition Release – 64bi. My dev. box is a 32bit machine, running WinXP Pro. Using TNSNames.ora on my dev. Box allows me to connect to this Oracle database using SQL DEVELOPER smoothly and with no issues.




(ADDRESS = (COMMUNITY = TCP.na.smurfit.com)(PROTOCOL = TCP)(Host = mchir008)(Port = 1522)) )





The Attunity provider have no issues or any errors at the beginning. However, an error suddenly appeared to show this:

"OCI Error Encountered" message.

This is a Visual Studio message and states only, "OCI Error Encountered".

Can anyone help me solve this issue? I don’t know what went wrong with my provider. I will really appreciate the effort in solving this. Thank you!

Answered By 0 points N/A #147392

OCI Error Encountered – Oracle


Hello Fern,

To resolve the issue you are getting when using Oracle, you will need to use the following workaround:

You will need to create a symbolic link folder and after that start the BIDS using the symbolic link you will have created. The following are the steps:

  • First you will need to download the junction from the following link: https://docs.microsoft.com/en-us/sysinternals/downloads/junction
  • And then you will extract the compressed/zipped application.
  • After that you will create a junction such as by invoking -> junction  ”C:IDE”   “C:Program Files (x86)Microsoft Visual Studio 9.0Common7IDE”
  • After that you will launch from C:IDE

Hope this helps.




Login/Register to Answer

Related Questions