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.
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 )