Oracle instance does not start up after a SGA pool size increase, returning the ENOSPC error code

Solution Verified - Updated -

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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In
Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.