Data Pump Export Fails With ORA-39062 and ORA-31613: Master Process DM00 Failed During Startup
(Doc ID 1368180.1)
Last updated on JANUARY 06, 2023
Applies to:
Oracle Database - Standard Edition - Version 10.2.0.1 and laterOracle Database - Enterprise Edition - Version 10.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
The following symptoms have been attributed to this issue :
You are attempting to perform a Data Pump export (expdp), and you receive the following error messages:
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_FULL_04 for user SYSTEM
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.
In alert log is reported:
ORA-00020: maximum number of processes (150) 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.
Process q000 submission failed with error = 20
ORA-31637: cannot create job SYS_EXPORT_FULL_04 for user SYSTEM
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.
In alert log is reported:
ORA-00020: maximum number of processes (150) 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.
Process q000 submission failed with error = 20
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |