Posted - 07/08/2012 : 13:47:23
| Hello all,
We have implemented transactional replication between Oracle and Sql.
Oracle 11g as a publisher and Sql server 2005 as a subscriber.
It worked for a month. We have replicated only 2 tables out of whole dadtabase. But as if now, the records i.e. row count is not syncronising. At oracle side, Logreader.exe is active and at Sql sevrer side there are no error logs as well. Everything is running fine, we restarted the agent as well, But not able to get an synchronized data. In SQL Server, it shows that commands are delivered every now and then.
Confused about the issue. Its urgent as on Production.