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)
