How to Resolve OGG-00519 REPLICAT DDL Errors in GoldenGate


In the remote database, you may not create all objects to resolve dependency problems. Here are some OGG-00519 DDL errors in REPLICAT report below:

2017-08-22 19:52:03  ERROR   OGG-00519  Fatal error executing DDL replication: error [Error code [1435], ORA-01435: user does not exist SQL ALTER SESSION SET CURRENT_SCHEMA="PUBLIC"], no error handler present.

2017-08-23 20:18:54  ERROR   OGG-00519  Fatal error executing DDL replication: error [Error code [942], ORA-00942: table or view does not exist SQL ALTER PUBLIC SYNONYM "CUSTOMERS" COMPILE  /* GOLDENGATE_DDL_REPLICATION */], no error handler present.


Let’s see the new parameters in the REPLICAT that can ignore the above errors.

[oracle@remote dirprm]$ vi erpapp_r.prm
replicat erpapp_r
userid ogg, password ogg
discardfile ./dirrpte/erpapp_r.dsc, append, megabytes 10
dboptions suppresstriggers
reperror (0001, discard)
reperror (1403, discard)
ddlerror 1430 ignore
ddlerror 1432 ignore
ddlerror 1435 ignore
ddlerror 942 ignore
ddlerror 904 ignore
ddl include mapped
map erpapp.*, target erpapp.*;

Please note that, we use ddlerror 904 ignore to pass ORA-00942.

Leave a Reply

Your email address will not be published. Required fields are marked *