| Author |
Message
|
| m00300 |
 Posted: Mon Mar 20, 2006 8:41 am Post subject: Oracle Message Gateway - remote queue problems |
 |
|
Apprentice
Joined: 01 May 2002
Posts: 31
|
I'm having trouble trying to get Oracle Message Gateway writing to a remote queue.
Everything works fine when we use local queues for inbound and outbound messages but when we switch the outbound queue to a remote queue (i.e. the pl/sql code still references the same queue alias but we re-point the alias to a remote queue) we get 2045 errors.
This seems understandable as when we use local queues we appear to have the outbound queue open for input and output. This isnt valid when we are using a remote queue.
I cant figure out whats causing the Gateway to try and open the outbound queue for input ?
We've tried various values for MQ_openOptions including leaving it to default (as recomended in the installation manual) and '16' (open for output). All with the same results 2045!
I take it you can write to a remote queue using Oracle Message Gateway ?
The bizzare thing is we got it to to work once as i've got a test message on another QueueManager to prove it - just cant figure out whats changed 
Any help would be greatly appreciated.
Ta,
K. |
|
| Back to top |
|
 |
| SAFraser |
| Posted: Mon Mar 20, 2006 1:16 pm Post subject: |
|
|
Shaman
Joined: 22 Oct 2003
Posts: 742
Location: Austin, Texas, USA
|
The Oracle Messaging Gateway uses a JMS client. You don't write to remote queues using clients. If you want to PUT or GET a message from a remote queue manager, you configure the Gateway with those particular connection properties, just like any client. Then, your PUT would go to a local queue on the remote queue manager, and it would be transported there according to your client configuration.
At least, this is always how we used it and how I understood that it works. Does this make sense?
Shirley |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Mon Mar 20, 2006 8:55 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
We don't have any problem of the sort. Our Messaging gateway often writes to remote queues. No problem...
However you can never get from a remote queue.
Enjoy 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| m00300 |
| Posted: Tue Mar 21, 2006 1:01 am Post subject: |
|
|
Apprentice
Joined: 01 May 2002
Posts: 31
|
Shirley,
Are you saying that instead of using an alias on our local queue manager which points to a remote definition(which inturn points to a remote queue manager) we should configure the gateway directly with the name of the local queue on the the remote queue manager and the remote queue manager name ?
This is an approach I hadnt considered (and wouldnt usually use unless absolutely neccessary as it tends to hide whats being routed through the queue manager)
But if it works i'm all for it ! 
-- I think the pennys just dropped - i've spent to many years using MQSI! - forgotten all about client connections from applications -d-oh! |
|
| Back to top |
|
|
| m00300 |
| Posted: Tue Mar 21, 2006 7:31 am Post subject: |
|
|
Apprentice
Joined: 01 May 2002
Posts: 31
|
Got this fixed now - nothing wrong with the MQ settings at all - turned out to be a fault with the Oracle Message Gateway which was fixed by applying a patch from Oracle.  |
|
| Back to top |
|
|
| SAFraser |
| Posted: Tue Mar 21, 2006 7:55 am Post subject: |
|
|
Shaman
Joined: 22 Oct 2003
Posts: 742
Location: Austin, Texas, USA
|
Well, I totally missed the reference to a local queue manager on the same box as the Gateway, so saper's comments are much more on point than mine. Of course it should work, and now you have solved your problem with an Oracle patch. That's great.
I'll never get to "grand master" this way. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Mar 21, 2006 8:11 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
| SAFraser wrote: |
| I'll never get to "grand master" this way. |
|
|
\/
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| bbburson |
| Posted: Tue Mar 21, 2006 1:24 pm Post subject: |
|
|
Partisan
Joined: 06 Jan 2004
Posts: 378
Location: Nowhere near a queue manager
|
| SAFraser wrote: |
| I'll never get to "grand master" this way. |
Sure you will! Just look at "master" jeevan. |
|
| Back to top |
|
|
|
|
