14 Replies Latest reply: May 17, 2011 12:22 PM by Hussein Sawwan-Oracle RSS

    ORA-04031: unable to allocate bytes of shared memory ("streams pool",...) ?

    user629987
      Hi,

      From time to time, the datapump backups of our EBS databases give the following error:

      From the datapump logfile:
      ORA-39014: One or more workers have prematurely exited.
      ORA-39029: worker 3 with process name "DW03" prematurely terminated
      ORA-31671: Worker process DW03 had an unhandled exception.
      ORA-04031: unable to allocate 544 bytes of shared memory ("streams pool","unknown object","streams pool","kwqbsinfy:mpr")
      ORA-06512: at "SYS.KUPW$WORKER", line 1602
      ORA-06512: at line 2

      From the alertlog:
      ORA-04031: unable to allocate bytes of shared memory ("","","","")
      ORA-04031: unable to allocate 2024 bytes of shared memory ("streams pool","unknown object","streams pool","kodpaih3 image")
      ORA-04031: unable to allocate bytes of shared memory ("","","","")
      ORA-04031: unable to allocate 2024 bytes of shared memory ("streams pool","unknown object","streams pool","kodpaih3 image")
      Error message: ORA-48913: Writing into trace file failed, file size limit [10485760] reached
      Writing to the above trace file is disabled for now on...
      ORA-04031: unable to allocate 2024 bytes of shared memory ("streams pool","unknown object","streams pool","kodpaih3 image")
      ORA-06512: at "SYS.KUPW$WORKER", line 1602
      ORA-06512: at line 2
      opidrv aborting process DW04 ospid (75364_32092) due to error ORA-447

      I can't find anything useful from the trace files. After restarting the databases, the problem is fixed but only temporarily. After some time, we see it happening again. We have seen this error only on the EBS databases and not for any other databases, so I am wondering if this is EBS specific and how to get rid of the problem permanently? Thanks.