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 AUGUST 21, 2020
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52.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
***Checked for relevance on 29-Apr-2015***
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