My Oracle Support Banner

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 12.2.0.1 and later
Oracle Database - Standard Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

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.   

Changes

 New installation of Oracle RDBMS 12.2 using DBCA.

Cause

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
Symptoms
Changes
Cause
Solution


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