Data Replication 2
Results 1 to 1 of 1

Thread: SQL Server 2014 and CDC - ORACDC511E:The Oracle CDC failed to position

  1. #1
    vradermecker is offline Junior Member
    Join Date
    Feb 2015
    Rep Power

    SQL Server 2014 and CDC - ORACDC511E:The Oracle CDC failed to position


    I'm currently trying to install CDC for SSIS on a SQL Server 2014 (Cumulative Update 5) to replicate Oracle data.

    Here is the info related to the Oracle Server :

    Oracle Database 11g Enterprise Edition Release - 64bit Production
    PL/SQL Release - Production
    CORE Production
    TNS for IBM/AIX RISC System/6000: Version - Production
    NLSRTL Version - Production

    I'm facing the usual "Logger" status issue and find the following error messages in the log file :

    "2/9/2015 3:13:34 PM","ERROR","WDDCZC3419JR2","SUSPENDED","LOGGER"," ORACDC514E:Failed to add redo log with sequence 502.","source","",""
    "2/9/2015 3:13:34 PM","TRACE","WDDCZC3419JR2","SUSPENDED","LOGGER"," ORACDC000T:Error encountered at set position - EOF simulated","source","",""
    "2/9/2015 3:13:34 PM","ERROR","WDDCZC3419JR2","SUSPENDED","LOGGER"," ORACDC511E:The Oracle CDC failed to position.","source","",""

    In attachment, you will find the detailled log file and the diagnostic queries result.

    Thanks in advance for your help.

    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts