ORA-03106 and ORA-39126 Errors During Import in 12c

Hi,

A datapump import process was terminated with below errors in 12c database. Packages were created without bodies. And also some scheduler jobs were missed.

ORA-03106: fatal two-task communication protocol error
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [PACKAGE_BODY:”SCHEMA”.”PROCEDURE_NAME”]
ORA-06502: PL/SQL: numeric or value error
ORA-03106: fatal two-task communication protocol error
ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95
ORA-06512: at “SYS.KUPW$WORKER”, line 11259
—– PL/SQL Call Stack —–
object line object
handle number name
3000000879db19c0 27116 package body SYS.KUPW$WORKER
3000000879db19c0 11286 package body SYS.KUPW$WORKER
3000000879db19c0 21860 package body SYS.KUPW$WORKER
3000000879db19c0 4516 package body SYS.KUPW$WORKER
3000000879db19c0 12063 package body SYS.KUPW$WORKER

This alert is for unpublished BUG 28307854 – ORA-3106 IMPORTING PACKAGE BODY WITH IMPDP AFTER APPLYING 12.1.0.2.180417DBBP, which causes imports of a package body into a database with the 12.1.0.2.180417DBBP applied, to fail with “ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS” error.

This issue has potential to affect all DataPump imports of package bodies into a database having one of the following installation level:
– 12.1.0.2.180417 (Apr 2018) Database Proactive Bundle Patch
– 12.1.0.2.180717 (Jul 2018) Database Proactive Bundle Patch

As workaround you can create objects on target database manually. Or you can apply Patch number 28307854. After apply this patch, import will run successfully.