While doing import got the below error :
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing ORA-31626: job does not exist ORA-31637: cannot create job SYS_IMPORT_SCHEMA_02 for user SYS ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPV$FT", line 1580 ORA-39062: error creating master process DM00 ORA-31613: Master process DM00 failed during startup.
When we checked the alert.log, we found that maximum process has been reached.
Solution:
Increase the processes and bounce the db.
SQL> alter system set processes=800 scope=spfile; System altered. SQL> startup force ORACLE instance started. Total System Global Area 6666207232 bytes Fixed Size 4259664 bytes Variable Size 2734686384 bytes Database Buffers 3774873600 bytes Redo Buffers 152387584 bytes Database mounted. Database opened.
Now start impdp , it will run smoothly now.