ORA-02097 And ORA-55569 Reported While Increasing UNDO_RETENTION Parameter Value (Doc ID 2098354.1)

Last updated on AUGUST 09, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 09-Aug-2017***

Symptoms

ORA-2097 and ORA-55569 is reported while increasing the value of UNDO_RETENTION parameter. This can happen in any version above 10.2.0.4 (or with a fix for Bug 7291739 in place).




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