ORA-31672 in oracle 11g
10345 pts.
0
Q:
ORA-31672 in oracle 11g
Getting Oracle Database Error Code ORA-31672
Worker process string died unexpectedly.

Any quick fixes

Software/Hardware used:
Oracle 11g
ASKED: Oct 8 2009  2:38 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
0
29805 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
The full error (according to the doc) reads:
ORA-31672: Worker process string died unexpectedly.
Cause: A Data Pump process model worker process died unexpectedly, so PMON
is cleaning up the process.
Action: Check your system for problems. Check the trace file for the process, if
one was created, for any additional information. Correct the error, if possible, and
try the operation again. If the error occurs again, contact Oracle Customer Support
and report the error.



The way this reads, there is no quick fix. Follow the suggestions above and then open a TAR with Oracle non-support.

note - "string" should be the name of the process in the full message that Oracle gave you, so use that name when searching the trace files.

Steve

--------------------

Please provide as much information as possible when asking for help.

If you were performing an import with Data Pump which involved materialized views, then, according to Metalink doc 750702.1, the problem could be due to bug 5881123.

If that's the case, you need to check for the availability of Patch 5881123 for your platform and version, or contact Oracle support.
Last Answered: Oct 8 2009  10:52 PM GMT by Carlosdl   29805 pts.
Latest Contributors: Meandyou   1840 pts.
0
0
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0