1.修改第一个节点:
alter system set sga_max_size=2G sid="rac1 "scope=spfile;
alter system set sga_target=2G sid="rac1 "scope=spfile;
shutdown immediate
startup
2.当第一个节点启动后,修改第2个节点:
alter system set sga_max_size=2G sid = "rac2 "scope=spfile;
alter system set sga_target=2G sid = "rac2 "scope=spfile;
shutdown immediate
startup[@more@]rac
alter system set sga_max_size=2G sid="rac1 "scope=spfile;
alter system set sga_target=2G sid="rac1 "scope=spfile;
shutdown immediate
startup
2.当第一个节点启动后,修改第2个节点:
alter system set sga_max_size=2G sid = "rac2 "scope=spfile;
alter system set sga_target=2G sid = "rac2 "scope=spfile;
shutdown immediate
startup[@more@]rac
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22934571/viewspace-1048404/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22934571/viewspace-1048404/