8 Replies Latest reply on Apr 5, 2012 2:59 PM by user560159

    ERROR when taking an export using EXPDP

    user560159
      Hi There,
      I am receiving the following error when perform the scheduled nightly backup. The strange thing is the production instance has the same setup and it is not having this problem. The following parameters (memory_target, memory_max_target and streams_pool_size) are not being used in the production and non-production database base. They are all set to "0".

      Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA

      UDE-04031: operation generated ORACLE error 4031
      ORA-04031: unable to allocate 56 bytes of shared memory ("streams pool","unknown object","streams pool","fixed allocation callback")
      ORA-06512: at "SYS.KUPC$QUE_INT", line 431
      ORA-06512: at "SYS.KUPC$QUE_INT", line 1544
      ORA-06512: at "SYS.KUPC$QUE_INT", line 576
      ORA-25254: time-out in LISTEN while waiting for a message
      ORA-06512: at "SYS.DBMS_DATAPUMP", line 3326
      ORA-06512: at "SYS.DBMS_DATAPUMP", line 4551
      ORA-06512: at line 1


      UDE-04031: operation generated ORACLE error 4031
      ORA-04031: unable to allocate 56 bytes of shared memory ("streams pool","unknown object","streams pool","fixed allocation callback")
      ORA-06512: at "SYS.DBMS_DATAPUMP", line 4373
      ORA-06512: at line 1

      UDE-31623: operation generated ORACLE error 31623
      ORA-31623: a job is not attached to this session via the specified handle
      ORA-06512: at "SYS.DBMS_DATAPUMP", line 3326
      ORA-06512: at "SYS.DBMS_DATAPUMP", line 4551
      ORA-06512: at line 1


      Thanks,
      J