ORA-01078: failure in processing system parameters ORA-00093: pga_aggregate_limit must be between 2048M and 100000G
在启动数据库实例时报错:
ORA-01078: failure in processing system parameters
ORA-00093: pga_aggregate_limit must be between 2048M and 100000G
原因:
该报错是由于设置的pga_aggregate_limit值小于default值。由于参数文件中未设置memory_target值,而设置了pga_aggregate_target值未1024M,所以pga_aggregate_limit值至少为200%的pga_aggregate_target,即需设置大于2049M。
参考文档: