ORA-39126, ORA-06502 And LPX-00216 Errors In impdp Full

Last day I get the next error when I was importing a database (from 10.2.0.3 to 12.1.0.2);

Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [PROCACT_SYSTEM]
ORA-06502: PL/SQL: numeric or value error
LPX-00216: invalid character 0 (0x0)

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
3e032fef0     27116  package body SYS.KUPW$WORKER
3e032fef0     11286  package body SYS.KUPW$WORKER
3e032fef0     21860  package body SYS.KUPW$WORKER
3e032fef0      4516  package body SYS.KUPW$WORKER
3e032fef0     12063  package body SYS.KUPW$WORKER
3e032fef0      2081  package body SYS.KUPW$WORKER
3dba97a40         2  anonymous block

Search in Google I find the problem is the resource manager objects and the solution exclude them in expdp time. I hadn’t time to perform other expdp, in my case works fine exclude them in impdp time.

HTH – Antonio NAVARRO

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s