Startup Database Fails With ORA-444, ORA-4032 And ORA-450
(Doc ID 781540.1)
Last updated on APRIL 06, 2020
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.2 [Release 11.1 to 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
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
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 |
Changes |
Cause |
Solution |
References |