Are you sure your compile of the SWITCH file worked. I had problems with the
makefile that was supplied. What does your XA_Resource stanza look like. The
first one is there because we are using WMQI but when we were setting up XA
with MQ alone it looked like the commented out one:

XAResourceManager:
## Test DB XA control for ARIBA machine
  Name=Oracle8 retbolt1.ARDB
  SwitchFile=/opt/wmqi/merant/lib/UKor8dtc16.so

XAOpenString=ORACLE_XA+SQLNET=retbolt1.ARDB+ACC=P/mqbroker/mqbroker1+sestm=0+threads=TRUE+DB=retbolt1.ARDB
  XACloseString=
  ThreadOfControl=THREAD
## ARIBA database XA control
#    Name=Oracle8 retbolt1.ARDB
#    SwitchFile=/opt/mqm/samp/xatm/oraswit
#
XAOpenString=ORACLE_XA+SQLNET=retbolt1.ARDB+ACC=P/mqbroker/mqbroker1+sestm=0+threads=TRUE+DB=retbolt1.ARDB
#    XACloseString=






From: "Gutekunst, Brant" <[EMAIL PROTECTED]>
Reply-To: MQSeries List <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1
Date: Mon, 30 Dec 2002 14:26:10 -0500

Yes.  I can access the DB via SQLPLUS using the user and password in the
qm.ini file.

-----Original Message-----
From: Robert Broderick [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 2:21 PM
To: [EMAIL PROTECTED]
Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1

Can you connect to the Oracle DB using SQLPLUS from the same machine. I
am
wondering if your tnsnames.ora file is correct. and you have the link
(either in your /usr/lib directory or in the prog) set to point to then
ORACLE client library file

                               bobbee







>From: "Gutekunst, Brant" <[EMAIL PROTECTED]>
>Reply-To: MQSeries List <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Transaction coordination with 5.3 and Oracle on AIX 5.1
>Date: Mon, 30 Dec 2002 11:20:30 -0500
>
>I'm having problems making XA work with MQ 5.3 and Oracle 8.1.7 on AIX
>5.1.
>
>I created the switch file, added the XAResourceManager stanza to qm.ini
>and granted the appropriate database privileges.
>
>
>
>When I start the QMgr, I get the following in the log:
>
>AMQ7604: The XA resource manager 'isgamt06' was not available when
>called for
>
>xa_open. The queue manager is continuing without this resource manager.
>
>EXPLANATION:
>
>The XA resource manager 'isgamt06' has indicated that it is not
>available, by
>
>returning XAER_RMERR on an xa_open request or XAER_RMFAIL when called
>for
>
>something else. Normally this indicates that the resource manager has
>been shut
>
>down. In this case the resource manager cannot participate in any new
>
>transactions. Any in-flight transactions in which it was involved will
>be
>
>backed out, and any transactions in which it is in-doubt will only be
>resolved
>
>when contact with the resource manager is re-established. A further
>message
>
>will be issued when the queue manager has been able to do this. If the
>problem
>
>occurred on an xa_open request, and the resource manager should be
>available,
>
>then there may be a configuration problem.
>
>ACTION:
>
>Try to establish the reason why the resource manager is unavailable. It
>may be
>
>that an invalid XAOpenString has been defined for the resource manager
>in the
>
>'qm.ini' configuration file. If this is the case, stop and then restart
>the
>
>queue manager so that any change will be picked up. Alternatively, the
>queue
>
>manager may be reaching a resource constraint with this resource
>manager. For
>
>example, the resource manager may not be able to accommodate all of the
>queue
>
>manager processes being connected at one time, you may need to alter
one
>of its
>
>tuning parameters.
>
>
>
>I also get a trace file containing:
>
>ORACLE XA: Version 8.1.7.0.0. RM name = 'Oracle_XA'.
>
>110226.158670.1:
>
>ORA-03113: end-of-file on communication channel
>
>110226.158670.1:
>
>xaolgn: XAER_RMERR; logon failed. ORA-3113.
>
>
>
>I tried using the DbgFl parameter and got this additional information
in
>the trace file:
>
>xaoopen: return -3
>
>
>
>Curiously, If I change the XAOpenString attribute to use SqlNet,
>everything works.
>
>
>
>Can anyone shed any light on this?
>
>
>
>CONFIDENTIALITY NOTICE: This E-Mail transmission may contain
confidential
>or legally privileged information that is intended only for the
>individual(s)or entity(ies) named in the E-Mail address. If you are not
the
>intended recipient, you are hereby notified that any disclosure,
copying,
>distribution, or reliance upon the contents of this E-Mail is strictly
>prohibited. If you have received this E-Mail transmission in error,
please
>reply to the sender so that arrangements can be made for proper
delivery,
>after which please delete the message from your inbox. Thank you


_________________________________________________________________
MSN 8 limited-time offer: Join now and get 3 months FREE*.
http://join.msn.com/?page=dept/dialup&xAPID=42&PS=47575&PI=7324&DI=7474&;
SU=
http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_newmsn8
ishere_3mf

Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://vm.akh-wien.ac.at/MQSeries.archive

CONFIDENTIALITY NOTICE: This E-Mail transmission may contain confidential
or legally privileged information that is intended only for the
individual(s)or entity(ies) named in the E-Mail address. If you are not the
intended recipient, you are hereby notified that any disclosure, copying,
distribution, or reliance upon the contents of this E-Mail is strictly
prohibited. If you have received this E-Mail transmission in error, please
reply to the sender so that arrangements can be made for proper delivery,
after which please delete the message from your inbox. Thank you

Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://vm.akh-wien.ac.at/MQSeries.archive

_________________________________________________________________
MSN 8 with e-mail virus protection service: 3 months FREE*.
http://join.msn.com/?page=features/virus&xAPID=42&PS=47575&PI=7324&DI=7474&SU=
http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_eliminateviruses_3mf

Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://vm.akh-wien.ac.at/MQSeries.archive

Reply via email to