Startup Database Fails With ORA-444, ORA-4032 And ORA-450
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