DBCA Fails With ORA-00821 Error (sga_target Is Too Small)
(Doc ID 2409633.1)
Last updated on OCTOBER 08, 2019
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Oracle Database - Standard Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
DBCA fails to create a database and generates the error:
ORA-00821: Specified value of sga_target 12000M is too small, needs to be at least 21312M
Server is a zone configuration with 128GB physical memory and M7 processor, 32 cores, 256 threads. The zone is defined with no memory cap, and CPU resources are controlled by the Fair Share Scheduler (FSS). Automatic memory setting for SGA and PGA has been defined. This is also occurring in environments with a memory cap defined.
New installation of Oracle RDBMS 12.2 using DBCA.
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