My Oracle Support Banner

Replicat reports OGG-25092 with PLS-00201: identifier 'GG_ADMIN.REPLICATESEQUENCE' must be declared (Doc ID 2779800.1)

Last updated on JUNE 03, 2021

Applies to:

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

Symptoms

Oracle GoldenGate (OGG) 19c Integrated replicat with target Oracle 12c target database was configured to replicate sequences.  The following was then reported in the replicat report file:

-- NOTE: <OWNER>.<SEQUENCE_NAME> and #s are substitutions for actual values

INFO OGG-06513 Resolving target sequence :<OWNER>.<SEQUENCE_NAME>.

WARNING OGG-25092 Sequence update did not succeed, error:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'GG_ADMIN.REPLICATESEQUENCE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored.

and the replicat discard file shows:

Operation failed at seqno # rba ######
Discarding record on action DISCARD on error 6550
Problem replicating <OWNER>.<SEQUENCE_NAME> to <OWNER>.<SEQUENCE_NAME>.
Mapping problem with compressed update record (target format) SCN:##.##.####...
*
No columns were available

Changes

 OGG was configured for replication of sequences.

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.