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
    Posts
    1
    Rep Power
    0

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

    Hi,

    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 11.2.0.3.0 - 64bit Production
    PL/SQL Release 11.2.0.3.0 - Production
    CORE 11.2.0.3.0 Production
    TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
    NLSRTL Version 11.2.0.3.0 - 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.

    Regards.
    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
  •