Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

ODP.NET Oracle Connection string LOAD_BALANCE=on not working

Muhammad AsimFeb 23 2024

I received Oracle Connection string from server team having multiple addresses with Load balance enabled.

Data Source= (DESCRIPTION= (ADDRESS_LIST= (LOAD_BALANCE=on) (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.1)(PORT=MyPort)) (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.2)(PORT=MyPort)) )(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=MyOracleSID)));User Id=myUsername;Password=myPassword;

We observed that all our traffic routed to first address i.e. 192.168.0.1. Same datasource successfully distribute load on weblogic and WebSphere. It seems .Net is unable to distribute load.

For reference I am using .NET 7 and Oracle.ManagedDataAccess.Core version 3.21.50.

Can you please share reason of not supporting load balancing, and what is work around to distribute load on multiple nodes.

This post has been answered by Alex Keh-Oracle on Feb 24 2024
Jump to Answer
Comments
Post Details
Added on Feb 23 2024
1 comment
84 views