Skip to Content
0

Unable to allocate X bytes of shared memory

Nov 22, 2017 at 09:32 AM

60

avatar image
Former Member

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
Answers Answers and Comments
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sort by:
Best Answer
avatar image
James Zhang Answered
Nov 23, 2017 at 12:42 AM
1

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
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

0
Comment