Archive

Archive for February, 2013

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS] ORA-06502: PL/SQL: numeric or value error LPX-00225: end-element tag “COL_STATS_ITEM” does not match start-element tag “COL_STATS”

February 6, 2013 Leave a comment

When I imported db dump by impdp,  just go to the end of importing process, it showed errors below

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS]
ORA-06502: PL/SQL: numeric or value error
LPX-00225: end-element tag “COL_STATS_ITEM” does not match start-element tag “COL_STATS”

ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95
ORA-06512: at “SYS.KUPW$WORKER”, line 7839

—– PL/SQL Call Stack —–
object      line  object
handle    number  name
3acdf1c68     18237  package body SYS.KUPW$WORKER
3acdf1c68      7866  package body SYS.KUPW$WORKER
3acdf1c68     15147  package body SYS.KUPW$WORKER
3acdf1c68      3792  package body SYS.KUPW$WORKER
3acdf1c68      8532  package body SYS.KUPW$WORKER
3acd5b510         1  anonymous block
3ae12d930      1575  package body SYS.DBMS_SQL
3acdf1c68      8342  package body SYS.KUPW$WORKER
3acdf1c68      1545  package body SYS.KUPW$WORKER
3acdf3ca0         2  anonymous block

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS]
ORA-06502: PL/SQL: numeric or value error
LPX-00225: end-element tag “COL_STATS_ITEM” does not match start-element tag “COL_STATS”

ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95
ORA-06512: at “SYS.KUPW$WORKER”, line 7839

—– PL/SQL Call Stack —–
object      line  object
handle    number  name
3acdf1c68     18237  package body SYS.KUPW$WORKER
3acdf1c68      7866  package body SYS.KUPW$WORKER
3acdf1c68     15147  package body SYS.KUPW$WORKER
3acdf1c68      3792  package body SYS.KUPW$WORKER
3acdf1c68      8532  package body SYS.KUPW$WORKER
3b2278490         1  anonymous block
3ae12d930      1575  package body SYS.DBMS_SQL
3acdf1c68      8342  package body SYS.KUPW$WORKER
3acdf1c68      1545  package body SYS.KUPW$WORKER
3acdf3ca0         2  anonymous block

Job “SYS”.”SYS_IMPORT_FULL_02″ stopped due to fatal error at 19:48:10

Solution

To workaround this issue, repeat e impdp using the parameter EXCLUDE=STATISTICS as below

1. $ impdp \’/ as sysdba\’ parfile=imp_05Feb2013.par exclude=statistics

2. SQL> exec dbms_stats.gather_database_stats(estimate_percent=>DBMS_STATS.AUTO_SAMPLE_SIZE);

Categories: ORA-XXX

alter system set resumable_timeout=3600 scope=both;

February 6, 2013 Leave a comment

 

SQL> alter system set resumable_timeout=3600 scope=both;
alter system set resumable_timeout=3600 scope=both
*
ERROR at line 1:
ORA-32008: error while processing parameter update at instance dbdev2
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-01031: insufficient privileges

Oracle reported that it looks like the bug 9149546
Abstract: ORA-1031:INSUFFICIENT PRIVILEGES - WHEN SETTING RESUMABLE_TIMEOUT
 
WORKAROUND Procedures
-----------
alter system set ... sid='<SID>' on each node separately not acceptable
Categories: ORA-XXX