My Oracle Support Banner

DBUA Reports ORA-821 (SGA_TARGET too small) and ORA-1078 While Upgrading to (Doc ID 1250815.1)

Last updated on SEPTEMBER 24, 2020

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.1]
Oracle Database - Standard Edition - Version to [Release 18]
Information in this document applies to any platform.


When trying to upgrade to using DBUA, the following errors occur during the pre-upgrade phase:

ORA-00821: specified value of sga_target 2048M is too small, needs to be at least 2256M
ORA-01078: failure in processing system parameters


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.