ADZDDBCC after upgrade from 12.1.3 to 12.2.6 ORA-04021 ad.plsql.ad_zd_parallel_exec.execute
(Doc ID 2596860.1)
Last updated on OCTOBER 18, 2019
Applies to:
Oracle Applications DBA - Version 12.2.6 and laterInformation in this document applies to any platform.
Goal
While running the ADZDDBCC report after upgrading instance from 12.1.3 to 12.2.6. getting the below messages at the end of the Section-1.
These messages doesn't contain any object name's or issue details.
ad.plsql.ad_zd_parallel_exec.execute ERROR [CLEANUP 8:1 ddl_id=5221] ORA-04021: timeout occurred while waiting to lock object SQL: begin sys.ad_grants.cleanup; end;
ad.plsql.ad_zd_parallel_exec.execute ERROR [CLEANUP 1:1 ddl_id=5221] ORA-04021: timeout occurred while waiting to lock object SQL: begin sys.ad_grants.cleanup; end;
ad.plsql.ad_zd_parallel_exec.execute ERROR [CLEANUP 1:1 ddl_id=5221] ORA-04021: timeout occurred while waiting to lock object SQL: begin sys.ad_grants.cleanup; end;
ad.plsql.ad_zd_parallel_exec.execute ERROR [CLEANUP 1:1 ddl_id=5221] ORA-04021: timeout occurred while waiting to lock object SQL: begin sys.ad_grants.cleanup; end;
ad.bin.adop ERROR [CLEANUP 1:1 ddl_id=5221] ORA-04021: timeout occurred while waiting to lock object SQL: begin sys.ad_grants.cleanup; end;
Solution
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
Goal |
Solution |
References |