OCI Error Encountered – Oracle

Asked By 30 points N/A Posted on -
qa-featured

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 10.2.0.4.0 – 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.

DWTQ.NA.SMURFIT.COM =

(DESCRIPTION =

(ADDRESS_LIST =

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

(CONNECT_DATA =

(SERVICE_NAME = DWTZ.NA.SMURFIT.COM)

)

)

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!

SHARE
Answered By 10 points N/A #147392

OCI Error Encountered – Oracle

qa-featured

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.

Regards,

Carl

 

About Carl Jack
Questions
1
Answers
1657
Best Answers
417

Oracle Provider --> SQL*Plus script error

Previous

SSIS Oracle Connector Error Using OLEDB with MSORA

Next

Related Questions