Thursday, March 8, 2018

ORA-31613: Master process DM00 failed during startup

While taking export backup using data pump user received following error.

ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user
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.

Normally user receives this error when maximum numbers of processes are exceeded. You will see below error in trace files.

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

Solution: To fix the issue increase PROCESSES initialization parameter and restart the database.

If you don’t see the error ORA-00020 trace file then look for other error messages which will help to fix the issue. 

I had faced similar issue and  but don't see ORA-00020 error. After looking the other error messages I see that child processes are terminated and in my case restarting the database resolved the issue.

Regards,
Satishbabu Gunukula, Oracle ACE

7 comments:

  1. Really interesting blog in my opipnion


    stephanie

    ReplyDelete
  2. Your blog is great. i read a lot of interesting things from it. thank you very much for sharing. hope you will update more news in the future. microsoft office 2013 product key

    ReplyDelete
  3. Use our tool to find out just how affordable our mortgages can be for you.Check out our Ulster Bank Mortgage Calculator in UK and get it the great mortgage tips.

    FOR MORE VISIT :- Ulster Bank Mortgage Calculator

    ReplyDelete
  4. So how do you give them that compelling reason? By treating this question as an opportunity for your sales pitch. By thinking about what it is that the interviewer wants in a candidate and what it is that they need to hear.

    if you want more just look here "jobadded.com"

    ReplyDelete
  5. TN SSLC Syllabus 2023 The TN Board of Secondary Education (TNBSE) conduct the SSCL examination in the month of March 2023 successfully, it is expected that the more than 9 lakh students appeared for the TNBSE 10th Syllabus 2023, Tamil Nadu 10th Syllabus 2023 those candidate who had participated in the 10th Syllabus and looking to know the TN 10th Syllabus 2023, it informed to all the applicant the Syllabus available at online mode at official website of TN.

    ReplyDelete