| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| MQ & Oracle coordination |
« View previous topic :: View next topic » |
| Author |
Message
|
| hdjur |
 Posted: Thu Dec 30, 2004 3:05 am Post subject: MQ & Oracle coordination |
 |
|
Centurion
Joined: 16 Sep 2004
Posts: 116
Location: Zagreb
|
Hello!
Are oracle client and xa library sufficient to provide coordination
between oracle and MQ, or do I have to have oracle server on the
same machine where queue manager is installed?
Thanks! |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Thu Dec 30, 2004 10:44 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
My understanding is it is not the Oracle server that needs to be on the same machine but the Transaction coordinator i.e. Web Application Server or Oracle server if the DB is to serve as transaction coordinator.
Now if your DB is not on top of the WAS it is certainly a scenario you should test first.
If you are not using WAS or want MQ to be the transaction coordinator then I believe Yes the DB has to be on the same physical/virtual machine as the MQ server.
Enjoy  |
|
| Back to top |
|
|
| kirani |
| Posted: Thu Dec 30, 2004 10:52 am Post subject: |
|
|
Jedi Knight
Joined: 05 Sep 2001
Posts: 3779
Location: Torrance, CA, USA
|
Take a look at Chapter 11 in System Administraton Guide.
| Quote: |
The database server can reside on a different machine from the queue manager server, as long as the database client is installed on the same machine as the queue manager, and it supports this function. Consult the database product’s documentation to determine whether their client software can be used for two-phase commit systems.
|
_________________
Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
|
|
| Back to top |
|
|
| tillywern |
| Posted: Mon Jan 03, 2005 3:24 pm Post subject: MQ coordination with ORACLE |
|
|
Centurion
Joined: 28 Jan 2003
Posts: 109
Location: Colorado
|
I am cruuently working in an environment were we are using MQ to manage commit point with multiple ORACLE instances which are not colocated with WBI.
In our case the major difficulty is managing commits to our error database when transactions fail. Of course WBI trys to abstract a lot of this from the user.
Remember that WBI creates connections via the Merent drviers and abstraction layer so I do not know the native ORACLE options that you have available if you want MQSeries to manage the unit of work.
In short, you CAN have MQ manage a remote ORACLE database. |
|
| 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
|
|
|
|
