Solved

CData Sync Oracle CDC using logminer fails

  • 8 March 2024
  • 1 reply
  • 75 views

Badge

I am having an issue with my sync installation. I am able to successfully start logminer on the oracle instance and query the results of that logminer session.

However, when I run a CDC job from Sync, it will complete the initial data load successfully but then fail on the incremental loads after the initial one with the below error:

logminer failed to start

 

If I have it delete the table ot truncate the data then it reloads just fine. It just won’t start logminer to run the CDC loads.

Has anyone run into this issue or found a way to resolve this so I can get CDC loads from oracle to sql server working correctly?

 

icon

Best answer by Ankit Singh 16 May 2024, 15:41

View original

1 reply

Userlevel 5
Badge +1

Hey @Steve R 

Looking at the Sync logs would get more details on what is causing the issue. I’d recommend you to also check whether the Logminer CDC is enabled for Oracle DB or not by following the steps here: https://cdn.cdata.com/help/ASK/sync/Oracle-Source.html#enable-oracle-logminer-for-cdata-sync.

If everything checks out, I’d recommend reaching out to our Tech Support team by submitting a Support Form here: https://www.cdata.com/support/submit.aspx or emailing us at support@cdata.com

Let me know if this helps!
 

Reply