from:http://space.itpub.net/?uid-26148431-act
RAC环境下修改SGA参数步骤:(实验为两节点,如再多节点,可循环)
1.查看数据库状态
srvctl status database -d OCP
2.停节点1实例
srvctl stop instance -d OCP -i OCP1
3.启动节点1实例到mount状态
srvctl start instance -d OCP -i OCP1 -o mount
4.调整节点1,SGA最大值为8G,并加以注释
ALTER SYSTEM SET sga_max_size = 8589934592 COMMENT='internally adjusted' SCOPE=SPFILE SID='OCP1';
5.调整节点1,SGA目标值为5G
ALTER SYSTEM SET sga_target = 5368709120 SCOPE=SPFILE SID='OCP1';
6.停节点1实例
srvctl stop instance -d OCP -i OCP1
7.启动节点1实例到OPEN状态
srvctl start instance -d OCP -i OCP1 -o open
8.检查节点1是否正常。
select instance_name,status from v$instance;
9.停节点2实例
srvctl stop instance -d OCP -i OCP2
10.启动节点2实例到mount状态
srvctl start instance -d OCP -i OCP2 -o mount
11.调整节点2,SGA最大值为8G,并加以注释
ALTER SYSTEM SET sga_max_size = 8589934592 COMMENT='internally adjusted' SCOPE=SPFILE SID='OCP2';
12.调整节点2,SGA目标值为5G
ALTER SYSTEM SET sga_target = 5368709120 SCOPE=SPFILE SID='OCP2';
13.停节点2实例
srvctl stop instance -d OCP -i OCP2
14.启动节点2实例到OPEN状态
srvctl start instance -d OCP -i OCP2 -o open
15.检查节点2是否正常。
select instance_name,status from v$instance;