My Oracle Support Banner

11.2.0.4 EXPDMP to 12.1.0.1 IMPDMP GENERATES MULTIPLE ERRORS: ORA-39083: Object type PROCACT_SYSTEM failed to create with error: (Doc ID 1631812.1)

Last updated on JULY 16, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
IBM: Linux on System z

Goal

 Having exported with data pump an 11204 RAC database created from the GP template and sample schemas  a lot of errors are seen during the import with data pump into a 12.1 PDB. 

Both the 11204 and 12101  share the same ASM. The source is +DATA, but the CDB/PDB are created in +DATA12c. Since it is ASM  the dump files are also directed to ASM.

SQL> CREATE or REPLACE DIRECTORY dpump_dir as '+DATA/';
Directory created.

SQL> CREATE or REPLACE DIRECTORY dpump_log as '/oracle2/nfs_share/';
Directory created.

 expdp system/Oracle1 full=y directory=dpump_dir dumpfile=upgrade2%U.dmp filesize=3GB logfile=dpump_log:upgrade2.log version=12.0
Job "SYSTEM"."SYS_EXPORT_FULL_01" successfully completed at Tue Dec 10 10:41:40 2013 elapsed 0 00:09:59

This is on the 11204 instance but CRS/ASM has been upgraded to 12c. The cluster consists of  two nodes.

Here's the import into the PDB.

SQL> CREATE or REPLACE DIRECTORY dpump_dir as '+DATA/';
Directory created.

SQL> CREATE or REPLACE DIRECTORY dpump_log as '/oracle2/nfs_share/';
Directory created.

$ impdp pdbadmin/Oracle1@scancrs-r/racpdb full=y directory=dpump_dir dumpfile=upgrade%U.dmp logfile=dpump_log:import.log version=12.0

Errors include the following:


Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
ORA-39083: Object type PROCACT_SYSTEM failed to create with error:
ORA-65040: operation not allowed from within a pluggable database
ORA-13900: missing or invalid parameter metric_id
Failing sql is:
BEGIN
dbms_server_alert.set_threshold(2018,dbms_server_alert.operator_GE,'100',NULL,NULL,1,2,'rac1',dbms_server_alert.object_type_SYSTEM,'');COMMIT; END;
 

Solution

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
Goal
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.