标签：00 -- leo 02443 19c 00519 OGG ogg simdb
问题描述：ogg目标库应用进程异常，告警OGG-00519、ORA-02443，如下所示：
场景说明：源端表中存在一个约束，约束名为系统自定义，该约束在目标端未能查找，所以便在源库将其删除，结果就出现目标端应用进程异常.
源端ogg软件：fbo_ggs_Linux_x64_ora10g_64bit.tar
目标端ogg软件：191004_fbo_ggs_Linux_x64_shiphome.zip
异常重现：
2022-12-12 18:12:25 ERROR OGG-00519 Fatal error executing DDL replication: error [Error code [2443], ORA-02443: Cannot drop constraint - nonexistent constraint
], no error handler present.
GGSCI (leo-19c-ogg as ogg@simdb) 10> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED REP1 00:00:00 00:03:34
解决过程：
--修改应用进程参数
GGSCI (leo-19c-ogg as ogg@simdb) 11> edit param rep1
--原参数
DDLERROR 942 IGNORE
--修改为
DDLERROR DEFAULT IGNORE RETRYOP
--全部参数如下：
GGSCI (leo-19c-ogg as ogg@simdb) 9> view param rep1
REPLICAT rep1
setenv (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
--setenv (ORACLE_SID=)
userid ogg@SIMDB,password ogg
REPORT AT 08:59
REPORTCOUNT EVERY 30 MINUTES, RATE
CACHEMGR CACHESIZE 2048MB,CACHEDIRECTORY /u01/app/ogg/dirtmp
REPERROR DEFAULT, ABEND
DISCARDFILE /u01/app/ogg/dirrpt/rep1.dsc, APPEND, MEGABYTES 1024
DISCARDROLLOVER AT 3:00
GETTRUNCATES
ALLOWNOOPUPDATES
APPLYNOOPUPDATES
ASSUMETARGETDEFS
DBOPTIONS DEFERREFCONST
DBOPTIONS SUPPRESSTRIGGERS
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
DDLERROR 942 IGNORE
MAP SCOTT.* TARGET SCOTT.*;
GGSCI (leo-19c-ogg as ogg@simdb) 12> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED REP1 00:00:00 00:04:10
GGSCI (leo-19c-ogg as ogg@simdb) 13> start rep1
Sending START request to MANAGER ...
REPLICAT REP1 starting
GGSCI (leo-19c-ogg as ogg@simdb) 14> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REP1 00:06:09 00:00:00
参考文档：https://blog.csdn.net/u010098331/article/details/51473298
标签：00,
--,
leo,
02443,
19c,
00519,
OGG,
ogg,
simdb
From： https://blog.51cto.com/u_12991611/5938385