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