My Oracle Support Banner

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.3.0.0.0 to 19.8.0.0.0 [Release 18 to 19]
Information in this document applies to any platform.

Symptoms

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.

 

Changes

 

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
Changes
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.