Startup Database Fails With ORA-444, ORA-4032 And ORA-450 (Doc ID 781540.1)

Last updated on JUNE 30, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

Startup database fails with ORA-444, ORA-4032 and ORA-450:

ORA-00450: background process 'XXX' did not start
ORA-00444: background process "XXX" failed while starting

ORA-04032: pga_aggregate_target must be set before switching to auto mode

Changes

Customer non-default settings in SPFILE:
  shared_pool_size         = 256M
  large_pool_size          = 64M
  java_pool_size           = 128M
  memory_target            = 2G
  memory_max_target        = 8G
  db_cache_size            = 256M
  pga_aggregate_target     = 512M

Creating PFILE from SPFILE show following values:
  .__db_cache_size=268435456
  .__java_pool_size=335544320
  .__large_pool_size=67108864
  .__pga_aggregate_target=0
  .__sga_target=2147483648
  .__shared_io_pool_size=0
  .__shared_pool_size=1275068416
  .__streams_pool_size=134217728

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