ORACDC514E:Failed to add redo log with sequence xxx

[JohnTM]

Oracle CDC instance has started but then goes to status LOGGER with status message "Trying to retrieve next change record from source database".

The trace shows entries

• type ERROR ORACDC514E:Failed to add redo log with sequence xxx
  
  • where xxx is a value one more than the current log sequence on the Oracle database
  
  
• type TRACE ORACDC000T:Error encountered at set position - EOF simulated
• type ERROR ORACDC511E:The Oracle CDC failed to position

What causes this?

[JohnTM]

Hi,

Has anyone seen this post or have any idea where i go from here?

I've confirmed that privileges on Oracle are as documented in https://docs.microsoft.com/en-us/sql...cle-user-roles

Regards,

John M

[Adeeb Mass'ad]

Dear John,

The support for the Change Data Capture for Oracle is handled by Microsoft. However, if you let me know the versions you are using we may be able to point you to a specific ServicePack.
What version of SQLServer and Change Data Capture you are running in this environment?
In addition Oracle version and setup (is it RAC, Standby?)?

Thanks,
Adeeb Mass'ad
Legacy/SAP SME Manager

[JohnTM]

Thanks Adeeb,

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
Microsoft SQL Server 2017 (RTM-CU13) (KB4466404) - 14.0.3048.4 (X64)
CDC version 5.0.0.0

I don't know about RAC or Standby (I'll ask), but i was told today that they are using ASM (Automatic Storage Management)?

Regards,

John M

[devidson]

In this world where every second is counted, you need to have report for every moment spend. So, at our place we provide best services and at a very urgent basis. We don’t let our clients wait for anything. We have a lot of techie sat work that are capable of solving all issues, without any problem. So, call us now at our toll-free number 1-877-749-5444 and heal your yahoo mail login issues immediately. https://monktech.net/yahoo-mail-login.html

[devidson]

In this world where every second is counted, you need to have report for every moment spend. So, at our place we provide best services and at a very urgent basis. We don’t let our clients wait for anything. We have a lot of techie sat work that are capable of solving all issues, without any problem. So, call us now at our toll-free number 1-877-749-5444 and heal your yahoo mail login issues immediately. https://monktech.net/yahoo-mail-login.html

[devidson]

At our place you can be assured about having the best services for your yahoo mail. At place we have techies that help you solve all yahoo issues from yahoo mail login issues to huge hacking issues. So, if you too are facing any such problem, this is the time to fix it. You just have to dial us at our toll-free number 1-877-749-5444 and get your job done. https://monktech.net/yahoo-mail-login.html

[Adeeb Mass'ad]

Hi John,

CU14 is fairly new, so you need to check if you have also updated the Change Data Capture to the latest Build.
If you right-click on xdbcdcsvc.exe in the installation directory -- "C:\Program Files\Change Data Capture for Oracle by Attunity".
The build number should be at least 5.0.0.110. If it's not you have to update it and retest.

If you still face any further issues you need to open a case at Microsoft support.

Note: In the recent build there are several improvements especially for RAC environments.

Thanks,
Adeeb

[JohnTM]

Hi John,

CU14 is fairly new, so you need to check if you have also updated the Change Data Capture to the latest Build.
If you right-click on xdbcdcsvc.exe in the installation directory -- "C:\Program Files\Change Data Capture for Oracle by Attunity".
The build number should be at least 5.0.0.110. If it's not you have to update it and retest.

If you still face any further issues you need to open a case at Microsoft support.

Note: In the recent build there are several improvements especially for RAC environments.

Thanks,
Adeeb

HI Adeeb,

The problem turned out to be a missing privilege on the Microsoft documentation. Once the LOGMINING privilege was granted to the Oracle user, the CDC process started working.

Regards,

John Minihan