My Oracle Support Banner

DBCA Fails With ORA-00821 Error (sga_target Is Too Small) (Doc ID 2409633.1)

Last updated on JULY 25, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Oracle Database - Standard Edition - Version 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.