ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » General IBM MQ Support » Oracle Messaging Gateway

Post new topic  Reply to topic
 Oracle Messaging Gateway « View previous topic :: View next topic » 
Author Message
SAFraser
PostPosted: Fri Mar 19, 2004 6:14 am    Post subject: Oracle Messaging Gateway Reply with quote

Shaman

Joined: 22 Oct 2003
Posts: 742
Location: Austin, Texas, USA

Is anyone familiar with the Oracle Messaging Gateway? It connects a DB internal queue to an MQ queue using JMS. I've posted this question on an Oracle forum but received no replies.

It appears that when the Oracle gateway is started, it connects & opens the MQ queue, and leaves it open. I would like to confirm this. If this is the case, we can monitor the PROCs on the queue to make sure the gateway hasn't died.

I'm working on some tests with the DBAs to confirm this behavior. But I thought if anyone has actual experience with this, it would be good to know.

Thank you.
Back to top
View user's profile Send private message
vennela
PostPosted: Fri Mar 19, 2004 8:48 am    Post subject: Reply with quote

Jedi Knight

Joined: 11 Aug 2002
Posts: 4055
Location: Hyderabad, India

Quote:
It appears that when the Oracle gateway is started, it connects & opens the MQ queue, and leaves it open. I would like to confirm this. If this is the case, we can monitor the PROCs on the queue to make sure the gateway hasn't died.


I am not sure if this would be a real good montior all by itself. Because, if the Oracle app hangs, you will still see PROCs and also if the Oracle app crashes also, you will sometimes see this behaviour.

P.S.
Is this Oracle gateway similar to Oracle Interconnect which has MQ adapter?
Back to top
View user's profile Send private message Send e-mail Visit poster's website
SAFraser
PostPosted: Fri Mar 19, 2004 8:59 am    Post subject: Reply with quote

Shaman

Joined: 22 Oct 2003
Posts: 742
Location: Austin, Texas, USA

I agree completely with your statement about this not being the best way to monitor the Oracle gateway. I really don't like for MQ to be the way any application is monitored; it is the app's job to do it. But the DBAs haven't come up with any way to monitor their gateway so I thought the PROC idea might be better than nothing. (Oh, helpful MQ admin.)

I am such an Oracle novice that I can't answer your question about Oracle Interconnect. I do know that this is Oracle 9.x and this gateway process uses an Oracle-produced MQ adapter that is java-based.

In further testing with the DBAs this morning, I now think that the gateway does not connect/open to MQ until there is an actual PUT or GET. Then (I think) the PROC stays open forever.

Any ideas will be welcome. Thanks for your reply.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » General IBM MQ Support » Oracle Messaging Gateway
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
 
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.