MQSeries.net :: View topic

eugen · Posted: Wed Dec 29, 2010 3:00 am Post subject:

Hello to all!

First happy holidays to everyone!

Next, here is my Environment first :

Cent OS 5.5 (Final) 64 bit; Oracle XE Server 32 bit; Oracle XE Client 32 bit ; MQ 7.0.1.3 (64 bit) ; WMB 6.1.0.8 (64 bit). All running in the same machine.

The installation seems to be ok. The MQ seems ok, I mean I can create a Queue Manager without problems :

[mqbrkr@localhost bin]$ crtmqm WMBQMB7
There are 89 days left in the trial period for this copy of WebSphere MQ.
WebSphere MQ queue manager created.
Directory '/var/mqm/qmgrs/WMBQMB7' created.
Creating or replacing default objects for WMBQMB7.
Default objects statistics : 65 created. 0 replaced. 0 failed.
Completing setup.
Setup completed.

Now I am trying to create a broker (odbc.ini of course edited):

This is what happens:

[mqbrkr@localhost bin]$ ./mqsicreatebroker brokerTest8 -i mqbrkr -a password -q WMBQM8 -n WMBDB -u oracleuser -p password -s WMBQM
There are 89 days left in the trial period for this copy of WebSphere MQ.
WebSphere MQ queue manager created.
Directory '/var/mqm/qmgrs/WMBQM8' created.
Creating or replacing default objects for WMBQM8.
Default objects statistics : 65 created. 0 replaced. 0 failed.
Completing setup.
Setup completed.
There are 89 days left in the trial period for this copy of WebSphere MQ.
WebSphere MQ queue manager 'WMBQM8' starting.
5 log records accessed on queue manager 'WMBQM8' during the log replay phase.
Log replay for queue manager 'WMBQM8' complete.
Transaction manager state recovered for queue manager 'WMBQM8'.
WebSphere MQ queue manager 'WMBQM8' started.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
The setmqaut command completed successfully.
Aborted

Here is the entry from odbc.ini - just in case :

[WMBDB]

Driver=/opt/ibm/mqsi/6.1/ODBC32/V5.3/lib/UKase23.so
Description=WMB DB
Database=xe
EnableDescribeParam=1
OptimizePrepare=1
SelectMethod=0
NetworkAddress=192.168.1.125,1521
SelectUserName=1
ColumnSizeAsCharacter=1
Charset=UTF8
EnableSPColumnTypes=2

The weird problem is that I do not get any errors is /var/log/messages. Also if I replace the WMBDB database with a dummy value - it still does not work.

For example I do it like this :

./mqsicreatebroker brokerTest8 -i mqbrkr -a password -q WMBQM8 -n NotPresent -u oracleuser -p password -s WMBQM.

I mean "NotPresent" is not even part of odbc.ini file, so I guess it is not a database issue at all.

I though may be there is something wrong with the driver or permissions, but then again :

ldd UKor823.so
linux-gate.so.1 => (0xffffe000)
libpthread.so.0 => /lib/libpthread.so.0 (0xf7dc7000)
librt.so.1 => /lib/librt.so.1 (0xf7dbe000)
libUKicu23.so => /opt/ibm/mqsi/6.1/ODBC32/V5.3/lib/libUKicu23.so (0xf72d2000)
libclntsh.so => /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/libclntsh.so (0xf64fc000)
libodbcinst.so => /opt/ibm/mqsi/6.1/ODBC32/V5.3/lib/libodbcinst.so (0xf644f000)
libdl.so.2 => /lib/libdl.so.2 (0xf644a000)
libstdc++.so.5 => /usr/lib/libstdc++.so.5 (0xf6391000)
libm.so.6 => /lib/libm.so.6 (0xf6368000)
libc.so.6 => /lib/libc.so.6 (0xf620e000)
libgcc_s.so.1 => /lib/libgcc_s.so.1 (0xf6202000)
/lib/ld-linux.so.2 (0x001ca000)
libnnz10.so => /usr/lib/oracle/xe/app/oracle/product/10.2.0/client/lib/libnnz10.so (0xf5ff3000)
libnsl.so.1 => /lib/libnsl.so.1 (0xf5fda000)

[mqbrkr@localhost ~]$ ls -l /opt/ibm/mqsi/6.1/ODBC32/V5.3/lib/
total 24572
-rwxr-xr-x 1 mqbrkr mqbrkrs 1032658 Apr 15 2010 libodbcinst.so
-rwxr-xr-x 1 mqbrkr mqbrkrs 1470289 Apr 15 2010 libodbc.so
-rwxr-xr-x 1 mqbrkr mqbrkrs 11643900 Oct 16 2008 libUKicu23.so
-rwxr-xr-x 1 mqbrkr mqbrkrs 1338768 Apr 15 2010 libUKmback.so
-rwxr-xr-x 1 mqbrkr mqbrkrs 1335833 Apr 15 2010 libUKmbackw.so
-rwxr-xr-x 1 mqbrkr mqbrkrs 1283829 Apr 15 2010 odbccurs.so
-rwxr-xr-x 1 mqbrkr mqbrkrs 234447 Apr 15 2010 odbctrac.so
-rwxr-xr-x 1 mqbrkr mqbrkrs 2667374 Apr 15 2010 UKase23.so
-rwxr-xr-x 1 mqbrkr mqbrkrs 16329 Apr 15 2010 UKasedtc23.so
-rwxr-xr-x 1 mqbrkr mqbrkrs 619675 Apr 15 2010 UKmsss23.so
-rwxr-xr-x 1 mqbrkr mqbrkrs 25012 Apr 15 2010 UKmsssdlg23.so
-rwxr-xr-x 1 mqbrkr mqbrkrs 2101921 Apr 15 2010 UKor823.so
-rwxr-xr-x 1 mqbrkr mqbrkrs 1179574 Jan 5 2010 UKor8dtc23.so
-rwxr-xr-x 1 mqbrkr mqbrkrs 61914 Apr 15 2010 vscnctdlg.so

May MQ7 is not supported under WMB 6.1.0.8 - but Iread it is...
So, may be someone could point me to some logs or something like that or give me a hint of what I am going wrong.

Thank you very much,
Eugene.