194
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
- 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
- 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
- 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