DataPump Import (IMPDP) Fails With Errors ORA-39083 ORA-27486 Of Object Type PROCOBJ

(Doc ID 881601.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 to 10.2.0.4 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 10-MAY-2013***

Symptoms

Doing full import to newly created database as user SYSTEM, you can get:

Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCOBJ
ORA-39083: Object type PROCOBJ failed to create with error:
ORA-27486: insufficient privileges
Failing sql is:
BEGIN
dbms_scheduler.create_job('"MGMT_CONFIG_JOB"',
job_type=>'STORED_PROCEDURE', job_action=>
'ORACLE_OCM.MGMT_CONFIG.collect_config'
, number_of_arguments=>0,
schedule_name=>'"SYS"."MAINTENANCE_WINDOW_GROUP"',
job_class=>'"DEFAULT_JOB_CLASS"', enabled=>FALSE, auto_drop=>FALSE,comments=>
'Configuration collection job.'
);
dbms_scheduler.enable('"MGMT_CONFIG_JOB"');COMMIT; END;

and/or:

ORA-39083: Object type PROCOBJ failed to create with error:
ORA-27486: insufficient privileges
Failing sql is:
BEGIN
dbms_scheduler.create_job('"MGMT_STATS_CONFIG_JOB"',
job_type=>'STORED_PROCEDURE', job_action=>
'ORACLE_OCM.MGMT_CONFIG.collect_stats'
, number_of_arguments=>0,
start_date=>'12-NOV-07 05.34.36.814000 PM +00:00', repeat_interval=>
'freq=monthly;interval=1;bymonthday=1;byhour=01;byminute=01;bysecond=01'
, end_date=>NULL,
job_class=>'"DEFAULT_JOB_CLASS"', enabled=>FALSE, auto_drop=>FALSE,com
Processing object type DATABASE_EXPORT/SCHEMA/POST_SCHEMA/PROCACT_SCHEMA
Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 1526 error(s) at 06:04:33

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms