My Oracle Support Banner

Implementing replication of cyclic sequences in GoldenGate (Doc ID 1321558.1)

Last updated on AUGUST 07, 2023

Applies to:

Oracle GoldenGate - Version 10.0.0.0 and later
Information in this document applies to any platform.

Purpose

OGG has added support for replication of cyclic sequences in the 11.1.1.1.x builds.
     
Backport: Any code prior to v11.1.1.x must contain patch 9428942 to reliably replicate cyclic sequences.
     
Documentation for versions 10.0, 10.4 and 11.1 states that extract supports sequences. In fact, sequences were not intended to be supported and did not work seamlessly.

This note describes the proper implementation of replication of cyclic sequences.

Scope

This covers the replication of cyclic sequences in the 11.1.1.1.x and subsequent builds.
    
Backport: Any code prior to v11.1.1.x must contain patch 9428942 to reliably replicate cyclic sequences.

 

Failure to use the right code version or to follow the implementation and installation procedures might result in a replicat abend with messages similar to this: 

2011-04-20 17:35:53 ERROR OGG-01444 Oracle GoldenGate Delivery for Oracle, <rep_name>.prm: Error in replicating sequence value [ORA-06550: line 1, column 8: PLS-00201: identifier '<OGG_ADMIN>.REPLICATESEQUENCE' must be declared 
ORA-06550: line 1, column 8: PL/SQL: Statement ignored, SQL BEGIN "<OGG_ADMIN>" .replicateSequence (col1,col2,col3, 'col4',col5, 'col6', 'col7',col8, col9, ''); END;].
2011-04-20 17:35:53 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, <rep_name>.prm: PROCESS ABENDING.

 

Details

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
Purpose
Scope
Details
 References

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