Re: Oracle AQ Question

thanks for your sharing....
I have a couple of small project of AQ, the first priority was AQ inside database and has no propagation at all.. and it is almost completed, the second is AQ with propagation which a week ago I have tried on dev and got stuck on propagation....

I will update if the same behavior also occurring on mine...

On Wed, Mar 17, 2010 at 1:23 AM, Thomas Day <tomdaytwo_at_gmail.com> wrote:

> I would not have believed it but that was the issue. I solved it by adding
> names.default_domain to the sqlnet.ora file (it was previously null) and
> then adding the default_domain string to the db_link string in the sys.aq$_agent
> definition of the recipients part of the message_properties.
>
> My great thanks to you.
>
> I'm a little incredulous that db links, sqlplus, ... everything else worked
> fine, but AQ wouldn't even raise the whimper of an error message. Oh well,
> just another day in Oracle land.
>

-- 
thanks and regards
ujang | oracle dba | mysql dba
jakarta - indonesia

--
http://www.freelists.org/webpage/oracle-l