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: Thu, 2 Jan 2003 08:49:59 -0500
We get an AMQ7604:
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...
This is matched by a trace file showing that Oracle returns the 3113.
-----Original Message-----
From: Robert Broderick [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 02, 2003 8:20 AM
To: [EMAIL PROTECTED]
Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1
When you start your QMGR, Are there any messages in the AMQERR01.LOG
file
indicating there is an error in the XA connection??
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 11:38:26 -0500
>
>Still not working. I tried running an application program in the
>debugger, assuming that it would cause the QMgr to attempt to connect
to
>the database. Then with some calculated breakpoints and jumps I forced
>it to retry after getting errors. I still get ORA-3113 every time I
>issue a MQSTART.
>
>
>-----Original Message-----
>From: Robert Broderick [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, December 31, 2002 10:43 AM
>To: [EMAIL PROTECTED]
>Subject: Re: Transaction coordination with 5.3 and Oracle on AIX 5.1
>
>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&D
>I
> >=7474&SU=
>
>http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_stopmo
>r
> >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=7
3
>24&DI=7474&SU=
>http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_addpho
t
>os_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: 2 months FREE*
http://join.msn.com/?page=features/virus
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