RAC集群环境下内存管理AMM改为ASMM

show parameter spfile

+DATA/orcl/spfileorcl.ora

create pfile='/home/oracle/orcl20220724bef.pfile' from spfile;


alter system set sga_target=700m scope=spfile;
alter system set sga_max_size=700m scope=spfile;
alter system set pga_aggregate_target=200m scope=spfile;
alter system set memory_max_target=0 scope=spfile;
alter system reset memory_target scope=spfile;

create pfile='/home/oracle/orcl20220724aft.pfile' from spfile;

srvctl stop database -d orcl

vim /home/oracle/orcl20220724aft.pfile

*.memory_max_target=0 --删除这一行

startup nomount pfile='/home/oracle/orcl20220724aft.pfile';

create spfile='+DATA/orcl/spfileorcl.ora' from pfile='/home/oracle/orcl20220724aft.pfile';

shutdown

srvctl start database -d orcl