Oracle19c今天突然无法启动，启动提示：ORA-00093: pga_aggregate_limit must be between 6000M and 100000G ORA-01078: failure in processing system parameters

SQL> startup
ORA-00093: pga_aggregate_limit must be between 6000M and 100000G
ORA-01078: failure in processing system parameters

连接SQL*Plus，重新生成pfile文件

[oracle@bogondb trace]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Oct 12 22:27:47 2022
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> create pfile='/app/oracle/admin/ncc/pfile/initncc.ora' from spfile;

修改重新生成的pfile文件，将pga_aggregate_limit参数改为6000M

vim /app/oracle/admin/ncc/pfile/initncc.ora
#将pga_aggregate_limit值修改为6000M
*.pga_aggregate_limit=6000M

以pfile启动数据库，成功启动

SQL> startup pfile=''/app/oracle/admin/ncc/pfile/initncc.ora';

用pfile重新生成spfile

SQL> create spfile from pfile='/app/oracle/admin/ncc/pfile/initncc.ora';

关闭数据库

SQL> shutdown immediate

启动数据库，问题解决

SQL> startup