| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| WSMQ 7.5.0.2 failed to load "jdbcora11.dll" for Or |
« View previous topic :: View next topic » |
| Author |
Message
|
| xeonix |
 Posted: Tue Sep 10, 2013 5:53 am Post subject: WSMQ 7.5.0.2 failed to load "jdbcora11.dll" for Or |
 |
|
Apprentice
Joined: 02 Apr 2013
Posts: 32
|
Hi, guys!
What I'm trying to do is to setup standalone WS MQ FTE Database Logger. In order to make it work you have to configure XA Resource for the database, where the logger would collect MQ FTE Transfer logs, statistics, and other stuff. With logger everything is fine, but when configuring MQ I'm facing some weird errors.
My box is running Win 2008 R2 SP1, and I have IBM WS MQ 7.5.0.2, WS MQ FTE 7.0.4.3, WS MB 8.0.0.2, DB2 10.5 Express-C and Oracle 12c installed.
First, I have successfully configured QMgr's XA Resource and FTE DB Logger with IBM DB2 database using corresponding Infocenter's manual.
But now I need to switch to Oracle. Using the manual I've configured the logger, and according to it's logs it successfully connects to the Oracle database.
Next I had to edit XA Resource, to make it work with Oracle database instead of DB2.
So this is what the config looks like (it's written according to
http://publib.boulder.ibm.com/infocenter/wmqv7/v7r0/index.jsp?topic=%2Fcom.ibm.mq.amqzag.doc%2Ffa12660_.htm
). "qm.ini" file:
| Code: |
ExitPath:
ExitsDefaultPath=C:\IBM\WebSphere MQ\exits
ExitsDefaultPath64=C:\IBM\WebSphere MQ\exits64
InstanceData:
InstanceID=1378121549
Startup=1
#* *#
#* *#
Log:
LogPrimaryFiles=3
LogSecondaryFiles=2
LogFilePages=4096
LogType=LINEAR
LogBufferPages=0
LogPath=C:\IBM\WebSphere MQ\log\QMWAY\
LogWriteIntegrity=TripleWrite
Service:
Name=AuthorizationService
EntryPoints=14
ServiceComponent:
Service=AuthorizationService
Name=MQSeries.WindowsNT.auth.service
Module=amqzfu.dll
ComponentDataSize=0
XAResourceManager:
Name=FteLog
SwitchFile=jdbcora11.dll
XAOpenString=Oracle_XA+Acc=P/FTELOG/password+SesTm=35+DB=FTELOG+threads=false
XACloseString=
ThreadOfControl=PROCESS |
Of course I copied files:
From: "C:\IBM\WebSphere MQ\java\lib\jdbc\jdbcora11.dll"
To: "C:\IBM\WebSphere MQ\exits"
and
From: "C:\IBM\WebSphere MQ\java\lib64\jdbc\jdbcora11.dll"
To: "C:\IBM\WebSphere MQ\exits64"
Everything should be fine so far. Then I restarted "IBM WebSphere MQ (myInstName)" Windows service, so the QMgr should restart too.
And this is things getting weird:
"dspmq" says "Ended unexpectedly"
In the windows EventLog following errors appear:
| Code: |
9/10/2013 06:40:16 - Process(2252.1) User(MUSR_MQADMIN) Program(amqzxma0.exe) Host(IBM-FTE) Installation(wsmqWAYOPR) VRMF(7.5.0.2) QMgr(QMWAY)
The library 'C:\IBM\WebSphere MQ\exits\jdbcora11.dll' was not found.
The dynamically loadable library 'C:\IBM\WebSphere MQ\exits\jdbcora11.dll' was not found.
Check that the file exists and is either fully qualified or is in the appropriate directory.
|
and this one:
| Code: |
9/10/2013 06:40:16 - Process(2252.1) User(MUSR_MQADMIN) Program(amqzxma0.exe) Host(IBM-FTE) Installation(wsmqWAYOPR) VRMF(7.5.0.2) QMgr(QMWAY)
WebSphere MQ could not load the XA switch load file for resource manager 'FteLog'.
An error has occurred loading XA switch file jdbcora11.dll. If the error occurred during startup then the queue manager will terminate. At all other times the queue manager will continue without this resource manager meaning that it will no longer be able to participate in global transactions. The queue manager will also retry the load of the switch file at regular intervals so that the resource manager will be able to participate again should the load problem be resolved.
Look for a previous message outlining the reason for the load failure. Message AMQ6175 is issued if the load failed because of a system error. If this is the case then follow the guidance given in message AMQ6175 to resolve the problem. In the absence of prior messages or FFST information related to this problem check that the name of the switch load file is correct and that it is present in a directory from which it can be dynamically loaded by the queue manager. The easiest method of doing this is to define the switch load file as a fully-qualified name. Note that if the queue manager is still running it will need to be restarted in order that any changes made to its configuration data can be picked up.
|
What's wrong with it? File "C:\IBM\WebSphere MQ\exits\jdbcora11.dll" as well as "C:\IBM\WebSphere MQ\exits64\jdbcora11.dll" are present, and user "MUSR_MQADMIN" has full rights on them.
Even the latest MQ FixPack 7.5.0.2 didn't fix this error.
When using DB2 and XA switch files "jdbcdb2.dll" for it (which are copied in the same way as "jdbcora11.dll" files were) - everything works fine.
So, does anybody know, why my QMgr can't see XA switch file "jdbcora11.dll", event though it's present and how to fix this? |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Tue Sep 10, 2013 12:58 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Have you checked the access rights (windows permissions) to the files in question? Does the qmgr service ID have access to the files in question? 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| xeonix |
| Posted: Wed Sep 11, 2013 1:33 am Post subject: |
|
|
Apprentice
Joined: 02 Apr 2013
Posts: 32
|
| fjb_saper wrote: |
| Have you checked the access rights (windows permissions) to the files in question? Does the qmgr service ID have access to the files in question? |
Yes, I have. As I said before, 'MUSR_MQADMIN' has full rights on that files.
Also, I've decided to disassemble the file 'jdbcora11.dll', and this is what I got - it has dependency on these DLL's:
oraclient11.dll
MSVCR80.dll
mqe.dll
In my system all these files except "oraclient11.dll" are present. So now, I'm gonna pull them from Oracle 11gR2 x86 and x64 installations and put to "C:\IBM\WebSphere MQ\exits\" and "C:\IBM\WebSphere MQ\exits64\" respectively. Let's see if that helps... |
|
| 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
|
|
|
|
