ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » General IBM MQ Support » WMQ7 as a transaction manager after oracle migration

Post new topic  Reply to topic
 WMQ7 as a transaction manager after oracle migration « View previous topic :: View next topic » 
Author Message
llaros
PostPosted: Thu Jun 21, 2012 6:26 am    Post subject: WMQ7 as a transaction manager after oracle migration Reply with quote

Apprentice

Joined: 22 Jan 2008
Posts: 37
Hello

E:
AIX: 6100-06
WMQ: 7.0.1.6
Oracle: 11.2.0.2.0

After migration of Oracle DB from 10g to 11g the WMQ7 Qmgr is starting correctly, but fails during the first MQBEGIN with:

AMQ7605: The XA resource manager dods has returned an |
| unexpected return code -5, when called for xa_open.

This is the entry from the AMQERR01.LOG:
Code:

06/21/12 14:54:44 - Process(31785186.1) User(dods1rw) Program(rbpmquas)
                    Host(prs10)
AMQ7605: The XA resource manager dods has returned an unexpected return code
-5, when called for xa_open.

EXPLANATION:
WebSphere MQ received an unexpected return code when calling XA resource
manager dods at its xa_open entry point.  This indicates an internal error,
either within MQ or the resource manager.
ACTION:
Try to determine the source of the error.  A trace of the failure could be used
to look at the XA flows between MQ and the resource manager. MQ has allocated
an RMId of 1 to this resource manager.  This will be useful when isolating the
flows associated with the resource manager concerned. If the error occurs on an
xa_commit or xa_rollback request, the queue manager will not attempt to
redeliver the commit or rollback instruction for this transaction, until after
the queue manager has been restarted. The transaction indoubt is identified by
the following XID of X'000000000000000000000000'. If you think that the error
lies within the queue manager, save any generated output files and use either
the WMQ Support site: http://www.ibm.com/software/integration/wmq/support/, or
IBM Support Assistant (ISA): http://www.ibm.com/software/support/isa/, to see
whether a solution is already available.  If you are unable to find a match,
contact your IBM support center.  Do not discard any information describing the
problem until after the problem has been resolved.


This is the Oracle RM trace
Code:

ORACLE XA: Version 11.2.0.2.0. RM name = 'Oracle_XA'.


161737.8716324.1:
xaoopen: xa_info=Oracle_XA+DB=ODS+Acc=P/ods1rw/******+SesTm=35+LogDir=/var/mqm/qmgrs/DMQODS1/errors+dbgfl=0xf,rmid=1,flags=0x0


161737.8716324.1:
xaolgn_help: version#: 185597952 banner: Oracle Database 11g Release 11.1.0.0.0 - Production



161737.8716324.1:
xaolgn: sqlxrc/sqlxss completed


161737.8716324.1:
xaolgn: return XA_OK


161737.8716324.1:
xaoopen: xaolgn completed


161737.8716324.1:
xaoopen: return 0


161737.8716324.1:
xaorecover: rmid=1, flags=0x1000000


161737.8716324.1:
xaorecover: xids=0xffffd908, count=5, rmid=1, flags=0x1000000


161737.8716324.1:
xaofetch: fetchcb->xaorfrfs=2


161737.8716324.1:
OCIStmtPrepare: Attempting


161737.8716324.1:
OCIStmtPrepare: Succeeded


161737.8716324.1:
OCIStmtExecute: Attempting


161737.8716324.1:
OCIStmtExecute: Succeeded


161737.8716324.1:
OCIStmtFetch: Attempting


161737.8716324.1:
xaofetch: fetchcb->xaorfrfs=2


161737.8716324.1:
OCIStmtPrepare: Attempting


161737.8716324.1:
OCIStmtPrepare: Succeeded


161737.8716324.1:
OCIStmtExecute: Attempting


161737.8716324.1:
OCIStmtExecute: Succeeded


161737.8716324.1:
OCIStmtFetch: Attempting


161737.8716324.1:
xaoclrfb: cno=0, rmptr=0x101cbff8


161737.8716324.1:
xaoclrfb: cno=0, rmptr=0x101cbff8


161737.8716324.1:
xaoclrec: return (void)


161737.8716324.1:
xaorecover: rtn 0


161738.8716324.1:
xaoclose: xa_info=, rmid=1, flags=0x0


161738.8716324.1:
OCIServerDetach: Attempting


161738.8716324.1:
OCIServerDetach: Succeeded


161738.8716324.1:
xaoclose: rtn 0





This is the FDC:
Code:

+-----------------------------------------------------------------------------+
|                                                                             |
| WebSphere MQ First Failure Symptom Report                                   |
| =========================================                                   |
|                                                                             |
| Date/Time         :- Thu June 21 2012 15:39:09 GMT+02:00                    |
| UTC Time          :- 1340285949.019382                                      |
| UTC Time Offset   :- 120 (GMT+01:00)                                        |
| Host Name         :- prs10                                                  |
| Operating System  :- AIX 6.1                                                |
| PIDS              :- 5724H7221                                              |
| LVLS              :- 7.0.1.6                                                |
| Product Long Name :- WebSphere MQ for AIX                                   |
| Vendor            :- IBM                                                    |
| Probe Id          :- ZM007000                                               |
| Application Name  :- MQM                                                    |
| Component         :- ztmBeginInitialise                                     |
| SCCS Info         :- lib/ztm/amqztmb0.c, 1.33.1.1                           |
| Line Number       :- 318                                                    |
| Build Date        :- Jul 25 2011                                            |
| CMVC level        :- p701-106-110725                                        |
| Build Type        :- IKAP - (Production)                                    |
| Effective UserID  :- 902 (dreb)                                             |
| Real UserID       :- 902 (dreb)                                             |
| Program Name      :- esbua                                                  |
| Addressing mode   :- 64-bit                                                 |
| Process           :- 22610072                                               |
| Thread(n)         :- 1                                                      |
| QueueManager      :- DMQODS1                                                |
| UserApp           :- TRUE                                                   |
| ConnId(1) IPCC    :- 74                                                     |
| Last HQC          :- 1.0.0-139664                                           |
| Last HSHMEMB      :- 0.0.0-0                                                |
| Major Errorcode   :- trcE_UNEXPECTED_RM_ERROR                               |
| Minor Errorcode   :- OK                                                     |
| Probe Type        :- MSGAMQ7605                                             |
| Probe Severity    :- 2                                                      |
| Probe Description :- AMQ7605: The XA resource manager dods has returned an  |
|   unexpected return code -5, when called for xa_open.                       |
| FDCSequenceNumber :- 0                                                      |
| Arith1            :- 18446744073709551611 (0xfffffffffffffffb)              |
| Arith2            :- 1 (0x1)                                                |
| Comment1          :- dods                                                   |
| Comment2          :- xa_open                                                |
| Comment3          :- 000000000000000000000000                               |
|                                                                             |
+-----------------------------------------------------------------------------+

MQM Function Stack
MQBEGIN
zstMQBEGIN
ziiMQBEGIN
ztmBeginInitialise
xcsFFST

MQM Trace History
-----{ xcsPostEventSem
------{ xlsLockEvent
------} xlsLockEvent rc=OK
------{ xlsUnlockEvent
------} xlsUnlockEvent rc=OK
-----} xcsPostEventSem rc=OK
----} zcpSendOnPipe rc=OK
----{ zcpReceiveOnPipe
-----{ xcsWaitEventSem
------{ xlsLockEvent
------} xlsLockEvent rc=OK
------{ xlsUnlockEvent
------} xlsUnlockEvent rc=OK
-----} xcsWaitEventSem rc=OK
----} zcpReceiveOnPipe rc=OK
---} ziiSendReceiveAgent rc=OK
---{ zcpDeleteMessage
---} zcpDeleteMessage rc=OK
--} ziiMQOPEN rc=OK
-} zstMQOPEN rc=OK
} MQOPEN rc=OK
{ MQPUT
-{ zstMQPUT
--{ xcsIsEnvironment
--} xcsIsEnvironment rc=OK
--{ zstGetPCD
---{ zstVerifyPCD
---} zstVerifyPCD rc=OK
--} zstGetPCD rc=OK
--{ zstMQPUT_CheckParms
--} zstMQPUT_CheckParms rc=OK
--{ zstCalculatePropsLength
---{ zrfLocateMQRFH2
----{ xcsConvertString
-----{ xcsQueryCCSIDType
-----} xcsQueryCCSIDType rc=OK
-----{ xcsQueryCCSIDType
-----} xcsQueryCCSIDType rc=OK
----} xcsConvertString rc=OK
----{ xcsConvertString
-----{ xcsQueryCCSIDType
-----} xcsQueryCCSIDType rc=OK
-----{ xcsQueryCCSIDType
-----} xcsQueryCCSIDType rc=OK
----} xcsConvertString rc=OK
---} zrfLocateMQRFH2 rc=OK
---{ zrfParseUTF8FolderName
---} zrfParseUTF8FolderName rc=OK
---{ zrfParseUTF8FolderName
---} zrfParseUTF8FolderName rc=OK
---{ zrfParseUTF8FolderName
---} zrfParseUTF8FolderName rc=OK
---{ zrfLocateMQRFH2
----{ xcsConvertString
-----{ xcsQueryCCSIDType
-----} xcsQueryCCSIDType rc=OK
-----{ xcsQueryCCSIDType
-----} xcsQueryCCSIDType rc=OK
----} xcsConvertString rc=OK
---} zrfLocateMQRFH2 rc=MQRC_PROPERTY_NOT_AVAILABLE
--} zstCalculatePropsLength rc=OK
--{ ziiMQPUT
---{ ziiVSendReceiveAgent
----{ ziiCreateIPCCMessage
-----{ zcpCreateMessage
-----} zcpCreateMessage rc=OK
----} ziiCreateIPCCMessage rc=OK
----{ zcpSendOnPipe
-----{ xcsResetEventSem
-----} xcsResetEventSem rc=OK
-----{ xcsPostEventSem
------{ xlsLockEvent
------} xlsLockEvent rc=OK
------{ xlsUnlockEvent
------} xlsUnlockEvent rc=OK
-----} xcsPostEventSem rc=OK
----} zcpSendOnPipe rc=OK
----{ zcpReceiveOnPipe
-----{ xcsWaitEventSem
------{ xlsLockEvent
------} xlsLockEvent rc=OK
------{ xlsUnlockEvent
------} xlsUnlockEvent rc=OK
-----} xcsWaitEventSem rc=OK
----} zcpReceiveOnPipe rc=OK
---} ziiVSendReceiveAgent rc=OK
---{ zcpDeleteMessage
---} zcpDeleteMessage rc=OK
--} ziiMQPUT rc=OK
-} zstMQPUT rc=OK
} MQPUT rc=OK
{ MQOPEN
-{ zstMQOPEN
--{ xcsIsEnvironment
--} xcsIsEnvironment rc=OK
--{ zstGetPCD
---{ zstVerifyPCD
---} zstVerifyPCD rc=OK
--} zstGetPCD rc=OK
--{ zstCheckODAddressability
---{ xcsCheckPointer
---} xcsCheckPointer rc=OK
--} zstCheckODAddressability rc=OK
--{ ziiMQOPEN
---{ ziiCreateIPCCMessage
----{ zcpCreateMessage
----} zcpCreateMessage rc=OK
---} ziiCreateIPCCMessage rc=OK
---{ ziiSendReceiveAgent
----{ zcpSendOnPipe
-----{ xcsResetEventSem
-----} xcsResetEventSem rc=OK
-----{ xcsPostEventSem
------{ xlsLockEvent
------} xlsLockEvent rc=OK
------{ xlsUnlockEvent
------} xlsUnlockEvent rc=OK
-----} xcsPostEventSem rc=OK
----} zcpSendOnPipe rc=OK
----{ zcpReceiveOnPipe
-----{ xcsWaitEventSem
------{ xlsLockEvent
------} xlsLockEvent rc=OK
------{ xlsUnlockEvent
------} xlsUnlockEvent rc=OK
-----} xcsWaitEventSem rc=OK
----} zcpReceiveOnPipe rc=OK
---} ziiSendReceiveAgent rc=OK
---{ zcpDeleteMessage
---} zcpDeleteMessage rc=OK
--} ziiMQOPEN rc=OK
-} zstMQOPEN rc=OK
} MQOPEN rc=OK
{ MQOPEN
-{ zstMQOPEN
--{ xcsIsEnvironment
--} xcsIsEnvironment rc=OK
--{ zstGetPCD
---{ zstVerifyPCD
---} zstVerifyPCD rc=OK
--} zstGetPCD rc=OK
--{ zstCheckODAddressability
---{ xcsCheckPointer
---} xcsCheckPointer rc=OK
--} zstCheckODAddressability rc=OK
--{ ziiMQOPEN
---{ ziiCreateIPCCMessage
----{ zcpCreateMessage
----} zcpCreateMessage rc=OK
---} ziiCreateIPCCMessage rc=OK
---{ ziiSendReceiveAgent
----{ zcpSendOnPipe
-----{ xcsResetEventSem
-----} xcsResetEventSem rc=OK
-----{ xcsPostEventSem
------{ xlsLockEvent
------} xlsLockEvent rc=OK
------{ xlsUnlockEvent
------} xlsUnlockEvent rc=OK
-----} xcsPostEventSem rc=OK
----} zcpSendOnPipe rc=OK
----{ zcpReceiveOnPipe
-----{ xcsWaitEventSem
------{ xlsLockEvent
------} xlsLockEvent rc=OK
------{ xlsUnlockEvent
------} xlsUnlockEvent rc=OK
-----} xcsWaitEventSem rc=OK
----} zcpReceiveOnPipe rc=OK
---} ziiSendReceiveAgent rc=OK
---{ zcpDeleteMessage
---} zcpDeleteMessage rc=OK
--} ziiMQOPEN rc=OK
-} zstMQOPEN rc=OK
} MQOPEN rc=OK
{ MQINQ
-{ zstMQINQ
--{ xcsIsEnvironment
--} xcsIsEnvironment rc=OK
--{ zstGetPCD
---{ zstVerifyPCD
---} zstVerifyPCD rc=OK
--} zstGetPCD rc=OK
--{ xcsCheckPointer
--} xcsCheckPointer rc=OK
--{ xcsCheckPointer
--} xcsCheckPointer rc=OK
--{ xcsCheckPointer
--} xcsCheckPointer rc=OK
--{ ziiMQINQ
---{ ziiCreateIPCCMessage
----{ zcpCreateMessage
----} zcpCreateMessage rc=OK
---} ziiCreateIPCCMessage rc=OK
---{ ziiSendReceiveAgent
----{ zcpSendOnPipe
-----{ xcsResetEventSem
-----} xcsResetEventSem rc=OK
-----{ xcsPostEventSem
------{ xlsLockEvent
------} xlsLockEvent rc=OK
------{ xlsUnlockEvent
------} xlsUnlockEvent rc=OK
-----} xcsPostEventSem rc=OK
----} zcpSendOnPipe rc=OK
----{ zcpReceiveOnPipe
-----{ xcsWaitEventSem
------{ xlsLockEvent
------} xlsLockEvent rc=OK
------{ xlsUnlockEvent
------} xlsUnlockEvent rc=OK
-----} xcsWaitEventSem rc=OK
----} zcpReceiveOnPipe rc=OK
---} ziiSendReceiveAgent rc=OK
---{ zcpDeleteMessage
---} zcpDeleteMessage rc=OK
--} ziiMQINQ rc=OK
-} zstMQINQ rc=OK
} MQINQ rc=OK
{ MQBEGIN
-{ zstMQBEGIN
--{ xcsIsEnvironment
--} xcsIsEnvironment rc=OK
--{ zstGetPCD
---{ zstVerifyPCD
---} zstVerifyPCD rc=OK
--} zstGetPCD rc=OK
--{ zstSetMQModel
--} zstSetMQModel rc=OK
--{ xcsCheckPointer
--} xcsCheckPointer rc=OK
--{ ziiMQBEGIN
---{ ztmBeginInitialise
----{ tmsLoadXASwitch
-----{ xcsLoadFunction
------{ xcsGetMemFn
------} xcsGetMemFn rc=OK
-----} xcsLoadFunction rc=OK
-----{ xcsGetMemFn
-----} xcsGetMemFn rc=OK
----} tmsLoadXASwitch rc=OK
----{ ztmXAOpen
-----{ tmiCallXAOpen
-----} tmiCallXAOpen rc=Unknown(FFFB)
----} ztmXAOpen rc=Unknown(FFFB)
----{ xcsBuildDumpPtr
-----{ xcsGetMemFn
-----} xcsGetMemFn rc=OK
----} xcsBuildDumpPtr rc=OK
----{ xcsFFST


qm.ini
Code:

XAResourceManager:
   Name=dods
   SwitchFile=/var/mqm/exits64/oracle11/oraswit
   XAOpenString=Oracle_XA+DB=ODS+Acc=P/ods1rw/ibm123+SesTm=35+LogDir=/var/mqm/qmgrs/DMQODS1/errors+dbgfl=0xf
   ThreadOfControl=PROCESS


Any advices?
Back to top
View user's profile Send private message
llaros
PostPosted: Thu Jun 21, 2012 6:37 am    Post subject: Reply with quote

Apprentice

Joined: 22 Jan 2008
Posts: 37
Solved . The program that was performing transaction has had wrong environment. ORACLE_HOME was referencing oracle 10g.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » General IBM MQ Support » WMQ7 as a transaction manager after oracle migration
Jump to:  



You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.