Prev: Patching terminology
Next: One question about ORION test
From: feyd on 28 Apr 2010 10:54
I`m trying to import IMPDP, dump from (linux oracle 10.02.00.01.00) to
oracle 11
and i get :

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS
[TRIGGER:"SKASUJMNIE"."ADD_BS_CM"] ]
ORA-06502: PL/SQL: numeric or value error
LPX-00225: end-element tag "COLS_ITEM" does not match start-element
tag "BODY"

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 8164

PL/SQL Call Stack
object line object
handle number name
0x112977a48 19028 package body SYS.KUPW$WORKER
0x112977a48 8191 package body SYS.KUPW$WORKER
0x112977a48 15631 package body SYS.KUPW$WORKER
0x112977a48 3944 package body SYS.KUPW$WORKER
0x112977a48 8874 package body SYS.KUPW$WORKER
0x112977a48 1651 package body SYS.KUPW$WORKER
0x11f7bee10 2 anonymous block

it happens only where i import triggers ( include=triggers )

file copy was made by scp (so i guess it binary mode ) , i think it
occurs in metalink and it problem requires install patch.

Is that any other way to read this trigger pl sql code from dmp file,
using pl sql package or program such as awk or sed ?
From: Mark D Powell on 28 Apr 2010 12:26
On Apr 28, 10:54 am, feyd <admin....(a)gmail.com> wrote:
> I`m trying to import IMPDP, dump from (linux oracle 10.02.00.01.00) to
> oracle 11
> and i get :
>
> ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS
> [TRIGGER:"SKASUJMNIE"."ADD_BS_CM"] ]
> ORA-06502: PL/SQL: numeric or value error
> LPX-00225: end-element tag "COLS_ITEM" does not match start-element
> tag "BODY"
>
> ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
> ORA-06512: at "SYS.KUPW$WORKER", line 8164
>
> PL/SQL Call Stack
> object line object
> handle number name
> 0x112977a48 19028 package body SYS.KUPW$WORKER
> 0x112977a48 8191 package body SYS.KUPW$WORKER
> 0x112977a48 15631 package body SYS.KUPW$WORKER
> 0x112977a48 3944 package body SYS.KUPW$WORKER
> 0x112977a48 8874 package body SYS.KUPW$WORKER
> 0x112977a48 1651 package body SYS.KUPW$WORKER
> 0x11f7bee10 2 anonymous block
>
> it happens only where i import triggers ( include=triggers )
>
> file copy was made by scp (so i guess it binary mode ) , i think it
> occurs in metalink and it problem requires install patch.
>
> Is that any other way to read this trigger pl sql code from dmp file,
> using pl sql package or program such as awk or sed ?


What version of the expdp utility was used to make the export?
And what version of the impdp utility are you trying to use to import
the export?

Export/Import DataPump Parameter VERSION - Compatibility of Data Pump
Between Different Oracle Versions #553337.1

DataPump Import Including Statistics Terminates With Fatal Error
ORA-39126, ORA-6502, LPX-225 End-Element Tag "HIST_GRAM_LIST_ITEM"
#878626.1

There are numerous other problem reports that you may want to check
out on Oracle support.

HTH -- Mark D Powell --

From: feyd on 29 Apr 2010 07:45

> What version of the expdp utility was used to make the export?
> And what version of the impdp utility are you trying to use to import
> the export?

export was made in
10.2.0.1.0

import version
11.2.0.1.0

I just wanna to ask is there any way to read dmp files parser using
for examle KUPW$WORKER or any other oracle tools.

From: Mark D Powell on 29 Apr 2010 09:32
On Apr 29, 7:45 am, feyd <admin....(a)gmail.com> wrote:
> > What version of the expdp utility was used to make the export?
> > And what version of the impdp utility are you trying to use to import
> > the export?
>
> export was made in
> 10.2.0.1.0
>
> import version
> 11.2.0.1.0
>
> I just wanna to ask is there any way to read dmp files parser using
> for examle KUPW$WORKER or any other oracle tools.

Are both version EE or Standard? What platform?

The second article I listed matched your posted error list, was it
helpful?

No, I do not know of any program to parse the dmp file other than
impdp.

HTH -- Mark D Powell --

 | 
Pages: 1
Prev: Patching terminology
Next: One question about ORION test