We have an WMQI flow plumed to do an insert to a dqatabase under XA coord.
When an exception is hit we interrogate the return code from ORACLE and in
some instances reprocess the message because the error is more of an XA
state problem because of the XA coordination. One of these codes is '3113'.
bobbee
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: Tue, 31 Dec 2002 07:58:17 -0500
I'm sure that the XAResourceManager stanza is correct. We copied the
database from another system, and I cut and pasted the stanza from a
working qm.ini. (rev 5.2) Also, If I add +SQLNET=whatever to the
XAOpenString, I can access the database successfully.
I'm not positive about the switch file. It compiled cleanly, i.e., with
no errors, but we are dealing with a new version of the compiler here.
It looks like we are getting through to the Oracle XA interface which is
returning ORA-3113. So I THINK the switch file is OK.
-----Original Message-----
From: Robert Broderick [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 7:48 AM
To: [EMAIL PROTECTED]
Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1
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+ses
tm=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+ses
tm=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_newmsn
8
>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=74
74&SU=
http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_elimina
teviruses_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
_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 3 months FREE*.
http://join.msn.com/?page=features/junkmail&xAPID=42&PS=47575&PI=7324&DI=7474&SU=
http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_stopmorespam_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