| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Using Oracle Client with WMB v7. |
« View previous topic :: View next topic » |
| Author |
Message
|
| mqkar |
 Posted: Tue Apr 05, 2011 12:52 am Post subject: Using Oracle Client with WMB v7. |
 |
|
Newbie
Joined: 05 Apr 2011
Posts: 5
|
Hello,
I am trying to configure a DSN to an Oracle user database using the ODBC drivers supplied with WMB v7- x86-64, without installing the Oracle client at all .
I am not sure why, but when I check the db configuration (for the db I want to connect to) in tnsnames.ora file in other servers, it specifies multiple address lists, which means multiple host names and port numbers for a given tnsnames entry. (I am thinking there are multiple instances running for load balancing).
Now, the sample odbc.ini format in <WMBv7 install loc>/ODBC/V6.0 specifies the DSN format to connect to a non RAC Oracle database which I want to use. But this has only only option each for hostname, port and SID.
Is there some way to specify multiple hostnames and ports for a DSN in odbc.ini?
Or Can I use the WMB v6 format of defining a DSN after installing the Oracle client.
P.S.: Multiple hostnames and ports are mandatory due to the volume of db transactions.
Thanks,
Kar. |
|
| Back to top |
|
 |
| mqkar |
| Posted: Tue Apr 05, 2011 8:26 am Post subject: |
|
|
Newbie
Joined: 05 Apr 2011
Posts: 5
|
|
| Back to top |
|
|
| fjb_saper |
| Posted: Tue Apr 05, 2011 10:22 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| Quote: |
| I am not sure why, but when I check the db configuration (for the db I want to connect to) in tnsnames.ora file in other servers, it specifies multiple address lists, which means multiple host names and port numbers for a given tnsnames entry. (I am thinking there are multiple instances running for load balancing). |
What you most likely have here is an oracle RAC. Check with your DBA's as to what is appropriate. 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| mqjeff |
| Posted: Tue Apr 05, 2011 12:49 pm Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
| The sample ODBC ini for OracleRAC includes an Alternate* set of parameters. |
|
| Back to top |
|
|
| mqkar |
| Posted: Tue Apr 05, 2011 3:03 pm Post subject: |
|
|
Newbie
Joined: 05 Apr 2011
Posts: 5
|
Thanks for your responses.
The database in not RAC. It simply has multiple listeners configured on same server for failover (I misread that as multiple hostnames).
I anyway used the AlternateServers entry in the non-RAC stanza and it works, failover and all 
So as far as constructing DSN stanzas are concerned, it looks like the best source of info is the DataDirect online library. But I think its better to check with IBM first and test well. |
|
| 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
|
|
|
|
