expdp报错

new_db

Export: Release 10.2.0.4.0 - 64bit Production on Saturday, 27 September, 2014 21:00:01

Copyright (c) 2003, 2007, Oracle.  All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "NC501SP184"."SYS_EXPORT_SCHEMA_13":  nc501sp184/******** dumpfile=nc_14-09-27.dp logfile=nc_14-09-27.log directory=dpdir schemas=nc501sp184,iufo
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 330.8 GB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/POST_TABLE_ACTION
Processing object type SCHEMA_EXPORT/TABLE/MATERIALIZED_VIEW_LOG
Processing object type SCHEMA_EXPORT/JOB
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31671: Worker process DW01 had an unhandled exception.
ORA-00028: your session has been killed
ORA-00028: your session has been killed
ORA-06512: at "SYS.KUPF$FILE", line 5772
ORA-06512: at line 1
ORA-06512: at "SYS.KUPD$DATA_INT", line 14
ORA-06512: at "SYS.KUPD$DATA", line 1313
ORA-06512: at "SYS.KUPW$WORKER", line 10826
ORA-06512: at "SYS.KUPW$WORKER", line 2637
ORA-06512: at "SYS.KUPW$WORKER", line 6958
ORA-06512: at "SYS.KUPW$WORKER", line 1314
ORA-06512: at line 2
Job "NC501SP184"."SYS_EXPORT_SCHEMA_13" stopped due to fatal error at 22:02:29
ORA-39014: One or more workers have prematurely exited.
这个错误有时会出现，有时又不会，比如今天报错，明天又不会，后天又会报错，好像也没什么规律。
网上查了下资料，说是stream_pool过小，但是这么机器是自动内存管理的，内存大小90G，而且我也手工把流池大小设置为300M，也没有解决这个问题，大神有遇到过的么，求指教。谢谢！

xifenfei

ORA-31671: Worker process DW01 had an unhandled exception.
ORA-00028: your session has been killed
ORA-00028: your session has been killed

这里提示，你的session是不是被人kill掉了？

new_db

xifenfei 发表于 2014-11-5 23:24
ORA-31671: Worker process DW01 had an unhandled exception.
ORA-00028: your session has been killed
O ...

晚上9点执行的，应该只有这个expdp的任务在跑，如果会话被杀掉，该从那方面查找呢？

baoyintu

学习下