OCI Error Encountered – Oracle

Asked By fern bonnie 30 points N/A Posted on - 08/16/2012

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!

• Status: Open
• Question Views: 4807
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Development Software

Answered By Carl Jack 10 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.

Regards,

Carl

 

About Carl Jack

Questions
1

Answers
1657

Best Answers
417

• Vote Up 0 Vote Down

• Posted on - 08/16/2012
• Question Category: Development Software