ORA-31650: timeout waiting for master process response

 

ORA-31650: timeout waiting for master process response

Error

During execution of EXPDP or IMPDP, we are getting the following error:

Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
ORA-31626: job does not exist
ORA-31650: timeout waiting for master process response

Cause

SGA memory is set to low value(less than 1 GB).

Solution

1. Check the SGA value

Show parameter SGA_

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
sga_max_size                         big integer 536M
sga_min_size                         big integer 0
sga_target                           big integer 536M
unified_audit_sga_queue_size         integer     1048576

2. Increase the SGA memory

--Change sga parameter size
ALTER SYSTEM SET SGA_TARGET=2G scope=spfile;
ALTER SYSTEM SET SGA_MAX_SIZE=3G scope=SPFILE;

-- Restart the Database
Shutdown immediate
Startup

3. Tried the EXPDB if it’s fixed then good otherwise you can tried to rebuild the datapump utility:

Rebuild the DataPump packages with the following steps