学步园

SQL> startup
ORA-00093: pga_aggregate_target must be between 10M and 4096G-1
SQL> startup nomount
ORA-00093: pga_aggregate_target must be between 10M and 4096G-1

这时，我才发现，前面修改的如下语句少了一个“M”:

SQL> alter system set pga_aggregate_target=500 scope=spfile;
系统已更改。

苦了，创建pfile到指定位置，例如“c:\initorcl.ora”。

SQL>create pfile='c:\initorcl.ora' from spfile;

修改initorcl.ora文件中pga_aggregate_target配置错误的值. 然后:

SQL> create spfile from pfile='c:\initorcl.ora';
SQL> startup