Advanced Queuing Schedule Propagate does not work between DBs

3004

Hi,

we want to transfer messages between different databases on ORACLE 8.1.6.1 (Windows NT 4 SP6). When we use the procedure schedule propagate, we got no error message in DBA_QUEUE_SCHEDULES, but no data is found in the destination queue on the target DB. The database link to the other DB works. The propagation runs, because we see that sequentially job numbers are assigned (AQ$_SCHEDULES). In the same DB the propagation works properly. In which way can we find out, what is wrong? I already read the "AQ to a remote database" and the "Propagation over instances" postings.

Kindest regards,

Dirk
null

3004

Hi,
Did you see any snp trace files? If so, that might give you some lead as to what error happened.

3004

<BLOCKQUOTE><font size="1" face="Verdana, Arial, Helvetica">quote:</font><HR>Originally posted by kmeiyyap ():
Hi,
Did you see any snp trace files? If so, that might give you some lead as to what error happened.<HR></BLOCKQUOTE>

There are trace files, but they have nothing to do with my AQ job.

null