| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Configuring MQ for Oracle |
« View previous topic :: View next topic » |
| Author |
Message
|
| ividiva |
 Posted: Mon Dec 02, 2002 3:14 am Post subject: Configuring MQ for Oracle |
 |
|
Newbie
Joined: 21 Nov 2002
Posts: 8
|
Dear All,
The following is the situation.
MQseries server is installed on WindowsNT,Oracle is on SunSolaris.
can any one tell me how do i configure the Queue manager for XA Transaction support (Oracle as the participating resource manager).
I had gone through some IBM documents , but am a bit confused about
how to make the switch load file , if the oracle is on a different m/c , which is my case, and also pls tell me , what should be my XAOpen string?..I think for Oracle XAclose string is not required.
Thanx
Mathews |
|
| Back to top |
|
 |
| pgorak |
| Posted: Tue Dec 03, 2002 2:44 am Post subject: |
|
|
Disciple
Joined: 15 Jul 2002
Posts: 158
Location: Cracow, Poland
|
I'm using XA Transaction support in HP-UX environment. However, this should cast some light on your case:
XAOpenString=Oracle_XA+Acc=P/<USER>/<PASS>+SesTm=35+LogDir=/var/mqm/qmgrs/QMGR/errors+SqlNet=ORCL
In the example above, replace <USER> and <PASS> with appropriate values. ORCL is service name I have defined in tnsnames.ora file.
Provided you have an appropriate definition in tnsnames.ora on Windows, you'll be able to access Oracle on Solaris.
As for the switch library, it is the same - no matter whether the server is on the same or different machine.
Piotr |
|
| 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
|
|
|
|
