Skip to Main Content

ODP.NET

Announcement

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

Oracle.ManagedDataAccess.Core - Retry Count not working

Egor SavchenkoNov 27 2023

Oracle.ManagedDataAccess.Core v3.21.120

We have two database servers, and we need to connect to the second server if the first server fails.

Here is our connection string:

User Id=TEST;CONNECTION TIMEOUT=10;HA Events=true;Data Source=(DESCRIPTION =
 (TRANSPORT_CONNECT_TIMEOUT=10) (RETRY_COUNT=1)(RETRY_DELAY=5)
 (ADDRESS_LIST =
(LOAD_BALANCE=on)
( ADDRESS = (PROTOCOL = TCP)(HOST=172.30.2.211)(PORT=1521)))
 (ADDRESS_LIST =
(LOAD_BALANCE=on)
( ADDRESS = (PROTOCOL = TCP)(HOST=172.30.2.212)(PORT=1521)))
 (CONNECT_DATA=(SERVICE_NAME = odb)))

The RETRY_COUNT parameter is not working as expected. When we try to open the connection initially, we get a Connection request timed out exception, and when we try to open the connection again, we successfully connect to the database server. How can we make it so that it connects to the second server (172.30.2.212) immediately without throwing an exception?

This post has been answered by Alex Keh-Oracle on Nov 27 2023
Jump to Answer
Comments
Post Details
Added on Nov 27 2023
1 comment
124 views