oracle rac 关闭自动内存管理,HP-UX oracle11.2.0.3 rac关闭内存自动管理

注意事项：

(1)备份参数文件–备份参数文件–备份参数文件

(2)两个节点分开执行

(3)11.2.0.3只需要reset memory_max_target ，不需要reset memory_target，如果两个同时执行，会不生效，11.2.0.4不存在这个问题

(4)如果更改参数导致实例启动失败，可以使用备份的pfile启动：

startup pfile=’/home/oracle/pfile20200421.ora’

节点一：

create pfile=’/home/oracle/pfile20200421.ora’ from spfile;

alter system set memory_target=0 scope=spfile sid=‘orcl1’;

alter system set memory_max_target=0 scope=spfile sid=‘orcl1’;

alter system set sga_target=100G scope=spfile sid=‘orcl1’;

alter system set pga_aggregate_target=20G sid=‘orcl1’;

alter system reset memory_max_target scope=spfile sid=‘orcl1’;

alter system switch logfile;

alter system switch logfile;

alter system checkpoint;

shutdown immediate

startup

show parameter memory

show parameter sga

show parameter pga

节点二：

create pfile=’/home/oracle/pfile20200421.ora’ from spfile;

alter system set memory_target=0 scope=spfile sid=‘orcl2’;

alter system set memory_max_target=0 scope=spfile sid=‘orcl2’;

alter system set sga_target=100G scope=spfile sid=‘orcl2’;

alter system set pga_aggregate_target=20G sid=‘orcl2’;

alter system reset memory_max_target scope=spfile sid=‘orcl2’;

alter system switch logfile;

alter system switch logfile;

alter system checkpoint;

shutdown immediate

startup

show parameter memory

show parameter sga

show parameter pga