Full Database Import Fails When Creating Resource Manager Objects (Doc ID 733259.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.3 [Release 10.1 to 10.2]
Information in this document applies to any platform.
***Checked for relevance on 02-Nov-2016***

Symptoms

During full database import using DataPump the following errors caused import to terminate:

ORA-39083: Object type PROCOBJ failed to create with error:
ORA-29357: object AUTO_TASK_CONSUMER_GROUP already exists
Failing sql is:
BEGIN
dbms_resource_manager.create_consumer_group('AUTO_TASK_CONSUMER_GROUP','System
maintenance task consumer group','ROUND-ROBIN');COMMIT; END;

- OR -

ORA-39083: Object type PROCACT_SYSTEM failed to create with error:
ORA-29358: resource plan ARU_RESOURCE_PLAN does not exist
Failing sql is:
BEGIN
dbms_resource_manager.create_plan_directive('ARU_RESOURCE_PLAN','ARU_BATCH','
',0,35,90,0,0,0,0,0,NULL,NULL,NULL,'',NULL,TRUE,NULL,NULL,NULL,NULL,NULL);

- OR -

ORA-39083: Object type PROCACT_SYSTEM failed to create with error:
ORA-29358: resource plan <some-resource-plan-name> does not exist

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