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 )