Database Networking (MOSC)

MOSC Banner

Client connection timeout after switchover to standby

edited Jul 31, 2019 11:15AM in Database Networking (MOSC) 16 commentsAnswered ✓

Hi,

We have two data centers and all connection strings have the similar as below:

ALIASNAME =

  (DESCRIPTION =

       (ADDRESS = (PROTOCOL = TCP)(HOST = primary-scan)(PORT = primary.port))

       (ADDRESS = (PROTOCOL = TCP)(HOST = standby-scan)(PORT = standby.port))

       (CONNECT_DATA =

           (SERVICE_NAME = database_servicename)

       )

  )

When we complete the database switchover, clients can still connect to database that is running on new primary.

However, we got the problem that when the primary nodes (all nodes on the same RAC) are power off, client connection will timeout after (15 seconds * number of nodes).

It looks like client still PING all available nodes on the first provided address (primary-scan as above), then it will go to PING second address.

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