Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

PGA_AGGREGATE_LIMIT upgrade requirements

PGA_AGGREGATE_LIMIT

Recently upgraded oracle database on linux from 12.1.0.2 to 19.7

Oracle 19c RAC two node database unable to start or failing with error unless you set a minimum value of PGA_AGGREGATE_LIMIT to 15g and pga_aggregate_target 7680M

ORA-00093: pga_aggregate_limit must be between 10240M and 100000G

ORA-01078: failure in processing system parameters


SQL> show parameter pga;


NAME                 TYPE    VALUE

------------------------------------ ----------- ------------------------------

pga_aggregate_limit         big integer 15G

pga_aggregate_target         big integer 7680M



SQL> show parameter processes;


NAME                 TYPE    VALUE

------------------------------------ ----------- ------------------------------

aq_tm_processes           integer   1

db_writer_processes         integer   6

gcs_server_processes         integer   3

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center