Connection delays
We are testing our new 19c (19.8) RAC cluster (Oracle linux 7, 19c (19.8), 3-node) and have encountered delays when accessing the "failover" (DR) RAC.
Here is our TNS entry (getting same issue with JDBC):
PROD_TEST =
(DESCRIPTION =
(LOAD_BALANCE=on)
(FAILOVER=on)
(TRANSPORT_CONNECT_TIMEOUT= 1)
(CONNECT_TIMEOUT=3)
(RETRY_COUNT=2)
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=<prod-Primary>)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=<prod-StandBy>)(PORT=1521))
)
(CONNECT_DATA=(SERVICE_NAME=prod_test.edc.docupace.internal))
)
Millisecond connection times using above entry when accessing the Primary. But connection times escalate when the roles are reversed (i.e. when StandBy is now active) up to ~3secs. I understand the physics involved since our DR site is a distance away, but we can't have that much of delay.