Question

oracle expdp导出的时候进程DM00掉不起来

ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user DBIODEV
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 1193
ORA-39062: error creating master process DM00
ORA-31613: Master process DM00 failed during startup.

新手上路，请详细解释下，以及要怎么解决

Answer 1

你没有ORACLE账户吧，你公司要是买了付费ORACLE会给账号的，你去要一个，
我把里面关于这个的文章粘给你，不给你翻译了挺长的。
你看看Symptoms应该是你这个问题，在你的11.2.0.1.0是可以发生的。
后面有Solution

Symptoms

All of a sudden, your data pump export jobs all fail with the following bunch of errors:
Export: Release 11.2.0.3.0 - Production on Sunday, Apr 28, 22:00:26 2013

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-31626: Job does not exist
ORA-31638: cannot attach to job Your_JOBNAME for user SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 428
ORA-39077: unable to subscribe agent KUPC$A_4_220050709685000 to queue "KUPC$C_4_20130428220032"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 250
ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Solution

Initially, Oracle Development built a fix under Patch 16473783.
We found out that the fix was incomplete and needed to be re-written.
This is under progress and monitored via unpublished Bug 16928674.

After encountering this symptom, this is not resolved unless recreating of datapump like followings.

@$ORACLE_HOME/rdbms/admin/catdph.sql
@$ORACLE_HOME/rdbms/admin/prvtdtde.plb
@$ORACLE_HOME/rdbms/admin/catdpb.sql
@$ORACLE_HOME/rdbms/admin/dbmspump.sql
@$ORACLE_HOME/rdbms/admin/utlrp.sql
Generally speaking, we can recreate the datapump objects in 11g by calling;
1. Catproc.sql
SQL> @$ORACLE_HOME/rdbms/admin/catproc.sql

2. To recompile invalid objects, if any
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql

This is described in Note 430221.1 How To Reload Datapump Utility EXPDP/IMPDP

追问

翻译了一下，完全不知道怎么解决