| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Need Help with setting up Oracle AQ to MQseries |
« View previous topic :: View next topic » |
| Author |
Message
|
| sameer |
 Posted: Thu Sep 09, 2004 8:08 am Post subject: Need Help with setting up Oracle AQ to MQseries |
 |
|
Novice
Joined: 09 Sep 2004
Posts: 12
Location: NY
|
I am trying to setup Oracle AQ to connect to MQseries.
I have installed MQ client and I have provided Host name /ip/qmgr/q/channel/log queue on the win2k box which has the mq series.
When trying to send the message across it gives me an error :
com.ibm.mq.MQException: MQJE001: Completion Code 2, Reason 2009
at com.ibm.mq.MQManagedConnectionJ11.<init>(MQManagedConnectionJ11.java
:172)
at com.ibm.mq.MQClientManagedConnectionFactoryJ11._createManagedConnect
ion(MQClientManagedConnectionFactoryJ11.java:270)
at com.ibm.mq.MQClientManagedConnectionFactoryJ11.createManagedConnecti
on(MQClientManagedConnectionFactoryJ11.java:290)
at com.ibm.mq.StoredManagedConnection.<init>(StoredManagedConnection.ja
va:80)
at com.ibm.mq.MQSimpleConnectionManager.allocateConnection(MQSimpleConn
ectionManager.java:150)
at com.ibm.mq.MQQueueManager.obtainBaseMQQueueManager(MQQueueManager.ja
va:682)
at com.ibm.mq.MQQueueManager.construct(MQQueueManager.java:620)
at com.ibm.mq.MQQueueManager.<init>(MQQueueManager.java:437)
at oracle.mgw.drivers.mq.MQOPHandle.<init>(MQOPHandle.java:56)
at oracle.mgw.drivers.mq.MQLink.checkAdminConn(MQLink.java:338)
at oracle.mgw.drivers.mq.MQLink.registerDestination(MQLink.java:407)
at oracle.mgw.engine.DestMgr.getForeignDest(DestMgr.java:49)
at oracle.mgw.engine.JobData.init(JobData.java:165)
at oracle.mgw.engine.Worker.recoverJob(Worker.java:712)
at oracle.mgw.engine.Worker.myRun(Worker.java:89)
at oracle.mgw.engine.ManagedThr.run(ManagedThr.java:5 |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Thu Sep 09, 2004 1:57 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Are you running the Oracle Messenging Gateway (java JMS model) or some other oracle to MQ tool ?
For the messenging gateway you need to provide
a) host
b) channel (svrconn)
c) port (the listener must be running!)
d) user / group name security setup for the user going to run the oracle gateway.
Now if the MQ server is on the same host check that the listener is running and running under an ID in the mqm group. Check the MCAUSER on the channel to make sure that access is granted. (No MCAUSER set is fine too.)
Otherwise 2009 just points to some networking problems.
We are running the MQServer on the same machine as Oracle and AQ and have had very few problems with the Oracle Messenging Gateway...
Enjoy |
|
| Back to top |
|
|
| sameer |
| Posted: Fri Sep 10, 2004 12:14 pm Post subject: |
|
|
Novice
Joined: 09 Sep 2004
Posts: 12
Location: NY
|
Thanks, I appreciate your reply fjb_saper.
Yes we are running Oracle Messenging Gateway (java JMS model).
We have the MQ series loaded on the same box. I have channel connecting to aWin2k box and a remote queue pointing to the w2k box.
I have provided Hostname as the ip address of the same box
I have listner runnin ag mqm user
The channel does not have MCAUSER
The Oracle gateaway sample program is asking for following :
gv_mq_queue_manager := 'ORACALEQMGR'; ( qmanager created on mqseries on the same box)
gv_mq_queue_name := 'ORACLEQL'; (Local queue on mqseries)
:gv_mq_channel := 'ORACLECHANNEL'; ( channel svrconn type setup in mqseries)
:gv_mq_host := 'host ip';
:gv_mq_port := '1414';
:gv_mq_username := ''; -- optional
:gv_mq_password := ''; -- optional
:gv_mq_outbound_log_queue := 'ORACLELOG'; ( local queue setup on mqseries)
Thanks again for your help |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Fri Sep 10, 2004 7:54 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Read the Oracle Messenging gateway:
There are at least 2 or 3 queues you need to set up for the gateway to work. Think of them as gateway system queues. Do never touch them, do not clear them, etc...
Do never shut down the qmgr as long as the OMG is still running ...
Now you need to make sure that the user running the Oracle Messenging Gateway has access to the qmgr and the OMG "system" queue and the queues the OMG is supposed to service (do puts / gets on).
Enjoy
 |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
