暂无图片
ORA-00823: Specified value of sga_target greater than sga_max_size
我来答
分享
yangweizhi
2021-09-15
ORA-00823: Specified value of sga_target greater than sga_max_size

[oracle@host05 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Sep 15 13:46:01 2021

Copyright © 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options

SQL> show parameter memory

NAME TYPE VALUE


hi_shared_memory_address integer 0
memory_max_target big integer 980M
memory_target big integer 980M
shared_memory_address integer 0
SQL> show parameter sga

NAME TYPE VALUE


lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 980M
sga_target big integer 0
SQL> show parameter pga

NAME TYPE VALUE


pga_aggregate_target big integer 0
SQL> alter system set sga_max_size=900M scope=spfile ;
alter system set sga_target=10M ;
alter system set pga_aggregate_target =1M scope=spfile ;
System altered.

SQL>
System altered.

SQL>

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-00823: Specified value of sga_target greater than sga_max_size
SQL>


sga_target设置的值小于sga_max_size设置的值 怎么还会报ORA-00823: Specified value of sga_target greater than sga_max_size这个报错

我来答
添加附件
收藏
分享
问题补充
2条回答
默认
最新
cqiwen
memory_target的值太小了,要么改大点,要么设置为0。这是两种内存管理模式。
暂无图片 评论
暂无图片 有用 0
yangweizhi
题主
2021-09-16
嗯 使用命令:alter system reset memory_max_target scope=spfile; alter system set memory_target=0M scope=spfile; 重启数据库以后,将两个参数设置为零,不仅sga_max_size大于等于sga_target,还要考虑db_cache_size,java_pool_size,large_pool_size,shared_pool_size,streams_pool_size的大小,将sga_max_size,sga_target全部设置成2G以后就能正常启库了
Uncopyrightable

AMM和ASMM两种内存模式,建议使用ASMM模式

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏