Replicat failed with 'ORA-04021: timeout occurred while waiting to lock object' error. (Doc ID 2480373.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

GG Replicat is abended after truncating partitions in Source/Primary database. Please check the below error.

2018-12-02 10:55:04 ERROR OGG-00516 Oracle GoldenGate Delivery for Oracle, <rep_name>.prm: Fatal error executing DDL rep
lication: error [Error code [4021], ORA-04021: timeout occurred while waiting to lock object SQL ALTER TABLE <table_name>" truncate partition <patition_name> update global indexes parallel 20 /* GOLDENGATE_DDL_REPLICATION */], due to explicit
 ABEND error handling and filter [include all (default)].

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.