s our problem too. So we had the flow rollback the message and try again. We
played with the testing and tried to determine which codes were thrown
because the database was taken away and whci ones were stale states. There
are two error codes for the connection handle that we found. One sez there
is no handle, the other one sez that the one it has is not valid any more
(DB went down). It's fun!!
So you got it working???
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 10:27:09 -0500
We have seen occasional 3113 errors in application programs. If my
memory serves me correctly, they generally happened on the MQCMIT. They
were certainly transitory. This time, I consistently get the error when
calling xa_open. This appears to be the first call to the DB.
-----Original Message-----
From: Robert Broderick [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 31, 2002 9:40 AM
To: [EMAIL PROTECTED]
Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1
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+se
s
>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+se
s
>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=7
4
>74&SU=
>http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_elimin
a
>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_stopmor
espam_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
_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail&xAPID=42&PS=47575&PI=7324&DI=7474&SU=
http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_addphotos_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