ORA-31637: cannot create job | ORA-31621

I got ” ORA-31637: cannot create job | ORA-31621 ” error in Oracle database during the export ( expdp ) process.

 

ORA-31637: cannot create job | ORA-31621

 

Details of error are as follows.

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_IMPORT_TABLE_02 for user SYS
ORA-06512: at "SYS.KUPV$FT", line 1142
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-31621: error creating master process
ORA-31612: Allocation of process descriptor failed.
   

 

If you want to learn more details about Datapump ( export import ), read the following post.

Oracle Data Pump – Export Import ( Expdp Impdp ) Tutorial with Examples-4

 

 

ORA-31637: cannot create job for user SYS

This ORA-31637 errors are related with the Shortage of SGA memory for the session with the changing serial#.

To solve this error, you need to increase the SGA stopped the constant changing of the serial# and allowed for the session to be killed.

You can increase sga target as follows. But you need to restart database after this change.

 alter system set sga_target=12000M scope=spfile sid='*';

 

If you cannot restart database, you can use the following workaround and flush shared pool and buffer cache.

alter system flush shared_pool;

alter system flush buffer_cache;

 

You can kill the existing Export import process using the following post.

How to Kill or Stop Oracle Datapump Export ( EXPDP ) Job

 

Once the session was killed, the next run of the Datapump Job did not encounter the errors.

 

Second Case:

Sometimes this error is caused because of the parameter AQ_TM_PROCESSES is set to 0 and Oracle cannot create the queues needed for datapump export.

To solve this case, Set *.AQ_TM_PROCESSES > 0 to be able to create the queues when exporting, e.g.:

SQL> alter system set aq_tm_processes = 5 scope = both; 

-- or in RAC: 

SQL> alter system set aq_tm_processes = 5 scope = both sid ='*';

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

 

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *