Share via

how to fix ErrorCode=OracleConnectionOpenError,'Type=Microsoft.

Azam Shaikh, Ather 0 Reputation points
2026-04-17T10:43:22.45+00:00

ErrorCode=OracleConnectionOpenError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to open the Oracle database connection.,Source=Microsoft.DataTransfer.Connectors.OracleV2Core,''Type=Oracle.ManagedDataAccess.Client.OracleException,Message=ORA-50000: Connection request timed out,Source=Oracle Data Provider for .NET, Managed Driver.. adf to oracle connection

Azure Data Factory
Azure Data Factory

An Azure service for ingesting, preparing, and transforming data at scale.

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Amira Bedhiafi 42,936 Reputation points MVP Volunteer Moderator
    2026-04-17T17:43:38.0533333+00:00

    Hello Azam !

    Thank you for posting on MS Learn Q&A.

    ADF could not get an Oracle session in time and I don't think that the username or the pwd is wrong. The error means the database server did not deliver a connection within the allowed time and Oracle distinguishes that from pooled connection request timed out which is specifically pool exhaustion.

    https://docs.oracle.com/cd/E85694_01/ODPNT/featConnecting.htm

    If you are copying many tables or running several activities at once, Oracle can hit session or listener limits and ADF starts failing while opening connections. You should try to test it with fewer tables per batch to the lower parallelism.

    Try to increase the Oracle connection timeout in the linked service or the connection string and put Validate Connection=true as a way to avoid bad or stale pooled connections being handed back to the client. This can help when connections intermittently fail after being idle or after network interruptions. (

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.