Replicat failed with 'ORA-04021: timeout occurred while waiting to lock object' error.
(Doc ID 2480373.1)
Last updated on NOVEMBER 25, 2019
Applies to:Oracle GoldenGate - Version 22.214.171.124.33 and later
Information in this document applies to any platform.
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 , 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)].
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