ORA-04031: unable to allocate 27504 bytes of shared memory
- Article Type: General
- Product: Aleph
- Product Version: 17.01
Description:
We are getting errors, especially in our oclc_server logs like the following:
Oracle error: handle_connection
ORA-04031: unable to allocate 27504 bytes of shared memory ("shared po
Our current setting is:
SHARED_POOL_SIZE=268435456 #256M
SHARED_POOL_RESERVED_SIZE=13421772 #13M
Should these be upped?
Resolution:
From site: We believe that the problem here may have been a system setting. In particular, the semsys:seminfo_semmsl setting.
We had to up our number of Oracle processes to 1000 and did not make the corresponding change to the system configuration. We have since upped the semsys:seminfo_semmsl number and rebooted the machine.
See also KB 4108, which has info about other solutions to this problem.
Additional Information
faq
- Article last edited: 10/8/2013