dotConnet for Oracle support for load balancing

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
sijish
Posts: 1
Joined: Mon 25 Jun 2018 06:56

dotConnet for Oracle support for load balancing

Post by sijish » Mon 25 Jun 2018 07:06

Hi,

Does dotConnet for Oracle supports load balancing in RAC database?
In your documentation for connection string properties, I could not find the Load balancing.

https://www.devart.com/dotconnect/oracl ... tring.html

Please can someone advice if this is supported and how to enable load balancing?

thanks
Siji

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: dotConnet for Oracle support for load balancing

Post by Pinturiccio » Mon 25 Jun 2018 12:55

dotConnect for Oracle supports load balancing in a RAC database only in the OCI connection mode. When you use the OCI connection mode, all work is done by Oracle Client. This is true for load balancing too. You do not need to specify any connection string parameters for it. It's only required that the "(LOAD_BALANCE=on)" was present in the tnsnames.ora file for the corresponding database. Oracle Client will care about the rest. For more information, please refer to https://docs.oracle.com/cd/E11882_01/ne ... m#NETRF265

Post Reply