ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET

本文主要是介绍ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

有个11g rac环境，停电维护后，orcl1正常启动了，orcl2启动报错如下

SQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 29 14:04:21 2023

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SYS@orcl2> startup;
ORA-01078: failure in processing system parameters
ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET
SYS@orcl2>

因为orcl1正常，就计划在orcl1上修改参数，orcl2启动，发现修改MEMORY_MAX_TARGET和MEMORY_TARGET需要重启生效，

SYS@orcl1>    alter system set MEMORY_MAX_TARGET=160G sid='orcl2';
   alter system set MEMORY_MAX_TARGET=160G sid='orcl2'
                    *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

 就把2个节点的参数都修改了，轮流重启一遍，重启正常

  SYS@orcl1>  alter system set MEMORY_MAX_TARGET=160G  scope=spfile;
   
   SYS@orcl1>   alter system set MEMORY_TARGET=150G  scope=spfile;
 

这篇关于ORA-00837: Specified value of MEMORY_TARGET greater than MEMORY_MAX_TARGET的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---