Sunday, March 1, 2015

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



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


0 comments:

Post a Comment

Auto Scroll Stop Scroll