My Oracle Support Banner

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 and later
Oracle Database - Enterprise Edition - Version 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
 Case 1 PGA_AGGREATE_LIMIT lowering
 Case 2 RAC Instance startup failure
 Cause for Case 1
 Cause for Case 2
 Solution for Case 1
 Solution for Case 2

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.