Database - RAC/Scalability (MOSC)

MOSC Banner

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center