none
Oracle -> Sql 2005 replication problem.

    Question

  • I'm a consultant, and have been brought into the middle of a replication project.  The client is looking to replicate the database from Oracle to SQL 2005.  I had the replication working last week, but then problems (I don't know the cause, wasn't on site).  But I tried reinitializing the subscription, and the SQL Log Reader Agent status simply sticks at status=Initializing for about 5 minutes.
    After 5 minutes, it comes up with the message:
    Batch processing is in progress. The current batch consists of 205065 commands and 0 transactions. The last transaction was 0x0000000000000000000c, '0x0000000000000000000c'.
    And the commands continue to increase at the rate of a couple thousand a minute.  The distribution Agent isn't running, and I haven't created a snapshot.
     I do believe there were problems with disk space on both the Oracle and the SQL Server, but those have been taken care of.  And the target database is only used for OLAP (at this point).
     I've run the Dist Cleanup Job, removed the Subscription and rebuilt it.  To no avail.  Unfortunately, I don't have a great access on the Oracle side of it.
     Thoughts?
     Bob
    Wednesday, June 27, 2007 2:35 PM

All replies

  • What happened when you rebuild it? Still giving you the same error message? Can you describe more about your environement and replication setup? Did the problem take place before or after re-initialization? Was the Oracle tables being updated when you were generating the new snapshot?


    Gary

    • Proposed as answer by Vivek Patle Monday, March 05, 2012 7:57 AM
    • Unproposed as answer by Vivek Patle Monday, March 05, 2012 7:57 AM
    Thursday, June 28, 2007 1:19 AM
  • This is temporary message and finally it should fine. Did you check the records on publisher and Subscriber.

    Vivek Patle

    • Proposed as answer by Vivek Patle Monday, March 05, 2012 8:35 AM
    Monday, March 05, 2012 8:35 AM
  • This is temporary message and finally it should fine. Did you check the records on publisher and Subscriber.

    Vivek Patle

    but this is not real time if you requirement is that.

    Vivek Patle Sum Total Systems

    Friday, March 16, 2012 8:36 AM