Forum Stats

  • 3,816,545 Users
  • 2,259,204 Discussions
  • 7,893,507 Comments

Discussions

Advanced Queuing Schedule Propagate does not work between DBs

3004
3004 Member Posts: 204,171 Green Ribbon
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

Comments

  • 3004
    3004 Member Posts: 204,171 Green Ribbon
    Hi,
    Did you see any snp trace files? If so, that might give you some lead as to what error happened.
  • 3004
    3004 Member Posts: 204,171 Green Ribbon
    <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
This discussion has been closed.