Queries Fail Intermittently With ORA-3170 On ADG

(Doc ID 2311894.1)

Last updated on OCTOBER 21, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Alert log of  Active Data Guard databases report ORA-03170

  Mon Aug 15 14:00:05 2016
  Errors in file /u01/app/oracle/diag/rdbms/lnxdrc1/lnxdrc12/trace/lnxdrc12_ora_20482.trc:
  ORA-03170: deadlocked on readable physical standby (undo segment 1161)
  Mon Aug 15 14:01:13 2016
  Errors in file /u01/app/oracle/diag/rdbms/lnxdrc1/lnxdrc12/trace/lnxdrc12_ora_23350.trc:
  ORA-03170: deadlocked on readable physical standby (undo segment 1161)

Fix for Bug 21889720 - hitting ORA-3170 continuously on one standby node (Doc ID 21889720.8) was applied but issue still occurs.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms