| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Connecting to Oracle RAC DB |
« View previous topic :: View next topic » |
| Author |
Message
|
| kspranava |
 Posted: Wed Jun 08, 2011 9:53 pm Post subject: Connecting to Oracle RAC DB |
 |
|
Centurion
Joined: 27 Apr 2003
Posts: 124
|
Hi All,
While connecting to Oracle RAC DB from WMB v6.1, is it possible to replicate (SERVER = DEDICATED/SHARED) which we used to provide in tnsnames.ora?
Thanks,
Pranav. |
|
| Back to top |
|
 |
| lancelotlinc |
| Posted: Thu Jun 09, 2011 4:30 am Post subject: |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
That depends on the ODBC driver. Which ODBC driver are you using, and does it support this parm?
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
| mqjeff |
| Posted: Thu Jun 09, 2011 4:37 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| lancelotlinc wrote: |
| That depends on the ODBC driver. Which ODBC driver are you using, and does it support this parm? |
Well, in theory it depends on the ODBC driver.
But since we're talking about Broker v6.1, presumably it's the DataDirect v5.3 Driver.
And since we're talking about "not tnsnames.ora", we're presumably talking about the 64-bit Wire Level driver.
On the other hand, there's no indication that ODBC is in use at all here. It could entirely be JDBC.
So perhaps Pranav will provide some clarity on these things. And then provide some demonstration of research into the capabilities of the 64-bit wire level driver and where that research left the question open of "does this support (SERVER=DEDICATED/SHARED)".
I'd say odds are about 50/50 that the v5.3 wirelevel driver supports this. I know for a fact that the v6.0 driver that comes with Broker v7 does, because I know for a fact that the v6.0 driver supports the use of tnsnames.ora.
Well, I know that the v6.0 driver allows you to put anything you want into a tnsnames.ora file. I won't go so far as to say that it explicitly OBEYS the information contained by (SERVER=DEDICATED/SHARED). Especially if it conflicts with the statement in the docs about which HA features of Oracle RAC are actually supported. |
|
| Back to top |
|
|
| kspranava |
| Posted: Thu Jun 09, 2011 11:19 pm Post subject: |
|
|
Centurion
Joined: 27 Apr 2003
Posts: 124
|
Hi All,
It is WMBv6.1.0.3, Solaris 5.10 using DataDirect 5.3 (Driver=/opt/IBM/mqsi/6.1/ODBC64/V5.3/lib/UKora23.so) and no tnsname.ora is involved. Background behind this question, we had intermittent connection issue between WMB server and Oracle DB server. Oracle ACS has come back telling to implement SERVER=DEDICATED, but I was wondering how to set up that as we don’t use tnsnames.ora.
Exception we are getting now & then in WMB is, (Note: This setup is working most of the time, but failing occasionally)
| Code: |
Apr 11 00:07:39 serverabc WebSphere Broker v6103[13711]: [ID 702911 user.error] (EESO851P.MessageFlow1)[38]BIP2393E: Database error: ODBC return code '-1' from data source
'EAIDBBSL'. : BrokerABC.8bdd7f98-2901-0000-0080-d2b2eec3efc9: /build/S610_P/src/DataFlowEngine/ImbOdbc.cpp: 323: ImbOdbcHandle::checkRcInner: :
Apr 11 00:07:39 serverabc WebSphere Broker v6103[13711]: [ID 702911 user.error] (BrokerABC.MessageFlow1)[38]BIP2322E: Database error: SQL State 'HY000'; Native Error Code '
1509'; Error Text '[IBM][ODBC Oracle Wire Protocol driver]File not found '.odbcinst.ini'.'. : BrokerABC.8bdd7f98-2901-0000-0080-d2b2eec3efc9: /build/S610_P/src/DataFlowE
ngine/ImbOdbc.cpp: 438: ImbOdbcHandle::checkRcInner: :
Apr 11 00:07:39 serverabc WebSphere Broker v6103[13711]: [ID 702911 user.error] (BrokerABC.MessageFlow1)[38]BIP2322E: Database error: SQL State '08S01'; Native Error Code '
0'; Error Text '[IBM][ODBC Oracle Wire Protocol driver]Connection refused. Verify Host Name and Port Number.'. : BrokerABC.8bdd7f98-2901-0000-0080-d2b2eec3efc9: /build/S
610_P/src/DataFlowEngine/ImbOdbc.cpp: 438: ImbOdbcHandle::checkRcInner: : |
|
|
| 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
|
|
|
|
