修改sga参数只改了一个出现的故障 SQL> alter system set sga_max_size=3G scope=spfile; SQL> System altered. SQL> SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> SQL> startup ORA-01078: failure in processing system parameters ORA-00823: Specified value of sga_target greater than sga_max_size ASMCMD> ASMCMD> ls -l Type Redund Striped Time Sys Name Y CONTROLFILE/ Y DATAFILE/ Y ONLINELOG/ Y PARAMETERFILE/ Y TEMPFILE/ N spfileerpdb.ora => +DGSYSTEM/ERPDB/PARAMETERFILE/spfile.271.1145215107 ASMCMD> ASMCMD> cp +DGSYSTEM/ERPDB/PARAMETERFILE/spfile.271.1145215107 /home/oracle copying +DGSYSTEM/ERPDB/PARAMETERFILE/spfile.271.1145215107 -> /home/oracle/spfile.271.1145215107 ASMCMD> ASMCMD> SQL> SQL> startup pfile='/home/oracle/spfile.271.1145215107'; ORACLE instance started. Total System Global Area 3206836224 bytes Fixed Size 2257520 bytes Variable Size 1392512400 bytes Database Buffers 1795162112 bytes Redo Buffers 16904192 bytes Database mounted. Database opened. SQL> SQL> create spfile from pfile='/home/oracle/spfile.271.1145215107'; File created. SQL> SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> SQL> startup ORACLE instance started. Total System Global Area 3206836224 bytes Fixed Size 2257520 bytes Variable Size 1392512400 bytes Database Buffers 1795162112 bytes Redo Buffers 16904192 bytes Database mounted. Database opened. SQL> SQL> 修改sga参数 这两个参数需要一起改否则会出现以上问题 *.sga_max_size=3221225472 *.sga_target=3221225472