How to fix the Oracle error ORA-23654: Attempting to set the oldest SCN to a greater value (string) than the current one (string) at Apply string?

In this post, you’ll learn more about the Oracle ErrorORA-23654: Attempting to set the oldest SCN to a greater value (string) than the current one (string) at Apply string with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-23654: Attempting to set the oldest SCN to a greater value (string) than the current one (string) at Apply string

Reason for the Error ORA-23654: Attempting to set the oldest SCN to a greater value (string) than the current one (string) at Apply string

The new value for the oldest SCN was not computed correctly.

How to fix the Error ORA-23654: Attempting to set the oldest SCN to a greater value (string) than the current one (string) at Apply string ?

You can fix this error in Oracle by following the below steps

Make sure Capture and Apply are running, and Capture is making progress.