My Oracle Support Banner

ORA-604, ORA-6550, PLS-201 When Pushing the Deferred Transactions in Multi-site Environment (Doc ID 468120.1)

Last updated on JANUARY 02, 2024

Applies to:

Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.

Symptoms

After successful upgrade of one multi-site replication site from 8i or 9i to 10g, the next errors may be occur when trying to push the deferred transactions:

Errors :
------
The next example demonstrates Multi-site replication environment includes 2 sites: DB1 and DB2, we have upgraded DB2 from 8i to 10g, while DB1 is still not upgraded:

Changes

The database was upgraded from 8i or 9i to 10g .

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution

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