My Oracle Support Banner

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

Last updated on SEPTEMBER 24, 2020

Applies to:

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

Symptoms


When trying to upgrade to 11.1.0.7 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

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
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.