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 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!


In this Document
Symptoms
 Case 1 PGA_AGGREATE_LIMIT lowering
 Case 2 RAC Instance startup failure
Changes
Cause
 Cause for Case 1
 Cause for Case 2
Solution
 Solution for Case 1
 Solution for Case 2
References


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