Integration Runtime Oracle database connection error ERROR [08S01]

Thijs van Berkel 31 Reputation points
2021-10-29T14:01:42.167+00:00

When connecting to an external Oracle database with Integration Runtime (5.9.7949.2) the following error pops up after trying to copy data in the Azure Data Factory:
ErrorCode=UserErrorFailedToConnectOdbcSource,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [08S01] [Microsoft][ODBC Oracle Wire Protocol driver]Socket closed.

ERROR [08001] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]Connection Dead.,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=System.Data.Odbc.OdbcException,Message=ERROR [08S01]

This Integration Runtime worked perfectly before and suddenly stopped working. At the Oracle database side, no settings were changed. At our side, we did not change settings either. The Integration Runtime is still running in the Data Factory.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,539 questions
Accepted answer
  1. KranthiPakala-MSFT 46,422 Reputation points Microsoft Employee
    2021-11-01T14:29:05.31+00:00

    Hi @Thijs van Berkel ,

    Welcome to Microsoft Q&A forum and sorry for your experience because of this issue.

    As per discussion with internal team, this has been identified as a bug with SHIR version >= 5.9.7900.1.

    Product team is actively working with the driver team to find root cause and fix it. In the meantime as a mitigation, could you please try installing SHIR version 5.9.7894.1 (Downgrade SHIR to version < 5.9.7900.1) and let us know if the problem while testing connection persists?

    Here is the link to download this SHIR version: https://download.microsoft.com/download/E/4/7/E4771905-1079-445B-8BF9-8A1A075D8A10/IntegrationRuntime_5.9.7894.1.msi

    After installing, please disable the auto-update feature in ADF portal for now (until this is fixed permanently).

    We will keep you posted here as we have further updates from the product team.

    Apologies for the inconvenience caused because of this issue.

    Thank you

    1 person found this answer helpful.

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Prashant 0 Reputation points
    2023-08-07T18:50:19.2033333+00:00

    Hi @KranthiPakala-MSFT - I'm facing similar error & tried to download the old version 5.9.7894.1. However this is giving me error while setting up IR - "Selfhosted Integration Runtime already expired, please upgrade it first". Can someone help on this?

  2. Patrick 1 Reputation point
    2023-08-07T19:28:29.0033333+00:00

    The original answer to this issue no longer works. As of today SHIR 4.15.7611.1 still works and resolves issues we have with oracledbs getting socket closed errors.
    https://go.microsoft.com/fwlink/?linkid=2165330

    0 comments