If you want a trigger to be enabled on golden gate target then you need to explicitly define it in replicat file. By default trigger firing is disabled
add belwo line in replicat file. schema – INFRA, trigger – AUDIT_TRIG
SQLEXEC "begin dbms_ddl.set_trigger_firing_property('INFRA','AUDIT_TRIG',FALSE); end;"after chnage file will look like this
Replicat R1
SETENV(ORACLE_HOME="/u01/oracle/product/12.1/db_1")
SETENV(ORACLE_SID = "TROY_1")
AssumeTargetDefs
DiscardFile ./dirrpt/rpdw.dsc, append, megabytes 4096
SOURCECHARSET PASSTHRU
UserID ggadmin@TROY, Password ggadmin
DDL INCLUDE ALL
DDLERROR DEFAULT IGNORE
map INFRA.*, target INFRA.*;
SQLEXEC "begin dbms_ddl.set_trigger_firing_property('INFRA','AUDIT_TRIG',FALSE); end;"to disable set TRUE
DBATracker 