【脚本】一张列表帮助你摆脱升级11gR2带来的烦恼

oradbguy

好东西。谢谢刘大

oradbguy

脚本里面的
REM================================MEMORY===================================



alter system set memory_target=0     scope=spfile;

alter system set memory_max_target=0 scope=spfile;           ==>禁用AMM特性



应该去掉 memory_max_target=0，否则会遇到
ORA-00843: Parameter not taking MEMORY_MAX_TARGET into account
ORA-00849: SGA_TARGET 1065353216 cannot be set to more than MEMORY_MAX_TARGET 0.


或者改为reset  memory_max_target