ORA-821 ORA-838 on startup/create database bug 4943849 (Doc ID 1097866.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.0. [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

Trying to create/startup two similar databases with minimal SGA on 11.1.0.7:

  - Two Sun SPARC machines
  - Each with an 11.1.0.7.0 $ORACLE_HOME
  - The minimum SGA specifications required to create an 11.1.0.7.0 database are very different:

MACHINE (a) - the database is created with 250MB (memory_target) without any issues
SunOS   5.10 Generic_139555-08 sun4u sparc SUNW,Sun-Fire-V49

The problem MACHINE (b) is on
SunOS  5.10 Generic_137111-08 sun4v sparc SUNW,Sun-Blade-T632

If you try to create or startup the database on machine (b) with minimum memory of 250MB, it throws an error stating that the "memory_target" is too small and must be a certain value.

ORA-00821: Specified value of sga_target 292M is too small, needs to be at least 308M
ORA-838: Specified value of MEMORY_TARGET is too small

Changes

The only difference between the two machines is the CPU count:

Machine (a): 8 CPU 
Machine (b): 64 CPU

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms