| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| MQBEGIN error 2122 - XA Open error on HPUnix |
« View previous topic :: View next topic » |
| Author |
Message
|
| pbravic |
 Posted: Tue Apr 27, 2004 8:13 pm Post subject: MQBEGIN error 2122 - XA Open error on HPUnix |
 |
|
Apprentice
Joined: 24 Nov 2003
Posts: 42
|
Hi All
We had migrated from MQ 5.2 to WMQ 5.3 csd 5 on HP Unix, after migration, the application which is interacting with the queue and the oracle database is failing.
The application is using the XA Resource manager for the trascation coordination.
The error in application log file
-------------------------------------
Fatal error -- notify Administrator!
MQBEGIN ended with reason code 2122
The error from the XA Trace File
------------------------------------
xaolgn_help: XAER_RMERR; OCIServerAttach failed. ORA-12545.
ORACLE XA: Version 8.1.7.0.0. RM name = 'Oracle_XA'.
We want some clarifications/help in solving the above error.
1) Do we need to recompile the xa switch file after upgrading the MQ?
2) If we donot need to recompile the switch file what may be the reason for xa coordination failing
Thanks and Regards
Ravi |
|
| Back to top |
|
 |
| mqonnet |
| Posted: Wed Apr 28, 2004 4:46 am Post subject: |
|
|
Grand Master
Joined: 18 Feb 2002
Posts: 1114
Location: Boston, Ma, Usa.
|
I havent done much in this area, but here are a few of pointers.
---From the manuals.
"2122 X'084A' MQRC_PARTICIPANT_NOT_AVAILABLE
An MQBEGIN call was issued to start a unit of work coordinated by the queue manager, but one or more of the participating resource managers that had been registered with the queue manager is not available. As a result, changes to those resources cannot be coordinated by the queue manager in the unit of work.
This reason code occurs in the following environments: AIX, HP-UX, Linux, OS/2, OS/400, Solaris, Windows.
Corrective action: If the application does not require non-WebSphere MQ resources to participate in the unit of work, this reason code can be ignored. Otherwise consult your system support programmer to determine why the required resource managers are not available. The resource manager may have been halted temporarily, or there may be an error in the queue manager's configuration file.
"
Which suggests that for some reason MQ is unable to find/connect to the oracle. Check to see if all connections are appropriate and established properly.
---Check this link out. Gives you the explaination of what ora-1245 error code means. Because thats what you should be concentrating on IMO.
http://www.is.mcgill.ca/minerva/Help/ora12545.htm
"Do we need to recompile the xa switch file after upgrading the MQ"
---I dont think so per the above explaintion.
Cheers
Kumar |
|
| Back to top |
|
|
| pbravic |
| Posted: Thu Apr 29, 2004 1:17 pm Post subject: |
|
|
Apprentice
Joined: 24 Nov 2003
Posts: 42
|
Hi Kumar
Thanks for the inputs, the issue was resolved on restarting the Queue Manger.
1) After migration the Queuemanager was started when the database was down.
2) Database was started after the QM started so QM.INI was not effective
The restart of QM made it work
Thanks for the inputs
Thanks and Regards
P.B.Ravichandran |
|
| Back to top |
|
|
| pshan81 |
| Posted: Thu Mar 09, 2006 3:47 am Post subject: MQ two phase commit |
|
|
Acolyte
Joined: 24 May 2005
Posts: 72
|
I am doing MQ Two Phase Commit.I am getting the following error in the log file specified in the mq.ini path while starting the queue manager.
<<ORACLE XA: Version 8.1.5.0.0. RM name = 'Oracle_XA'.
214115.409.1.1:
Error while trying to retrieve text for error ORA-12545
214115.409.1.1:
xaolgn_help: XAER_RMERR; OCIServerAttach failed. ORA-12545. >
QM.ini entry
--------------
XAResourceManager:
Name=abcd
SwitchFile=/opt/mqm/java/lib/jdbc/jdbcora XAOpenString=Oracle_XA+ACC=P/user/pwd+SesTm=35+LogDir=/tmp/log+threads=TRUE+DB=db
ThreadOfControl=THREAD
My MQ and DB are running in different machine(unix).I have created the switch file using the make file in /opt/mqm/java/lib/jdbc.DBA_PENDING_TRANSACTIONS permission is also set in the DB. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
