Prev: Missing @bitmap parameter
Next: Transaction log replication
From: stephanie on 6 Jan 2010 04:04
After testing, the replication works fine with Oracle9i with table over 160k
records while the performance is really poor in Oracle10G.

Does SQL2005 oracle replication function support Oracle10G? Seems the
replication PROCEDURE PollEnd doesn't work well in Oracle10G and made the
perofrmance degrading.

"hilary" wrote:

> This status message merely means that the agent is working (or hung) and has
> not communicated with the replication subsystem yet.
>
> You will need to set your hearbeat_interval to something larger. To this
> issue the following command:
>
> USE master
> exec sp_changedistributor_property @property = N'heartbeat_interval', @value
> = 30;
> GO
>
> This sets it for 30 minutes.
>
>
> "stephanie" <stephanie(a)discussions.microsoft.com> wrote in message
> news:50372D17-EA5B-4202-8ACC-A15177AF993C(a)microsoft.com...
> > Hi,
> > I am using SQLserver2005 Oracle replication function to replicate data
> > from
> > Oracle10g DB. I found that the log agent showing 'The replication agent
> > has
> > not logged a progress message in %ld minutes. This might indicate an
> > unresponsive agent or high system activity. Verify that records are being
> > replicated to the destination and that connections to the Subscriber,
> > Publisher, and Distributor are still active.'
> >
> > There is no other acitivity in SQL server2005 and Oracle 10g DB and I
> > found
> > that there is huge records in hrepl_poll and hrepl_articlexxxLog_1(the
> > builtin tables in sql2005 oracle replication setup). Finally, I found
> > that
> > the sql is not responding in Oracle.
> >
> > DELETE FROM HREPL_ARTICLE1469LOG_1 WHERE EXISTS (SELECT p.POLL_POLLID
> > FROM
> > HREPL_POLL p WHERE CHARTOROWID(l.ROWID) = p.Poll_ROWID
> > AND p.Poll_PollID = :Pollid)
> >
> > After I truncate the table HREPL_ARTICLE1469LOG_1 and corresponding
> > records
> > in hrepl_poll. The log agent resumed normal. Any solution or advise?
> >
> >
> >
>
 | 
Pages: 1
Prev: Missing @bitmap parameter
Next: Transaction log replication