ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device on DB creation
(Doc ID 1595770.1)
Last updated on JANUARY 30, 2022
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199.0 [Release 8.1.7 to 20.0]
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Attempting to create a new database with a high setting of PROCESSES, e.g. 5000, and receiving a ORA-27102 like below even though there is plenty of memory available on the server.
In this scenario, it was found that the SHMMAX and SHMALL OS parameters were at the proper levels.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document