有个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;