My Oracle Support Banner

Impdp of PROCOBJ Objects Fails Due To 'Insufficient Privileges' After Applying 19.9 DBRU (Doc ID 2738314.1)

Last updated on DECEMBER 22, 2020

Applies to:

Oracle Database - Standard Edition - Version 19.9.0.0.0 and later
Information 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


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