DB Persistence - Order Flow During The DB Switchover Is Creating Customer In BRM Transaction (Doc ID 2782218.1)

Last updated on MARCH 22, 2023

Applies to:

Symptoms

In Active Active architecture, there are 2 databases (DB) each site. One DB is the primary and second DB is the standby connected by data guard.

The customer run the script to send request to both site1 and site2 to create subscribers.
During this time, the customer has performed the DB switchover.

During the DB switchover, a short DB disconnection will happen and during this time, account creation will fail which as expected.
But this is creating some subscribers in BRM transaction locks which is not expected.

Locks in Site1, once account creation is completed:

Cause

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