| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Oracle database connectivity issue from iib 9.0.0.5 |
« View previous topic :: View next topic » |
| Author |
Message
|
| kiran areti |
 Posted: Tue Aug 30, 2016 12:42 am Post subject: Oracle database connectivity issue from iib 9.0.0.5 |
 |
|
Newbie
Joined: 17 Jun 2014
Posts: 4
|
Hi all,
I have a strange problem that when i try to invoke a oracle procedure from iib v9 broker i'm facing below issue.
We have around 30 execution groups, all the flows in the all execution groups are able to connect to DB except few flows in one execution group. ALL execution groups are using same DSN.
can any one help me out of this problem.
broker is in AIX server.
DatabaseException BIP2321E: Database error: ODBC return code '-1' using ODBC driver manager ''/opt/ibm/IE02/2.0.1/lib/libodbcinterface.so''.
The message broker encountered an error when processing a database operation. The ODBC return code was '-1'. See the following messages for information obtained from the database concerning this error.
Use the following messages to determine the cause of the error. Typical problems are an incorrect datasource or table names. Correct either the database or message broker configuration.
2016-08-29 17:46:08.879292 14394 DatabaseException BIP2322E: Database error: SQL State ''HY000''; Native Error Code '-5'; Error Text ''[IBM][ODBC Oracle Wire Protocol driver][Oracle]Unexpected Network Error.''.
The error has the following diagnostic information: SQL State ''HY000'' SQL Native Error Code '-5' SQL Error Text ''[IBM][ODBC Oracle Wire Protocol driver][Oracle]Unexpected Network Error.''
This message may be accompanied by other messages describing the effect on the message broker itself. Use the reason identified in this message with the accompanying messages to determine the cause of the error. Use the mqsicvp command to test connectivity to this database. |
|
| Back to top |
|
 |
| smdavies99 |
| Posted: Tue Aug 30, 2016 12:52 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
Are your Oracle DBA's limiting connections from a single source?
What do the DBA's say on this error?
As the text say, it is a network error. That leads me to think that some limit is being reached somewhere.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| RKos |
| Posted: Mon Sep 18, 2017 12:50 am Post subject: |
|
|
Newbie
Joined: 18 Sep 2017
Posts: 1
|
Hi All,
We are stucked with the same problem.
Problem is recreated on IIB 9.0.0.5, 9.0.0.6, 9.0.0.8 (AIX) with Oracle DB 12c on RedHat.
Has anyone found a solution?
Most likely this is not a network error. It appears only when a certain procedure is called with certain parameters. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Mon Sep 18, 2017 3:20 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| RKos wrote: |
| Most likely this is not a network error. It appears only when a certain procedure is called with certain parameters. |
Ok. So there's your problem.
Make a mock stored procedure that accepts those parameters and returns constant values.
If that doesn't work, then revisit your ODBC datasource, and all the documentation on calling Oracle Stored Procedures.
If you still can't make it work, open an APAR.
I don't know if Broker v9 still uses the DataDirect oracle driver. If it does, you can dig up the documents from DataDirect on that, and install a real Oracle Driver and configure the DataDirect driver to use that.
It's unsupported to do that, though.
_________________
chmod -R ugo-wx / |
|
| 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
|
|
|
|
