OGG-00446 Checkpoint Table GGS_CHECKPOINT Does Not Exist after Adding SYSDBA to Replicat User's Connection Info (Doc ID 1561137.1)

Last updated on JULY 21, 2017

Applies to:

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

Goal

Experiencing the problem described in "GoldenGate Replicat Abend with OGG-00519 ORA-01031 Insufficient Privileges Trying to Execute Alter Synonym [ID 1403026.1]", however, if we add the SYSDBA to the connection info for the replicat, the following error are generated:

ERROR OGG-00446 Oracle GoldenGate Delivery for Oracle, rjprodp.prm: Checkpoint table GGS_CHECKPOINT does not exist. Please create the table or recreate the REP1 group using the correct table.
 

Solution

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