Skip to Content
avatar image
Former Member

Unable to allocate X bytes of shared memory

Nov 22, 2017 at 09:32 AM | 71 Views

Hi everyone,

We're running several ERP+EWM systems on Oracle databases, which regularly die due to an ORA-00604 or ORA-04031 (unable to allocate 40 bytes of shared memory).

This seems to be a common problem and from what i could gather, extending the shared_pool_size Parameter in ora.ini accordingly usually solves it. We tried this several times (it's now way bigger than recommended), but all that accomplished was that the systems take longer to crash. They still do though.

The crashes usually occur at night when the jobs are running, but not at a specific job. All we can do ATM is restarting the system and wait for it to happen again.

Can someone maybe provide a solution? Or point me to where I should look?

Thanks,

Martin

Oracle Database
SAP ERP | EWM - Basis
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    James Zhang
    Nov 23, 2017 at 12:42 AM

    Hi Martin,

    Would you please also check whether there is os memory limit on oracle user (oracle/ora<sid>) or oracle executable ?

    Best regards,
    James

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Nov 23, 2017 at 09:22 AM

      Hi James,

      Thanks for your quick answer! The limit actually was way too low for our requirements. I upped it and that hopefully fixed it.

      Thanks again!

      Martin