My Oracle Support Banner

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 later
Information 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


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