I face this issue while trying to take export by using data pump

My system is:

AIX:6.1
Db verison:11.2.0.3
Process: expdp

The error message is:

ORA-31626: job does not exist
ORA-31637: cannot create job xxx for user TEST
ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95
ORA-06512: at “SYS.KUPV$FT_INT”, line 600
ORA-39080: failed to create queues “KUPC$xxx” and “KUPC$S_xx” for Data Pump job
ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95
ORA-06512: at “SYS.KUPC$QUE_INT”, line 1606
ORA-04031: unable to allocate 56 bytes of shared memory (“streams pool”,”unknown object”,”streams pool”,”fixed allocation callback”)

Workaround:

alter system flush shared_pool;

alter system flush buffer_cache;

Permanent solutions:

select * from v$parameter where name like ‘%sga%’;

alter system set sga_target=3000M; #Here we are increasing sga_target size
Advertisements