topic Re: Testing Data Mirroring of Oracle on Azure Fabric in Fabric platform

Testing Data Mirroring of Oracle on Azure Fabric

XhevahirMehalla — Tue, 14 Oct 2025 08:38:28 GMT

Hello -

I am trying to test test Data Mirroring for Oracle.

I have a connection created to an on-prem database and is working is online.

I need to test the data mirroring to Onelake.

These are the settings:

Fabric Trial License
Fabric workspace
Oracle On-prem database - (nothing done yet to initate the replication).
Connection to Oracle on-prem database created on Fabric workspace as shown below.

Connection that exists now:

Error received now:

What am I missing?

Eventually I want to test this on OCI database and if I get this working then I need to get this working on an OCI database.

Please advise how to create a connection to an OCI Oracle DB.

Thank you.

Re: Testing Data Mirroring of Oracle on Azure Fabric

AntoineW — Tue, 14 Oct 2025 10:52:28 GMT

Hello XhevahirMehalla,

You’re trying to test Data Mirroring for Oracle in Microsoft Fabric using an on-prem Oracle database.
You’ve already created a connection in Fabric, but when you attempt to enable mirroring, you get an error and the replication does not start.

There are a few important prerequisites and limitations for Oracle mirroring in Fabric that must be met before it works — especially when testing with on-premises or OCI Oracle databases.

Version requirements :

Oracle versions 11 and above with LogMiner enabled
Oracle on-premises (VM, Azure VM)
Oracle Cloud Infrastructure (OCI)
Oracle Exadata

Before you set up Oracle mirroring, you need:

A supported Oracle server
LogMiner enabled
Archive log mode enabled
Supplemental logging configured
On-Premises Data Gateway installed and set up
Required user permissions

Here's what you need for your database setup:

A Microsoft Fabric workspace with Trial or Premium Fabric capacity
Install the latest On-Premises Data Gateway (August 2025).

Documentation :

- https://learn.microsoft.com/en-us/fabric/mirroring/oracle-limitations

- https://learn.microsoft.com/en-us/fabric/mirroring/oracle

Hope it can help you !

Best regards,

Antoine

Re: Testing Data Mirroring of Oracle on Azure Fabric

XhevahirMehalla — Tue, 14 Oct 2025 11:18:59 GMT

Thanks

All settings on Fabric is done and I can connect to an Oracle OCI in fact now . I re-installed On-premise Gateway and seem to work. I can get data from Oracle to Data lake House just fine using the new connections.

Now I am trying to Data Mirroring for Oracle but I get this error message.

No changes made to Oracle side . Is this the reason?

Please help!

Thanks

Xhev

Re: Testing Data Mirroring of Oracle on Azure Fabric

prom — Tue, 14 Oct 2025 13:58:10 GMT

Hi,

You are getting ORA-00942 table does not exist error. That means that connection is working. Did you grant those permissions to the oracle's user (Tutorial: Set up Oracle database mirroring in Microsoft Fabric (Preview) - Microsoft Fabric | Microsoft Learn)?

GRANT CREATE SESSION TO user;
GRANT SELECT_CATALOG_ROLE TO user;
GRANT CONNECT, RESOURCE TO user;
GRANT EXECUTE_CATALOG_ROLE TO user;
GRANT FLASHBACK ANY TABLE TO user;
GRANT SELECT ANY DICTIONARY TO user;
GRANT SELECT ANY TABLE TO user;
GRANT LOGMINING TO user;

Re: Testing Data Mirroring of Oracle on Azure Fabric

XhevahirMehalla — Tue, 14 Oct 2025 15:16:09 GMT

Thanks, I need DBA access to grant this roles. Ok fine will do that and test that.

One more question:

In order to load data from Oracle OCI I had to reinstall on-premise gateway. This is just something that is on my machine. In order to make production ready at somepoint; Do I need to create a VM on Azure and install the On-premise-gateway on that machine? Is this how is going to work?

Tomorrow I will test Data Mirroring and if that works I will accept your solution.

Thanks for your help!

Re: Testing Data Mirroring of Oracle on Azure Fabric

prom — Tue, 14 Oct 2025 15:24:48 GMT

You can install gateway anywhere on prem. You need to make sure that it can access Oracle DB. Replication should work as long as the gateway is up. For production use its better to install gw on server, later you can scale up if you need. Use the latest version.

Re: Testing Data Mirroring of Oracle on Azure Fabric

XhevahirMehalla — Wed, 15 Oct 2025 08:05:58 GMT

Hi and thanks again.

I managed to add the grants but I still still an issue.

what could be th reason now?

Pls help!

Thanks

Re: Testing Data Mirroring of Oracle on Azure Fabric

XhevahirMehalla — Wed, 15 Oct 2025 08:41:52 GMT

This seem unreliable now.

It was workingf fine yesterday but today I don't know why this is not working now.

Is the issue with Gateway and when I check this it says "online" for both connection as well as the Gateway.

Where else I can look at?

Reinstall again the gateway?

Thanks

Re: Testing Data Mirroring of Oracle on Azure Fabric

prom — Wed, 15 Oct 2025 09:01:37 GMT

Try network test:

Mirroring from Oracle to Fabric is in preview. You can have some issues.

Re: Testing Data Mirroring of Oracle on Azure Fabric

XhevahirMehalla — Wed, 15 Oct 2025 13:59:05 GMT

I can see this and seem ok to me:

Re: Testing Data Mirroring of Oracle on Azure Fabric

XhevahirMehalla — Thu, 16 Oct 2025 08:28:55 GMT

Hello -

Anyone can help me with error message when I do Oracle Data Mirroring.

The connection is working/ On-premise-gateway.

I can see the Copy Activity is working - copying data from OCI Oracle database :

When I try Data Mirroring I get the error below:

Please can one help!

Re: Testing Data Mirroring of Oracle on Azure Fabric

prom — Thu, 16 Oct 2025 08:36:42 GMT

You need to additionaly setup Oracle's db: Tutorial: Set up Oracle database mirroring in Microsoft Fabric (Preview) - Microsoft Fabric | Microsoft Learn

switch to archivelog mode
enable supplemental logging for db and tables

Re: Testing Data Mirroring of Oracle on Azure Fabric

XhevahirMehalla — Thu, 16 Oct 2025 09:50:10 GMT

The dba has done that and take that for granted.

I have the issue with On-prem-gateway when I switch off the machine I get this classic error message "

Error

Operation on target CopyDtFromOracleOCI-STTM_CUSTOMER failed: Please check your network connectivity to ensure your on-premises data gateway can access we.frontend.clouddatahub.net and restart the service to retry the connection again once the connectivity issue has been resolved

on-premise-gateway looks fine to me now.

I see this as not easily tested.

Unreliable tool. I am spending 2-3 days and still can't get it working.

Thanks

Xhev

Re: Testing Data Mirroring of Oracle on Azure Fabric

Anonymous — Fri, 17 Oct 2025 08:35:55 GMT

Hi XhevahirMehalla ,

Thanks for reaching out to the Microsoft fabric community forum. Also thank you prom and AntoineW for your helpful response.

Thank you for the update, glad to hear your Oracle OCI connection and On-premises Data Gateway are online. Since you’ve applied the necessary grants but are still encountering an issue when starting mirroring, here are a few checks you can perform from your side:

The current error message or activity ID you see after applying the grants.
On the Oracle side: Is the database running in ARCHIVELOG mode? Is supplemental logging enabled for the mirrored tables? Is LogMiner enabled and accessible by the Fabric user? Does the user have all permissions listed in the Mirror Oracle Databases in Microsoft Fabric (Preview) - Microsoft Fabric | Microsoft Learn
On the gateway machine: Is the gateway showing as Online in the Fabric portal? Are there any recent connection or timeout errors in the gateway logs?

Once you’ve reviewed these points, try restarting the mirroring job and share any updated error or activity ID for further review. For production, hosting the On-premises Data Gateway on a dedicated server or Azure VM is recommended for stable connectivity and easier monitoring.

If the issue persists after these checks, we recommend opening an official Microsoft support ticket so the production team can review the mirroring setup with the appropriate access.

For raising support ticket please use the below link: How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Hope this helps. Please feel free to reach out for any further questions.

Thank you .

Re: Testing Data Mirroring of Oracle on Azure Fabric

XhevahirMehalla — Fri, 17 Oct 2025 11:56:47 GMT

Any help on this error message when I try to Data Mirror (Oracle) ?

Things seem to connect ok to Oracle:

On-premise-gateway is up and running
OracleDbConnection which I created and run Copy Pipeline shows the "connection successfull"

When I chose to Data Mirroring for Oracle I use the connection which has been created and used on the Pipeline. This shoould be ok.

Chose this connection:

and this connection is fine:

But Data Mirror is failing as below:

Pls can someone help on this and give me some input!

Re: Testing Data Mirroring of Oracle on Azure Fabric

XhevahirMehalla — Fri, 17 Oct 2025 12:33:29 GMT

Thanks for your reply.

I have checked all.

Oracle setup is done with DBA
Access is done and supplemental steps
I have one table which I want to test and picked that table.
On-premise-gateway is work as I already run copy pipeline to get a table into LakeHouse so I am confident.

Once I chose the Oracle Data Mirroring I get this error message time and time again.

"A task was canceled. Activity ID: 5f4423b8-495d-431f-b429-83e0ab089996 Refresh or troubleshoot the issue.:

I cannot create a ticket as I cannot see Oracle Mirroring there and need to be CSP or something.

Who would know more abou this.

Thanks

Re: Testing Data Mirroring of Oracle on Azure Fabric

Anonymous — Wed, 22 Oct 2025 08:48:34 GMT

Hi XhevahirMehalla ,

This is currently a preview feature that Microsoft is developing. If you need more information, you can submit a support ticket as previously mentioned. Please review the limitations of mirroring Oracle: Mirroring Oracle limitations in Microsoft Fabric - Microsoft Fabric | Microsoft Learn.

Thank you.