Sys Trigger causing Error In Replicating Sequence (Doc ID 1536504.1)

Last updated on MAY 16, 2017

Applies to:

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

Symptoms

On : 11.2.1.0.1 version, REPLICAT executable

When attempting to run Replicat,
the following error occurs.

ERROR
-----------------------

2013-02-16 00:18:54 ERROR OGG-01444 Error in replicating sequence value [ORA-20783:
ORA-30511: invalid DDL operation in system triggers
ORA-06512: at line 999
ORA-30511: invalid DDL operation in system triggers
ORA-06512: at "GG_ADMIN.REPLICATESEQUENCE", line 368
ORA-06512: at line 1 SQL BEGIN gg_admin .replicateSequence (TO_NUMBER(102534149), TO_NUMBER(20), TO_NUMBER(1), 'IQPROD', TO_NUMBER(2
0), 'LINK_SEQ', UPPER('gg_admin'), TO_NUMBER(2), TO_NUMBER (0), ''); END;].

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