遇到oracle错误4043,OGG Troubleshooting-replc.prm: Fatal error executing DDL replication: error [Error c...

Q4:

2011-10-14 17:04:15 ERROR OGG-00516 Oracle GoldenGate Delivery for Oracle,

replc.prm: Fatal error executing DDL replication:

error [Error code [4043], ORA-04043: object PKG_PUB_SUPPLIERRELA

does not exist, SQL ALTER PACKAGE CORPUB.PKG_PUB_SUPPLIERRELA

COMPILE DEBUG BODY ], due to

explicit ABEND error handling and filter [include all

(default)].

2011-10-14 17:04:15 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle,

replc.prm: PROCESS ABENDING.

A4：

GGSCI (localhost.localdomain) 2> view params

replc

replicat replc

setenv (ORACLE_SID="airtrip")

setenv ( NLS_LANG = AMERICAN_AMERICA.UTF8 )

userid ggs, password ggsipshk

sqlexec "Alter session set constraints=deferred"

REPORT AT 01:59

reportrollover at 02:00

--handlecollisions

DBOPTIONS SUPPRESSTRIGGERS

DBOPTIONS DEFERREFCONST

--ddl include mapped

--ddloptoins report

ddl include all

ddlerror 1031 ignore

ddlerror 4043 ignore

ddlerror 24344 ignore

DDLERROR DEFAULT abend

DDLSUBST 'enable' WITH 'disable' INCLUDE OBJTYPE 'trigger',

OPTYPE alter

DDLSUBST 'enable' WITH 'disable' INCLUDE INSTR 'ZGLT_CASCADE',

OPTYPE alter, OBJTYPE 'CONSTRAINT'

reperror default,abend

discardfile ./dirrpt/replc.dsc,append, megabytes 10

assumetargetdefs

checksequencevalue

allownoopupdates

dynamicresolution

numfiles 3000

map DBLINK.*, target DBLINK.*;

map SYSBASE.*, target SYSBASE.*;

map CORRISK.*, target CORRISK.*;

map APPOPER.*, target APPOPER.*;

map APPBANK.*, target APPBANK.*;

map CORIO.*, target CORIO.*;

map CORPUB.*, target CORPUB.*;

GGSCI (localhost.localdomain) 3>