ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

Added on Feb 23 2024

1 comment

408 views