Replicat processes hangs and you see time since last checkpoint just increase (Doc ID 1426286.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate - Version 11.1.1.0.0 to 11.1.1.1.0 [Release 11.1.1 to 11.1.1.1]
Information in this document applies to any platform.
Add ***Checked for relevance on 20-Aug-2013***

Symptoms

The Replicat process will hang and you will see the time since last checkpoint increasing.
When you have DDLOPTIONS Report enabled, you will see that the last details in the report file were something like this where a CREATE or REPLACE TRIGGER statement had been done.

the last messages in your replicat were

2012-01-27 19:37:23 INFO OGG-00482 DDL found, operation [CREATE OR REPLACE TRIGGER MAC.CORPORATE#UPD BEFORE
UPDATE ON "MAC"."CORPORATE"
REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW
BEGIN
IF IsReplicationDML = 'TRUE' THEN return; END IF;
:new.AUD_UPDATE_TS := systimestamp;
END;
/*  This is comment code
END;   (size 1999)].

2012-01-27 19:37:23 INFO OGG-00490 DDL operation is of unmapped scope.

2012-01-27 19:37:23 INFO OGG-00488 DDL operation excluded [EXCLUDE ALL], optype [CREATE], objtype [TRIGGER], objowner [MAC], objname [CORPORATE].

The replicat is in a Running status,  with the time since last checkpoint increasing but the RBA is not changing.

The replicat process is not using CPU

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms