I faced with that issue to make import process on our system.

My source db version is 11.2.0.4 and target db version is 12.1.0.2 RAC

During import process (used impdp) its ended by below error messages

In procedure BUILD_OBJECT_STRINGS

DBMS_METADATA.CONVERT

In procedure DETERMINE_FATAL_ERROR with ORA-06502: PL/SQL: numeric or value error

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$WOR

After making some search on metalink I found MOS
Alert – DataPump Victim: LOB Regression Introduced in 12.1.0.2.180417DBBP Generates ORA-03106 When Importing (IMPDP) Package Bodies (Doc ID 2424272.1)

We have 2 options here.

  1. We can create objects on target manually
  2. We can apply Patch 28307854 is available for download to address the problem

 

 

Reklam