Page 1 of 1

Direct Connect Support for Load Balancing

Posted: Mon 19 Jul 2010 23:36
by kiroc
I know that direct connect mode doesn't officially support Oracle load balancing. What if the VIPs in an Oracle cluster were placed behind a hardware load balancer? Could the application that uses DevArt's component then connect to the load balancer using direct connect mode?

Posted: Fri 23 Jul 2010 11:13
by bork
Hello

We didn't implement any functionality for connecting with the Oracle load balancing. But if Oracle load balancing uses the same protocol as an ordinary Oracle server does then you can use ODAC for connecting to the Oracle load balancing.

In any case you can download ODAC trial version and try to connect to the Oracle load balancing.

Posted: Fri 23 Jul 2010 15:42
by kiroc
Would any type of query work to test ODAC with Oracle RAC? Or would you suggest some particular kinds of queries?

Posted: Mon 26 Jul 2010 13:19
by bork
For end-user application connecting process to the Single-instance Oracle server and to the Oracle RAC is the same and the application will use the same queries. So you can use your standard queries to test connection to Oracle RAC.