MQSeries.net :: View topic - Message Broker V6.1 + Oracle RAC Connectivity

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Message Broker V6.1 + Oracle RAC Connectivity

Message Broker V6.1 + Oracle RAC Connectivity

« View previous topic :: View next topic »

Author

Message

dipinci

Posted: Mon Apr 13, 2009 5:55 am Post subject: Message Broker V6.1 + Oracle RAC Connectivity

Newbie

Joined: 13 Apr 2009
Posts: 3

I have a WebSphere Message Broker V6.1 on AIX Platform and The Broker DB is connected to the Single Oracle Instance and the User Database should be configured to Oracle RAC. What could be the configuration in the ODBC64.ini file.

Oracle Admin provided two hostname, port number and the servicename.

But the OBDC64.ini file has only one entry(Hostname=) to provide hostname. In this case how we can configure the Oracle RAC with Message Broker V6.1

WMBDEV1

Posted: Mon Apr 13, 2009 6:54 am Post subject:

Sentinel

Joined: 05 Mar 2009
Posts: 888
Location: UK

Use an address_list with mutliple addresses in there.

Here is an example of such a tnsnames.ora file:

http://www.dba-oracle.com/grid_208.htm

mqjeff

Posted: Mon Apr 13, 2009 7:21 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

The 64-bit driver for Broker is a Wire driver and not a driver that will use the tnsnames.ora file.

The Oracle DBA should be able to assist with this configuration.

WMBDEV1

Posted: Mon Apr 13, 2009 9:52 am Post subject:

Sentinel

Joined: 05 Mar 2009
Posts: 888
Location: UK

Sorry, didnt realise this, just guessed it was the same as the other Oracles I had worked with but obviously not!!!!

Dont know if this link helps but it does mention configuring the 64 bit odbc connecting to RAC:

http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r1m0/index.jsp?topic=/com.ibm.etools.mft.doc/ah25530_.htm

mqjeff

Posted: Mon Apr 13, 2009 10:21 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

Of course, the relevant section for the 64-bit driver is even specific on this.

http://publib.boulder.ibm.com/infocenter/wmbhelp/v6r1m0/index.jsp?topic=/com.ibm.etools.mft.doc/ah14444_.htm

WMBDEV1

Posted: Mon Apr 13, 2009 11:01 am Post subject:

Sentinel

Joined: 05 Mar 2009
Posts: 888
Location: UK

Yes, this is the link i meant to post but i accessed it from the 32 bit driver page and the url didnt update in my IE, sorry again but I seem to be having a bit of a nightmare atm.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Message Broker V6.1 + Oracle RAC Connectivity

Jump to:

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

Protected by Anti-Spam ACP