Successful Datapump Export Shows in Alert.log: DW00 Terminating W/fatal Err=39081, Pid=341, Wid=1, Job on SYS_EXPORT_TABLE_01 (Doc ID 2101076.1)

Last updated on MARCH 15, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Alert_log shows "DW00 terminating with fatal err=39081" after successful export like below:

Thu Dec 03 14:47:46 2015
DM00 started with pid=298, OS id=8743, job SYS_EXPORT_TABLE_01
Thu Dec 03 14:47:47 2015
DW00 started with pid=341, OS id=8747, wid=1, job SYS_EXPORT_TABLE_01
Thu Dec 03 14:48:08 2015
DW00 terminating with fatal err=39081, pid=341, wid=1, job SYS_EXPORT_TABLE_01


The actual DataPump export job was however completed successfully as shown below:

/home/oracle>expdp *****/**** tables=papps_dw.all_time

Export: Release 12.1.0.2.0 - Production on Thu Dec 3 14:47:46 2015

Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
Starting "******"."SYS_EXPORT_TABLE_01": ******/******** tables=papps_dw.all_time
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 3 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
. . exported "PAPPS_DW"."ALL_TIME" 2.454 MB 11322 rows
Master table "*******"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for ******.SYS_EXPORT_TABLE_01 is:
 /u01/app/oracle/product/12.1.0.2/dbhome_1/rdbms/log/expdat.dmp
Job "*******"."SYS_EXPORT_TABLE_01" successfully completed at Thu Dec 3 14:48:08 2015 elapsed 0 00:00:21

 

Changes

Moved to 12.1.0.2 and applied the patch for
<Bug 20641213> - ORA-00600 [KWQITNMPHE:LTBAGI], [1], [0] EVEN AFTER APPLYING PATCH 19730508

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