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
Oracle Database - Standard Edition - Version 220.127.116.11 and later
Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Information in this document applies to any platform.
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:
Change of Case 1: Upgraded from 12.1 to 12.2 was performed.
Change of Case 2: Increased initialization parameter 'PROCESSES'.
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
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.