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
