ORA-00823: Specified value of sga_target greater than sga_max

ORA-00823: Specified value of sga_target greater than sga_max_size

1、以sysdba身份登录

SQL> conn / as sysdba

2、创建pfile文件

SQL> CREATE PFILE='C:AppOracleproduct12.2.0dbhome_1dbspfile01.ora' FROM SPFILE;

3、修改上述创建文件的配置参数，1024以上，小于688M会报错

SQL> startup pfile='C:AppOracleproduct12.2.0dbhome_1dbspfile01.ora'
ORA-00821: Specified value of sga_target 512M is too small, needs to be at least 688M
ORA-01078: 处理系统参数失败

修改pfile01参数

 1 orcl.__data_transfer_cache_size=0
 2 orcl.__db_cache_size=3892314112
 3 orcl.__inmemory_ext_roarea=0
 4 orcl.__inmemory_ext_rwarea=0
 5 orcl.__java_pool_size=16777216
 6 orcl.__large_pool_size=83886080
 7 orcl.__oracle_base='c:AppOracle'#ORACLE_BASE set from environment
 8 orcl.__pga_aggregate_target=1711276032
 9 orcl.__sga_target=5117050880
10 orcl.__shared_io_pool_size=251658240
11 orcl.__shared_pool_size=855638016
12 orcl.__streams_pool_size=0
13 *.audit_file_dest='c:AppOracleadminorcladump'
14 *.audit_trail='db'
15 *.compatible='12.2.0'
16 *.control_files='c:AppOracleoradataorclcontrol01.ctl','c:AppOracleoradataorclcontrol02.ctl'
17 *.db_block_size=8192
18 *.db_name='orcl'
19 *.diagnostic_dest='c:AppOracle'
20 *.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
21 *.enable_pluggable_database=true
22 *.local_listener='LISTENER_ORCL'
23 *.nls_language='SIMPLIFIED CHINESE'
24 *.nls_territory='CHINA'
25 *.open_cursors=300
26 *.pga_aggregate_target=1624m
27 *.processes=640
28 *.remote_login_passwordfile='EXCLUSIVE'
29 *.sga_max_size=2048m
30 *.sga_target=1024m
31 *.undo_tablespace='UNDOTBS1'

4、重新创建spfile文件

SQL> create spfile from pfile='C:AppOracleproduct12.2.0dbhome_1dbspfile01.ora';

5、关闭后重新启动

SQL> shutdown immediate