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?
Add comment