修改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
标签：Database,bytes,修改,故障,1145215107,ASMCMD,SQL,sga From： https://www.cnblogs.com/shanxia0812/p/17646656.html