| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Oracle RAC - conneciton string |
« View previous topic :: View next topic » |
| Author |
Message
|
| mqwbiwf |
 Posted: Thu Sep 02, 2010 1:54 pm Post subject: Oracle RAC - conneciton string |
 |
|
Centurion
Joined: 21 Jul 2006
Posts: 126
|
here's our scenario:
we connect to the oracle database (application DB) RAC nodes from our message broker v6.1 on AIX. The ODBCINI64.INI has the following entry:
;# Oracle Real Application Clusters stanza
[QWE]
Driver=/usr/XXX/ODBC64/V5.3/lib/UKora23.so
Description=DataDirect 5.3 64bit Oracle Wire Protocol
HostName=Host1
PortNumber=1531
ServiceName=ABC
;#This shows one alternate server definition. Add extra ones using a ',' to seperate each definition.
AlternateServers=(HostName=Host2:PortNumber=1531:ServiceName=ABC,HostName=Host3:PortNumber=1531:ServiceName=ABC)
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1
EnableNcharSupport=1
When looked at the network statistics, we find more "connection requests" going from WMB server to Host1 than the other two(host 2 and host3).
so, wondering if this URL really provides load balancing or is it more of a failover connection string? we just used whatever IBM recommended to use in the document, not much of an information could be found around this topic there.
any insight would be of great help....
Thanks! |
|
| Back to top |
|
 |
| AkankshA |
| Posted: Thu Sep 02, 2010 9:49 pm Post subject: Re: Oracle RAC - conneciton string |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
|
| Back to top |
|
|
| shruthi |
| Posted: Thu Sep 09, 2010 8:38 am Post subject: |
|
|
Apprentice
Joined: 04 Apr 2008
Posts: 43
|
I guess its the same .
Any idea how RAC works in WMB? |
|
| Back to top |
|
|
| woodoo2k |
| Posted: Fri Nov 05, 2010 9:41 am Post subject: |
|
|
Apprentice
Joined: 07 Feb 2005
Posts: 28
Location: USA
|
Since you are using Host1 in the hostname, it is obvious that it will go to host1.
You need to use either the serverName property to use Oracle tnsnames.ora and sqlnet or create a floating VIP that maps to host1, host2 and host3. |
|
| Back to top |
|
|
| JLRowe |
| Posted: Wed Nov 10, 2010 5:13 am Post subject: |
|
|
Yatiri
Joined: 25 May 2002
Posts: 664
Location: South East London
|
| No, don't amend tnsnames.ora. He is using the thin client which does not go through the oracle client install. Therefore, tnsnames.ora will be ignored. |
|
| 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
|
|
|
|
