ORA-00823: Specified value of sga_target greater than sga_max_size
1、以sysdba身份登录
SQL> conn / as sysdba
2、创建pfile文件
SQL> CREATE PFILE='C:\App\Oracle\product\12.2.0\dbhome_1\dbs\pfile01.ora' FROM SPFILE;
3、修改上述创建文件的配置参数，1024以上，小于688M会报错
SQL> startup pfile='C:\App\Oracle\product\12.2.0\dbhome_1\dbs\pfile01.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:\App\Oracle'#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:\App\Oracle\admin\orcl\adump' 14 *.audit_trail='db' 15 *.compatible='12.2.0' 16 *.control_files='c:\App\Oracle\oradata\orcl\control01.ctl','c:\App\Oracle\oradata\orcl\control02.ctl' 17 *.db_block_size=8192 18 *.db_name='orcl' 19 *.diagnostic_dest='c:\App\Oracle' 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:\App\Oracle\product\12.2.0\dbhome_1\dbs\pfile01.ora';
5、关闭后重新启动
SQL> shutdown immediate
