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.
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?