Re: Oracle AQ Question
- From: Ujang Jaenudin <ujang.jaenudin@xxxxxxxxx>
- To: tomdaytwo@xxxxxxxxx
- Date: Wed, 17 Mar 2010 08:50:32 +0700
thomas,
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@xxxxxxxxx> 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
Other related posts:
