OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » ora-39183 (oracle 11.2.0.2.0,AIX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-39183 [message #532810]

Thu, 24 November 2011 21:19

david_zhao
Messages: 2
Registered: November 2011
Location: Qingdao,China

Junior Member

Hi,ALL
when i using impdp command to dump data,The command is "impdp system/password schemas=user1 remap_schema=user1:user2 directory=testdir dumpfile=dump11.dmp".
occur error as below:
Processing object type SCHEMA_EXPORT/USER
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_METADATA [SELECT process_order, flags, xml_clob, NVL(dump_fileid, :1), NVL
(dump_position, :2), dump_length, dump_allocation, NVL(value_n, 0), grantor, object_row, object_schema, object_long_name, partition_name,
subpartition_name, processing_status, processing_state, base_object_type, base_object_schema, base_object_name, base_process_order, property,
size_estimate, in_progress, original_object_schema, original_object_name, creation_level, object_int_oid FROM "SYSTEM"."SYS_IMPORT_SCHEMA_07" WHERE
process_order between :3 AND :4 AND duplicate = 0 AND processing_state NOT IN (:5, :6, :7) ORDER BY process_order]
ORA-39183: internal error -19 ocurred during decompression phase 2
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 8358
----- PL/SQL Call Stack -----
object line object
handle number name
70000007d842970 19208 package body SYS.KUPW$WORKER
70000007d842970 8385 package body SYS.KUPW$WORKER
70000007d842970 4294 package body SYS.KUPW$WORKER
70000007d842970 9082 package body SYS.KUPW$WORKER
70000007d842970 1688 package body SYS.KUPW$WORKER
70000003640b770 2 anonymous block
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.LOAD_METADATA [SELECT process_order, flags, xml_clob, NVL(dump_fileid, :1), NVL
(dump_position, :2), dump_length, dump_allocation, NVL(value_n, 0), grantor, object_row, object_schema, object_long_name, partition_name,
subpartition_name, processing_status, processing_state, base_object_type, base_object_schema, base_object_name, base_process_order, property,
size_estimate, in_progress, original_object_schema, original_object_name, creation_level, object_int_oid FROM "SYSTEM"."SYS_IMPORT_SCHEMA_07" WHERE
process_order between :3 AND :4 AND duplicate = 0 AND processing_state NOT IN (:5, :6, :7) ORDER BY process_order]
ORA-39183: internal error -19 ocurred during decompression phase 2
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 8358
----- PL/SQL Call Stack -----
object line object
handle number name
70000007d842970 19208 package body SYS.KUPW$WORKER
70000007d842970 8385 package body SYS.KUPW$WORKER
70000007d842970 4294 package body SYS.KUPW$WORKER
70000007d842970 9082 package body SYS.KUPW$WORKER
70000007d842970 1688 package body SYS.KUPW$WORKER
70000003640b770 2 anonymous block
Job "SYSTEM"."SYS_IMPORT_SCHEMA_07" stopped due to fatal error at 21:50:30.

ask for help.

best regard

Report message to a moderator

Re: ora-39183 [message #532812 is a reply to message #532810]

Thu, 24 November 2011 21:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

bcm@bcm-laptop:~$ oerr ora 39183
39183, 00000, "internal error %s ocurred during decompression phase %s\n"
// *Cause:  An unexpected error occurred while decompressing data buffers.
// *Action: Contact Oracle Customer Support.
bcm@bcm-laptop:~$ oerr ora 39126
39126, 00000, "Worker unexpected fatal error in %s [%s] \n%s"
// *Cause:  An unhandled exception was detected internally within the worker
//          process for the Data Pump job.  This is an internal error.
//          Additional information may be supplied.
// *Action: If problem persists, contact Oracle Customer Support.

Report message to a moderator

Previous Topic:	How to Access local file residing at client from DB Server
Next Topic:	Oracle 9i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 17:47:45 CST 2025