修改sga出现的故障

shanxia / 2023-08-21 / 原文

修改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