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 » Multiphase Commit » Unable to Start Qmanager after configuring XA

Post new topic  Reply to topic Goto page Previous  1, 2
 Unable to Start Qmanager after configuring XA « View previous topic :: View next topic » 
Author Message
fjb_saper
PostPosted: Fri Oct 28, 2011 7:28 pm    Post subject: Reply with quote

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20696
Location: LI,NY

Note: your installation should have 2 jdbcora.dll files
one located in <mqinstall>\java\lib\jdbc (32 bits)
one located in <mqinstall>\java\lib64\jdbc (64 bits)

They need to go respectively into
<mqinstall>\exits (32 bits ) and into
<mqinstall>\exits64 (64 bits).

Now if you copied one over the other in the install directory, you may have to reinstall MQ... or at least repair it...

Have fun
_________________
MQ & Broker admin
Back to top
View user's profile Send private message Send e-mail
Seshagiri
PostPosted: Fri Oct 28, 2011 7:33 pm    Post subject: Reply with quote

Apprentice

Joined: 04 Oct 2011
Posts: 42

fjb_saper wrote:
Note: your installation should have 2 jdbcora.dll files
one located in <mqinstall>\java\lib\jdbc (32 bits)
one located in <mqinstall>\java\lib64\jdbc (64 bits)

They need to go respectively into
<mqinstall>\exits (32 bits ) and into
<mqinstall>\exits64 (64 bits).

Now if you copied one over the other in the install directory, you may have to reinstall MQ... or at least repair it...

Have fun


Yes I got your point I have place as you specified. I think I will repair or reinstall it once again.
Back to top
View user's profile Send private message
Seshagiri
PostPosted: Tue Nov 01, 2011 2:27 am    Post subject: Reply with quote

Apprentice

Joined: 04 Oct 2011
Posts: 42

I have installed the fresh copy of MQ and database and was able to connect to database with both 32bit and 64bit oracle clients. This time when I configure XA in MQ Explorer and try to restart the Qmanager I am seeing these errors in the logs


AMQ6174: The library 'C:\Program Files (x86)\IBM\WebSphere
MQ\exits\jdbcora11.dll' was not found. The queue manager will continue without
this module.

EXPLANATION:
The dynamically loadable library 'C:\Program Files (x86)\IBM\WebSphere
MQ\exits\jdbcora11.dll' was not found.
ACTION:
Check that the file exists and is either fully qualified or is in the
appropriate directory.




and






AMQ7622: WebSphere MQ could not load the XA switch load file for resource
manager 'OracleXAExample'.

EXPLANATION:
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.
ACTION:
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.
Back to top
View user's profile Send private message
ramires
PostPosted: Tue Nov 01, 2011 2:44 am    Post subject: Reply with quote

Knight

Joined: 24 Jun 2001
Posts: 523
Location: Portugal - Lisboa

Do you have more messages like AMQ6175 , or fdc's files created? The jdbcora11.dll is in that directory? What's its size and date?
Maybe open a pmr with IBM

Regards
Back to top
View user's profile Send private message
Seshagiri
PostPosted: Tue Nov 01, 2011 3:10 am    Post subject: Reply with quote

Apprentice

Joined: 04 Oct 2011
Posts: 42

ramires wrote:
Do you have more messages like AMQ6175 , or fdc's files created? The jdbcora11.dll is in that directory? What's its size and date?
Maybe open a pmr with IBM

Regards


Here I just created Qmanager and configured the XA and tried to restart the Qmanager I have not created any queus or running the application. No FDC files are created.

Yes jdbcora11.dll is in that directory

the 32bit dll is 21KB and creation date is 8/31/2010 1:18PM
the 64bit dll is 24KB and creation date is 8/31/2010 1:18PM
Back to top
View user's profile Send private message
ramires
PostPosted: Tue Nov 01, 2011 4:59 am    Post subject: Reply with quote

Knight

Joined: 24 Jun 2001
Posts: 523
Location: Portugal - Lisboa

In one of my windows boxes I have
WebSphere MQ 7.0.1.4

Directory of D:\IBM\WMQ\Java\lib\jdbc
14-01-2011 21:38 19.776 jdbcora11.dll
Directory of D:\IBM\WMQ\Java\lib64\jdbc
14-01-2011 21:39 22.848 jdbcora11.dll

Do you have the last MQ fixes?
Back to top
View user's profile Send private message
Seshagiri
PostPosted: Tue Nov 01, 2011 7:19 am    Post subject: Reply with quote

Apprentice

Joined: 04 Oct 2011
Posts: 42

ramires wrote:
In one of my windows boxes I have
WebSphere MQ 7.0.1.4

Directory of D:\IBM\WMQ\Java\lib\jdbc
14-01-2011 21:38 19.776 jdbcora11.dll
Directory of D:\IBM\WMQ\Java\lib64\jdbc
14-01-2011 21:39 22.848 jdbcora11.dll

Do you have the last MQ fixes?


Yes I have put the fixes the current fix is 7.0.1.6. But the date of these files are same which I have mentioned. This is a trail version of MQ.
Back to top
View user's profile Send private message
ramires
PostPosted: Tue Nov 01, 2011 10:40 am    Post subject: Reply with quote

Knight

Joined: 24 Jun 2001
Posts: 523
Location: Portugal - Lisboa

see this

http://www-01.ibm.com/support/docview.wss?uid=swg1IC67403

it's for MQ v6 but it says:

"The channel program fails to load the exit if it is placed in
a path which includes the brackets '(' ')'. The MQ error
AMQ6175 is reported in the error logs"
Back to top
View user's profile Send private message
Seshagiri
PostPosted: Tue Nov 01, 2011 7:22 pm    Post subject: Reply with quote

Apprentice

Joined: 04 Oct 2011
Posts: 42

ramires wrote:
see this

http://www-01.ibm.com/support/docview.wss?uid=swg1IC67403

it's for MQ v6 but it says:

"The channel program fails to load the exit if it is placed in
a path which includes the brackets '(' ')'. The MQ error
AMQ6175 is reported in the error logs"


Thanks for the link let me try installing the MQ in a directory which is not having '()' and see.
Back to top
View user's profile Send private message
Seshagiri
PostPosted: Wed Nov 02, 2011 7:50 am    Post subject: Reply with quote

Apprentice

Joined: 04 Oct 2011
Posts: 42

I have installed MQ in the path which do not have "
()" in it. But it did not work the same error is thrown.
Back to top
View user's profile Send private message
yxzhao
PostPosted: Thu Mar 06, 2014 1:00 pm    Post subject: Reply with quote

Newbie

Joined: 06 Mar 2014
Posts: 2

Is this resolved? If yes, how? We have similar problem when trying to config XA resource manager within Websphere Explorer (7.5.0.2) on Windows 7 and Oracle 11.

We have installed Websphere to a directory without any space or other special characters such as C:\app\WebSphereMQ. It is still not working.

Has anyone out there ever got it working.

Any help or hints would be greatly appreciated.
Back to top
View user's profile Send private message
yxzhao
PostPosted: Tue Mar 25, 2014 11:23 am    Post subject: Reply with quote

Newbie

Joined: 06 Mar 2014
Posts: 2

We downloaded 32 bit oracle client and it does not complain about exits anymore. But we still cannot get the database resource manager started. The log says below now:

AMQ7604: The XA resource manager 'oraDB' was not available when called for xa_open.

We provided the open string as oracle and ibm web sites specify with the minimum arguments:

ORACLE_XA+Acc=P/testuser/testpass+DB=TESTDB+SesTm=60

Could anyone please help?

Thanks
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Goto page Previous  1, 2 Page 2 of 2

MQSeries.net Forum Index » Multiphase Commit » Unable to Start Qmanager after configuring XA
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.