Data Pump Export/Import terminate due to ORA-31672. ORA-07445 [kuxgetHashCode] reported in alert log.

(Doc ID 951402.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.7 and later
Information in this document applies to any platform.
*** Checked for relevance on 23-May-2012 ***

This problem can occur on any platform.

Symptoms

ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31672: Worker proces DW01 died unexpectedly.

 

EXPDP LOGFILE
-------------
Export: Release 11.1.0.7.0 - Production on Monday, 05 October, 2009 15:39:04

Copyright (c) 2003, 2007, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_FULL_01": system/******** directory=data_pump_dir full=y dumpfile=expdp.dmp logfile=expdp.log
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/PROFILE
...
Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM
Processing object type DATABASE_EXPORT/SCHEMA/SYNONYM
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31672: Worker proces DW01 died unexpectedly.
Job "SYSTEM"."SYS_EXPORT_FULL_01" stopped due to fatal error at 15:39:45

 

TRACE FILE
----------
*** 2009-10-01 15:39:45.433
----- Current SQL Statement for this session (sql_id=aay0yr7xvfbnm) -----
SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2('TYPE_T', '7')), KU$.OBJ_NUM ,KU$.SCHEMA_OBJ.NAME ,KU$.SCHEMA_OBJ.NAME ,'TYPE' ,KU$.SCHEMA_OBJ.OWNER_NAME FROM SYS.KU$_TYPE_VIEW KU$,TABLE(DBMS_METADATA.FETCH_SORTED_OBJNUMS(200001)) KU1$ WHERE KU$.OBJ_NUM =KU1$.NUM1 ORDER BY KU1$.NUM2
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
A219BD44 76 package body SYS.UTL_XML
A47E53C8 2359 package body SYS.DBMS_METADATA_UTIL
A47E9F60 1598 package body SYS.DBMS_METADATA
A47E9F60 2008 package body SYS.DBMS_METADATA
A47E9F60 2314 package body SYS.DBMS_METADATA
A47E9F60 4676 package body SYS.DBMS_METADATA
A45D57D4 2421 package body SYS.KUPW$WORKER
A45D57D4 8504 package body SYS.KUPW$WORKER
A45C1C08 1 anonymous block
A45D4CF8 1575 package body SYS.DBMS_SQL
A45D57D4 8342 package body SYS.KUPW$WORKER
A45D57D4 1545 package body SYS.KUPW$WORKER
A45D877C 2 anonymous block

 

 

CALL STACK
----------
kuxgetHashCode spefcmpa spefmccallstd pextproc peftrusted psdexsp rpiswu2 ...


 

Changes

Oracle Bundle Patch was applied on Windows platform. Since then the issue occured.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms