Impdp of PROCOBJ Objects Fails Due To 'Insufficient Privileges' After Applying 19.9 DBRU
(Doc ID 2738314.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Standard Edition - Version 19.9.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
While performing a Data Pump import on a database having the following patch level:
SQL> select description from dba_registry_sqlpatch;
DESCRIPTION
--------------------------------------------------------------------------
Database Release Update : 19.9.0.0.201020 (31771877)
the following error is being encountered when loading object_path POST_SCHEMA/PROCOBJ or POST_INSTANCE/PROCDEPOBJ:
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ
ORA-31685: Object type PROCOBJ:<SCHEMA_NAME>.<SCHEDULER_JOB> failed due to insufficient privileges. Failing sql is:
BEGIN
DECLARE
ta sys.re$table_alias_list;
vt sys.re$variable_type_list;
BEGIN
ta := sys.re$table_alias_list();
vt := sys.re$variable_type_list();
vt.extend(3);
...
dbms_rule_imp_obj.import_evaluation_context('"<SCHEDULER_JOB>"', ta, vt, NULL,NULL, 0);
END; COMMIT; END;
...
Processing object type SCHEMA_EXPORT/TABLE/POST_INSTANCE/PROCDEPOBJ
ORA-31685: Object type PROCDEPOBJ:<SCHEMA_NAME>.<QUEUE_NAME> failed due to insufficient privileges. Failing sql is:
BEGIN
DECLARE
ta sys.re$table_alias_list;
vt sys.re$variable_type_list;
BEGIN
ta := sys.re$table_alias_list();
vt := sys.re$variable_type_list();
ta.extend(1);
...
dbms_rule_imp_obj.import_evaluation_context('"<QUEUE_NAME>"', ta, vt, NULL,NULL, 1);
END; COMMIT; END;
Reproducing the error with errorstack for ORA-1031 enabled, e.g:
SQL> alter system set events '1031 trace name errorstack level 10';
DW trace shows that that the error is reported for an alter session statement:
ALTER SESSION SET EVENTS '25475 TRACE NAME CONTEXT FOREVER, LEVEL 1'
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x62856f90 18 package body SYS.DBMS_RULE_IMP_OBJ.IMPORT_EVALUATION_CONTEXT
0x6be9d100 10 anonymous block
0x663cf868 27467 package body SYS.KUPW$WORKER.RECREATE_DDL
0x663cf868 26476 package body SYS.KUPW$WORKER.PUT_DDL
0x663cf868 25960 package body SYS.KUPW$WORKER.PUT_DDLS
0x663cf868 5281 package body SYS.KUPW$WORKER.LOAD_METADATA
0x663cf868 13791 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0x663cf868 2439 package body SYS.KUPW$WORKER.MAIN
with a call stack that might look like:
... kgeselv ksesecl0 kkyase kksExecuteCommand psdnal pevm_EXIM pfrinstr_EXIM ...
Changes
The issue is started to be seen after applying 19.9DBRU.
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 |