Data Pump Import Reports ORA-39083 and ORA-04021/ORA-04020 During Procedure Creation
(Doc ID 2723856.1)
Last updated on NOVEMBER 04, 2020
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 18 to 19]
Information in this document applies to any platform.
Running an impdp job in 18c or higher, following errors are encountered when loading SCHEMA_EXPORT/PROCEDURE/PROCEDURE:
- The errors ORA-402X are intermittent. The diagnostics show that the following grant statement is executed:
GRANT EXECUTE ON DBMS_AQADM TO "SYSTEM" WITH GRANT OPTION
but this is failing with the 4021 timeout error as impdp is trying to pin the librarycache handle in exclusive mode but another session has the package pinned in share mode.
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