Advanced Queues -- problem (Urgent!)

Dear netters!

We have 2 Oracle 8.1.7 servers set up. One server (call it P) is working as the publisher, another one (S) is the subscriber. There is a DB-link defined from P to S, using a user id P_TO_S_USER.

A user on P (P_USER) owns a queue/queue table, which were defined as compatibility=8.1, multiple consumers=TRUE, and is granted the AQ_ADMINISTRATOR_ROLE. A user on S (S_USER) owns a queue/queue table, which were defined as compatibility=8.1, multiple consumers=TRUE, and is granted the AQ_ADMINISTRATOR_ROLE. A subscriber is added on P, with agent defined as follows:   agnt := sys.aq$_agent(NULL, sub_queue_name || '@' || db_link, NULL);   DBMS_AQADM.ADD_SUBSCRIBER(queue_name => pub_queue_name, subscriber
=> agnt );

The queues are started on both servers, and propagation is scheduled and enabled. The enqueued messages, however, sit on the P server in the state of 0...

In the initial tests we ran, the queue owner names on both sides were the same. And it worked fine...

Are we missing something on the permissions? Is there anything else that needs to be granted to: P_USER, S_USER and P_TO_S_USER IDs?

Thank you very much for your timely response!

--Alex Vilner Received on Fri Aug 09 2002 - 12:37:45 CDT