ORA-31613: Master process DM00 failed during startup

DB: 11.2.0.4 RAC database

OS: RHEL 6

While performing  schema export using datapump, expdp job is failing to start and throwing above error.

 [oracle@oracle002 /oracle]$ expdp parfile=exp_MY_schema.par

Export: Release 11.2.0.4.0 - Production on Tue Feb 24 18:31:59 2015

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

Username: / as sysdba

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,

OLAP, Data Mining and Real Application Testing options

ORA-31626: job does not exist

ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user SYS

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPV$FT", line 1587

ORA-39062: error creating master process DM00

ORA-31613: Master process DM00 failed during startup.

If we check the Alert log:

ORA-00020: maximum number of processes (400) exceeded

 ORA-20 errors will not be written to the alert log for

 the next minute. Please look at trace files to see all

 the ORA-20 errors.

According to oracle doc (Doc ID 1368180.1) the issue is with oracle process reached maximum limit and hence DM00 failed to start

[oracle@oracle002 /oracle]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Feb 24 18:38:23 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,

OLAP, Data Mining and Real Application Testing options

SQL> select resource_name, current_utilization/limit_value*100,current_utilization, max_utilization,limit_value from v$resource_limit where resource_name in ('processes','sessions');

Output for the above sql shows Max utilization and max limit for the process and session parameters

(or)

SQL> select name, value from v$spparameter where name in ('processes','sessions');

NAME

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

VALUE

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

processes

400

sessions

400

Check the current processes used:

SQL> select count(*) from v$process;

  COUNT(*)

----------

       393

Solution:

Increase the value of PROCESSES initialization parameter and restart the database. Please follow below link to resolve the issue

http://www.chandu208.blogspot.com/2014/11/ora-12516-tns-listener-could-not-find.html

Reference:

Data Pump Export Fails With ORA-39062 and ORA-31613: Master Process DM00 Failed During Startup (Doc ID 1368180.1)