DDLGoldenGate

How to Resolve OGG-00519 REPLICAT DDL Errors in GoldenGate

OGG-00519

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.

Solutions

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
assumetargetdefs
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
allownoopupdates
ddl include mapped
map erpapp.*, target erpapp.*;

Leave a Reply

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