My Oracle Support Banner

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

Last updated on JULY 20, 2024

Applies to:

Oracle GoldenGate - Version 11.2.1.0.33 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Cause
Solution
References


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