Oracle Connection Failed

Question

When i am trying to integrate my external oracle data base with azure synapse through ingestion. it shows me ERROR 9603

Details
ERROR [08S01] [Microsoft][ODBC Oracle Wire Protocol driver]Socket closed.
ERROR [08001] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-12203: unable to connect to destination
Activity ID: 1eae2db7-a7ef-494f-b87e-a08744603682.

Answer 1

Hi @AASMA SIDDIQUI ,

Welcome to Microsoft Q&A platform and thanks for posting your question here.

As I understand your issue, you are facing error with code as 9603 while connecting to Oracle database via Synapse. Please let me know if my understanding is incorrect.

Error 9603 occurs when you are using outdated version of self hosted IR , Kindly uninstall the version you are using and install the latest version .

1. Uninstall the Self Hosted Integration Runtime. When the below dialog box appears, please say no:

 
2. Install  SHIR version IntegrationRuntime_5.22.8312.1.msi or above . Here is the link to download this SHIR version: https://www.microsoft.com/en-us/download/details.aspx?id=39717
 
3. After installing, please disable the auto-update feature in ADF portal for now:

Hope this will help. Please let us know if any further queries.

---

• Please don't forget to click on or upvote button whenever the information provided helps you.
  Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Answer 2

Hi,

I am facing exactly same issue with Oracle 19c Db where as no issues with Oracle 12c db.

As you mentioned i have updated IR and tried to create connection. But same issue.

Kindly help on this.

Thank You,
Venkat