topic Re: Fabric Pipeline Oracle Connection Issues in Data Engineering

Fabric Pipeline Oracle Connection Issues

smoqt — Thu, 07 Aug 2025 17:07:42 GMT

Since 2025-08-05, I am seeing frequent but intermittent failures from Fabric Pipelines that connect to, ingest from, or query Oracle databases (even databases on separate servers). Anyone else experiencing this?

Error Message:
Cannot load managed ODP.NET driver.

Full Exception Message:
Exception: ''Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to open the Oracle database connection.,Source=Microsoft.DataTransfer.Connectors.OracleV2Core,''Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Cannot load managed ODP.NET driver. Please make sure the driver is installed on your machine.,Source=Microsoft.Connectors.OracleUnbundle,''Type=System.ArgumentException,Message=Unable to find the requested .Net Framework Data Provider. It may not be installed.,Source=System.Data,'''

Re: Fabric Pipeline Oracle Connection Issues

v-achippa — Fri, 08 Aug 2025 10:35:10 GMT

Hi smoqt,

Thank you for reaching out to Microsoft Fabric Community.

The Fabric pipeline’s Oracle connector is trying to load the managed ODP.NET provider. The runtime that executes the connector does not have a compatible ODP.NET installed or the installed driver’s bitness or version is incompatible with the connector.

Recent updates to the Oracle connector and SHIR/gateway components have made them stricter about the managed ODP.NET driver, so the issue can be intermittent when runs are routed to hosts without the correct driver or version.

So the driver must be present on the machine that executes the connector.

Identify which SHIR/gateway host ran the failed job, check the pipeline run details for this.
On that host install the ODP.NET managed driver, that matches the host bitness. After installation restart the SHIR/gateway service and re run the pipeline.
If you have multiple SHIR or gateway nodes in a cluster, make sure all nodes have the same ODP.NET driver version and bitness installed to avoid the intermittent failures

Please refer below documents:

https://docs.oracle.com/en/database/oracle/oracle-database/19/odpnt/installODPmd.html

https://learn.microsoft.com/en-us/fabric/data-factory/connector-oracle-database-overview

If this post helps in resolving the issue, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Thanks and regards,

Anjan Kumar Chippa

Re: Fabric Pipeline Oracle Connection Issues

v-achippa — Mon, 11 Aug 2025 12:41:03 GMT

Hi smoqt,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

Re: Fabric Pipeline Oracle Connection Issues

v-achippa — Thu, 14 Aug 2025 11:41:07 GMT

Hi @smoqt,

We wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

Re: Fabric Pipeline Oracle Connection Issues

v-achippa — Mon, 18 Aug 2025 06:58:26 GMT

Hi @smoqt,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

Re: Fabric Pipeline Oracle Connection Issues

smoqt — Fri, 29 Aug 2025 13:26:03 GMT

This did resolve the issue. Thank you.