Instance Startup Fails With ORA-00093 ORA-01078 After Change On 'PROCESSES' Or 'PGA_AGGREGATE_LIMIT' Parameters
(Doc ID 2443590.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Standard Edition - Version 12.2.0.1 and later Oracle Database - Enterprise Edition - Version 12.2.0.1 and later Information in this document applies to any platform.
Symptoms
Case 1 PGA_AGGREATE_LIMIT lowering
Starting with 12.2, if pga_aggregate_limit parameter is set to a value smaller than 2G, the instance cannot be started due to below error:
Changes
Change of Case 1: Upgraded from 12.1 to 12.2 was performed.
Change of Case 2: Increased initialization parameter 'PROCESSES'.
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!