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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.