I'm using Oracle 21c on a Windows 10 platform
For multiple releases, I've executed the following statement without any warning error. Now that I upgraded from Oracle 18 to 21c I receive the following error from IMPDP.
From within a Windows CMD file I execute the following statement:
IMPDP system/(my_password)@XEPDB1 Full=Y Table_Exists_Action=REPLACE directory=BACKUP_DIR dumpfile=%RestoreFile% logfile=%SSRestoreLogFile%
The CMD screen shows the following while it hangs for a few minutes:
Connected to: Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
Master table "SYSTEM"."SYS_IMPORT_FULL_02" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_FULL_02": system/********@localhost/XEPDB1 Full=Y Table_Exists_Action=REPLACE directory=BACKUP_DIR dumpfile=2022_02_20_14_16_47_SS.DMP logfile=2022_02_21_13_21_49_SSDB_restore.log
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ORACLE_OBJECT_GRANT/OBJECT_GRANT
After a few minutes of waiting the screen displays the following error:
Warning: Grant EXECUTE failed due to timeout while waiting to lock oracle object.
Failing sql is:
GRANT EXECUTE ON "SYS"."DBMS_LOCK" TO "(my_schema)"
Warning: Grant EXECUTE failed due to timeout while waiting to lock oracle object.
Failing sql is:
GRANT EXECUTE ON "SYS"."UTL_FILE" TO "(my_schema)"
IMPDP then continues on and displays the following updates
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
It seems to proceed and terminate normally from there on.
Is there some sort of permission that I have to give SYSTEM?
In SQL developer, logged in as "SYS as SYSDBA", I executed the following statement:
GRANT EXECUTE ON SYS.DBMS_LOCK TO sys WITH GRANT OPTION;
Commit;
It responded with "Grant Succeeded" / "Commit complete"
After that, If I execute the following in SQL Developer:
GRANT EXECUTE ON "SYS"."UTL_FILE" TO "(My_Schema)";
Commit;
It grants and commits OK.
Why does IMPDP in Oracle 21C produce that warning error?
Thanks for looking at this.