• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1309
  • Last Modified:

Oracle RAC Load balancing and ODBC

We have just installed an Oracle RAC solution. We still have one old VB app that needs to access one of the databases. My understanding to date has been that to do this I need to configure the TNSnames entry to ignore load balancing as ODBC couldnt cope with this (using the standard MS ODBC drivers).

I'd appreciate any info on whether this is still the case. I'm using the MS for oracle driver version

200.85.1022.00
0
colindow
Asked:
colindow
1 Solution
 
Gibu GeorgeCTOCommented:
Use the oracle 10g ODBC driver, and add the tns entry like this
RAC =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = rac1)(PORT = 1521))
  (ADDRESS = (PROTOCOL = TCP)(HOST = rac2)(PORT = 1521))
  (LOAD_BALANCE = ON)
  (FAILOVER = ON)
  (CONNECT_DATA =
  (SERVICE_NAME = rac)
  (failover_mode = (type=select)(method=basic))
  )
  )

0
 
colindowAuthor Commented:
Hi in fact it turned out that there was a rather strange entry in out DNS lookup. We had to use a network trace to find this out. Very odd as it worked intermittently.

Ill mark as answered so that any viewer can see the solution
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now