Oracle instance does not start up after a SGA pool size increase, returning the ENOSPC error code
Issue
- Oracle instance does not start up if SGA pool size is increased more than a certain limit in the system, and logs are showing the following (similar) message:
*** 2011-12-18 06:22:04.979
Number of resource hash buckets is 8979
skgm warning: ENOSPC creating segment of size 00000000e0000000
fix shm parameters in /etc/system or equivalent
Environment
- Red Hat Enterprise Linux
- Oracle Database
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.