Search:

Type: Posts; User: mikedba; Keyword(s):

Search: Search took 0.00 seconds.

  1. I had a similar issue once. Try a reboot of the...

    I had a similar issue once. Try a reboot of the CDC server (I found restarting the CDC services was not enough).
  2. SQL Server will need to be upgrade to 2016 to...

    SQL Server will need to be upgrade to 2016 to support Oracle 12c as the source:
    https://msdn.microsoft.com/en-us/library/dn175418.aspx
  3. Replies
    3
    Views
    4,744

    This worked on Oracle 11r2 but isn't working on...

    This worked on Oracle 11r2 but isn't working on Oracle 12c. Has anyone found a solution short of granting DBA?
  4. G'day, I had the exact same issue but I was using...

    G'day, I had the exact same issue but I was using the wrong (old) version of the connector.

    Try the v4.0 of the connector:
    https://www.microsoft.com/en-us/download/details.aspx?id=52950

    I can...
  5. Replies
    3
    Views
    3,314

    A failover is activating the standby database...

    A failover is activating the standby database typically when the primary site is unavailable, the database becomes a new incarnation (so it is open with a restlogs) and the log sequence is reset back...
  6. Great minds must think alike as I create a table...

    Great minds must think alike as I create a table in the source oracle database with a database job that updates a row every minute which comes in handy for so many different reasons as below:

    ...
  7. Replies
    1
    Views
    2,095

    Have you tested that the issue is in the SSIS...

    Have you tested that the issue is in the SSIS layer and not in the CDC query, try running cdc.fn_cdc_get_net_changes_<capture_instance> in SSMS and check your timings?


    On a side note I found the...
  8. Replies
    3
    Views
    3,314

    Was it a failover (ie did the standby database...

    Was it a failover (ie did the standby database get activated) or was it a switch over?

    If it was a failover then the Oracle database is a new incarnation with the archivelog sequence number set...
Results 1 to 8 of 8