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 IndexMultiphase CommitWSMQ 7.5.0.2 failed to load "jdbcora11.dll" for Or

Post new topicReply to topic
WSMQ 7.5.0.2 failed to load "jdbcora11.dll" for Or View previous topic :: View next topic
Author Message
xeonix
PostPosted: Tue Sep 10, 2013 5:53 am Post subject: WSMQ 7.5.0.2 failed to load "jdbcora11.dll" for Or Reply with quote

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
View user's profile Send private message
fjb_saper
PostPosted: Tue Sep 10, 2013 12:58 pm Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20089
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
View user's profile Send private message Send e-mail
xeonix
PostPosted: Wed Sep 11, 2013 1:33 am Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:
Post new topicReply to topic Page 1 of 1

MQSeries.net Forum IndexMultiphase CommitWSMQ 7.5.0.2 failed to load "jdbcora11.dll" for Or
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.