MQSeries.net :: View topic - WMB and WMQ Oracle 10g XA Configuration Issue

kytem · Posted: Fri Jan 22, 2010 3:10 pm Post subject:

I'm trying to configure WMQ (ver 6) to be the transaction manager for my WMB (ver 6.1) message flows, my database is Oracle 10g, and everything is running on Linux on a single machine.

I have followed the instructions in the message Broker Configuration_administration_security.pdf file but I am getting errors when I re-start my Q manager.

The errors are:
--------------------------------------------------------
01/22/2010 05:28:03 PM - Process(6550.1) User(mqm) Program(amqzxma0)
AMQ6175: The system could not dynamically load the shared library
'/var/mqm/exits/UKor8dtc23.so'. The system returned error message
'libclntsh.so: cannot open shared object file: Permission denied'. The queue
manager will continue without this module.

EXPLANATION:
This message applies to UNIX systems. The shared library
'/var/mqm/exits/UKor8dtc23.so' failed to load correctly due to a problem with
the library.
ACTION:
Check the file access permissions and that the file has not been corrupted.
----- amqxufnx.c : 1174 -------------------------------------------------------
01/22/2010 05:28:03 PM - Process(6550.1) User(mqm) Program(amqzxma0)
AMQ7622: WebSphere MQ could not load the XA switch load file for resource
manager 'ESBOracleXA'.

EXPLANATION:
An error has occurred loading XA switch file /var/mqm/exits/UKor8dtc23.so. 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.
----- amqtrmca.c : 367 --------------------------------------------------------

My QM.ini is

#*******************************************************************#
#* Module Name: qm.ini *#
#* Type : WebSphere MQ queue manager configuration file *#
# Function : Define the configuration of a single queue manager *#
#* *#
#*******************************************************************#
#* Notes : *#
#* 1) This file defines the configuration of the queue manager *#
#* *#
#*******************************************************************#
ExitPath:
ExitsDefaultPath=/var/mqm/exits/
ExitsDefaultPath64=/var/mqm/exits64/
#* *#
#* *#
Log:
LogPrimaryFiles=3
LogSecondaryFiles=2
LogFilePages=1024
LogType=CIRCULAR
LogBufferPages=0
LogPath=/var/mqm/log/FMFSLD01/
LogWriteIntegrity=TripleWrite
Service:
Name=AuthorizationService
EntryPoints=13
ServiceComponent:
Service=AuthorizationService
Name=MQSeries.UNIX.auth.service
Module=/opt/mqm/lib/amqzfu
ComponentDataSize=0
XAResourceManager:
Name=WBIWMQJMS
SwitchFile=/apps/IBM/mqsi/6.1/lib/libJMSSwitch.so
XAOpenString=com.sun.jndi.fscontext.RefFSContextFactory,file:///var/mqm/jndi/,,,,,recoveryp2pQCF,
ThreadOfControl=THREAD
XAResourceManager:
Name=ESBOracleXA
SwitchFile=/var/mqm/exits/UKor8dtc23.so
XAOpenString=ORACLE_XA+SQLNET=vmdev.dedirdev+HostName=localhost+PortNumber=1521+Sid=vmdev+ACC=P/ESB/password+sestm=100+threads=TRUE+DataSource=ESB+DB=ESB+K=2+
XACloseString=
ThreadOfControl=THREAD
XAResourceManager:
Name=SPOracleXA
SwitchFile=/var/mqm/exits/UKor8dtc23.so XAOpenString=ORACLE_XA+SQLNET=vmdev.dedirdev+HostName=localhost+PortNumber=1521+Sid=vmdev+ACC=P/setproxy/pa55w0rd+sestm=100+threads=TRUE+DataSource=SETPROXY+DB=SETPROXY+K=2+
XACloseString=
ThreadOfControl=THREAD

The permissions on libclntsh.so.10.1 and libclntsh.so. are:

lrwxrwxrwx 1 oracle dba 17 Oct 29 15:28 libclntsh.so -> libclntsh.so.10.1
-rwxr-xr-- 1 oracle dba 18311111 Oct 29 15:28 libclntsh.so.10.1

And, the permissions on UKor8dtc23.so are:

-rwxr-xr-x 1 bin bin 1176439 Jul 23 2009 UKor8dtc23.so

I'm not sure what permissions I'm missing (if any???). Does anybody know what the problem may be (and where I can look for more infomation).

Thanks