Solved

Oracle RAC Load balancing and ODBC

Posted on 2006-11-24
2
1,302 Views
Last Modified: 2012-06-21
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
Comment
Question by:colindow
2 Comments
 
LVL 12

Accepted Solution

by:
Gibu George earned 250 total points
ID: 18044960
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
 

Author Comment

by:colindow
ID: 18115937
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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Oracle DB Slows After Datapump Until Next Reboot 27 122
Help with Oracle IF statment 5 34
Loading flat file data in tables 2 58
Oracle Nested table uses ? 2 44
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

679 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question