Managing ODP.NET Connections during Oracle Database Service Relocations and Switchovers (Doc ID 2787083.1)

Last updated on APRIL 17, 2023

Applies to:

Details

FCF ensures end users do not encounter errors when trying to connect as long as one active database service member remains. For already connected users, FCF does not prevent errors nor lost work when the service is taken offline, but the Oracle Database can be configured to do so. And because the database administrator enables these capabilities, zero .NET app code changes are needed to use them.

Actions

Database Service Relocations

The following Oracle Server Control Utility (SRVCTL) command demonstrates how to relocate a database service with the -stopoption parameter set to TRANSACTIONAL:

The WAIT option specifies the number of seconds to wait for sessions to drain before proceeding with the switchover.

A typical switchover process has FCF remove idle ODP.NET connections from the pool. Connections subsequently checked in are destroyed until no active connections remain to the primary database. If the WAIT is set, users have time to complete their work and disconnect. The primary database is then brought down and the standby is brought up. When the switchover completes, a FCF UP event informs ODP.NET that it can start opening connections to the standby instance.

Contacts

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.