| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Help for Problem whit Mqseries and Oracle |
« View previous topic :: View next topic » |
| Author |
Message
|
| lpizzi |
 Posted: Wed Jan 16, 2002 5:38 am Post subject: |
 |
|
Newbie
Joined: 15 Jan 2002
Posts: 4
Location: Italia
|
Under HP-UX11 my application using ORACLE 8.05 and mqseries 5.1 could not connect at the qmanager with error 2058 (qmanager not avaible). if i use an application whith not oracle inside it work correctly.
I don't know if that problem is know, but it is really and seem present only on platform HP-UX-11.
Thank for interesting and sorry for my bad english. |
|
| Back to top |
|
 |
| bduncan |
| Posted: Thu Jan 17, 2002 2:24 pm Post subject: |
|
|
Padawan
Joined: 11 Apr 2001
Posts: 1554
Location: Silicon Valley
|
Could you please give a little more detail about the problem? When you say the application works without Oracle, do you mean on a machine that doesn't have Oracle running on it, or do you mean you removed the calls to Oracle from your application? Also, what language is your application in?
_________________
Brandon Duncan
IBM Certified MQSeries Specialist
MQSeries.net forum moderator |
|
| Back to top |
|
|
| lpizzi |
| Posted: Mon Jan 21, 2002 1:53 am Post subject: |
|
|
Newbie
Joined: 15 Jan 2002
Posts: 4
Location: Italia
|
Sorry for the absence.
I mean the remove calls oracle from my application write in C language. However i resolve the problem (if this solution can consider so).
For other whit my problem i have resolve it Changing the order of dynamic library linked in this :
libc [myapplication including mqseries library] [oracle library].
I have find a answer of IBM support for a similar problem and attach it below:
PROBLEM SUMMARY:
We are in the process of upgrading to HP-UX 11.0 and
MQSeries 5.1 and have encountered the following problem:
The application is unable to connect to the QMGR. We are receiving no
The application is unable to connect to the QMGR. We are receiving no
FDC or error messages in any logs. The application simply cores. We
have executed using DDE and it appears the application is coring on
pthread_getspecfic. (The applications failing to connect are also
using Oracle 7.3.4).
In the trace file I find non-zero return codes for XllWaitSocketEvent
and xihGetNextSetConnDetailsFromList.
SOLUTION:
Reviewed the trace files sent and there are a lot of rc=10806020 on
the xllWaitSocketEvent which basically translates into 0x10806020
xecL_W_TIMEOUT. I think we have seen this before when MQSeries for
HP-UX V5.1 HP-UX Version 11, which uses draft 10 threads, is trying
to act as transaction coordinator with Oracle 7.3.4, which uses draft
4 threads.
Cust application is non-DCE. Compiled the application on HP-UX 11.0.
Tried linking using varied combinations of the libraries. Using the
threaded libraries, I get the same results whether the MQSeries
libraries are first or last. If compiled using non-threaded libraries
the Oracle connections are made and the program cores during the MQ
Connection. Using the threaded libraries, the program immediately
cores.
Programs that do not use both Oracle and MQSeries work just fine.
I did have a small success. We created a very small program that
connects to an ORACLE database, does one select, connect to MQSeries
and does one query. This small program worked. I used libmqmxa_d and
libc_r in the mksl makefile. Using the same libraries in the compile
and link of the application program only moved the abend to different
place in the program. But perhaps this hopefully means my libraries
are not in proper sequence as opposed to an incompatibility between
ORACLE and MQSERIES versions.
There is no need to link with the libmqmxa_d library. Please ask the
cust to change options to include only the following MQ libraries:
LIBS = -L/opt/mqm/lib -lmqm_r -lcma (No lpthread).
Please add in ORACLE_LIBS the library -libclntsh. Also, please ensure
the MQ libraries are linked before the Oracle ones. I am assuming
cust has MQ standard installation and not MQSeries installed with the
DCE installation.
Discussed this issue with System Test. We feel MQSeries is not at
fault here and cust has to refer to Oracle 7 and HP 11 documentation
along with the MQ manuals for info about the linking of libs. That MQ
apps and Oracle apps work individually supports this. Our updated
Application Programming Guide states there are different MQSeries
libraries for non-threaded, threaded (POSIX draft 10) and POSIX draft
4 (DCE) environments. Please ask cust to refer it.
Please ask cust to find out if Oracle provides different libraries
for compiling with threaded / non-threaded apps? Our understanding is
the libraries are multi-threaded - and so, even though cust is
writing a non-threaded application, we will have to link with
threaded MQ libraries (to avoid mixing of threaded and non-threaded
libs).
Cust tried compiling using -lmqm_r -lpthread or -lmqm lcma or -lmqm.
The results are pretty much the same. Either Oracle will fail it's
connection or MQSeries will fail it's connection.
We were unsuccessful in all attempts. The current plan is upgrade to
Oracle 8.1.6.
PROBLEM DETAILS:
TYPE: USE ISV OEM RELI INST DOC
COMPID: 5765B7400
BYe.
|
|
| 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
|
|
|
|
