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 APRIL 24, 2017

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

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