Re: AQ on 8.1.7.4.0

From: Ray Teale <ray_at_BLAHholly.com.au>
Date: Tue, 25 Nov 2003 10:31:58 +1100
Message-ID: <muwwb.16$Yj6.1395@nnrp1.ozemail.com.au>

Mike

You cannot dequeue remotely (ie over Net8).

You must create an identical local queue and create that queue as a subscriber to the remote queue.

Then you must set up propagation. See script below which subscribes a queue called XXX_DEST_Q at the dequeue location to one called YYY_SRC_Q at the enqueue location.
No apologies for bugs etc ;-)

_____________________-

• Script to defines subscribers for queues used to replicate voice enrollment objects.
• Final release for production. 11-NOV-2003 -- /* ------------------------------------------------------------------------- */

prompt  ____________________________________________________

prompt aq_addsub.sql

prompt  ____________________________________________________

prompt
prompt This script will add a remote subscriber to local queues. It should be run by the queue
prompt owner for each subscriber.
prompt The script will also ensure the queues are propogated. prompt This should be run after all queues have been created at the remote location.
prompt
prompt

accept destloc prompt "Enter the three letter prefix for the remote location
(eg SYD'): "

accept destdblink prompt "Enter the db link for the remote location (eg SYDLINK'): "
accept origloc prompt "Enter the three letter prefix for the local location
(eg MEL'): "

DECLARE
   subscriber1 sys.aq$_agent;
   /* Add subscriber to the suscriber list: */ BEGIN
   subscriber1 := sys.aq$_agent('&&destloc', '&&destloc._dest_q@&&destdblink', 0);

        DBMS_AQADM.ADD_SUBSCRIBER(queue_name => '&&origloc._src_q', subscriber => subscriber1);

        DBMS_AQADM.SCHEDULE_PROPAGATION( queue_name =>'&&origloc._src_q' , destination=>'&&destdblink');
END;
/

undefine destloc
undefine destdblink
undefine origloc

_____________________-

Regards

Ray

"Mike" <mbrugo_at_despammed.com> wrote in message news:6qvrrvs5oa9ufdk3igssn1tc0oe8obm680_at_4ax.com...

> Hi people,
> doen anyone work with AQ on 8.1.7 ?
> i've downloaded note 102771.1 from metalink
> i follow all steps but i can not dequeue message from remote database.
> from OEM i've no errors on my queues, i generate trace file
> but no errors too.
>
> From a forum on metalink someone talk about some missin operation on
> note.
>
> Does anyone have a documentation (nto from metalink or otn) that
> explain in which mode aq works on oracle ?
>
> TIA
>
> Mike

Received on Mon Nov 24 2003 - 17:31:58 CST