Oracle Database Discussions

How increase sga_max_size, sga_target in ORACLE RAC 10 G WITH 2 NODES;

i have oracle 10g in unix hp-ux 11i in rac (2 nodes)
with sga 8g; and i want to increase 12g;

i can alter these parameters without shutdown the entire database ?; , i can alter and take these change in one node first and later de second node?

i used in first node :
1- alter system set sga_max_size=16g scope spfile;
2- alter system set sga_targer=12g cope spfile;
later i restard all intance one by one:
srcvtl stop instance -d my_database -i my_instance1 -o immediate;
srcvtl start instance -d my_database -i my_instance1

3- in second node.

srcvtl stop instance -d my_database -i my_instance2 -o immediate;
srcvtl start instance -d my_database -i my_instance2

but my sga is the SAME 8G.. WHY NOT CHANGE...

i changed these parameters and restar my instance in first node later stop and start using srvctl the second node but my sga not change. continue in 8g ;however these changes are in spfile so;

prd2.sga_max_size=8589934592#internally adjusted
prd1.sga_max_size=8589934592#internally adjusted
*.sga_max_size=17179869184
prd2.sga_target=8589934592
prd1.sga_target=8589934592
*.sga_target=12884901888
prd2.thread=2
prd1.thread=1

how i can apply these change node by node or i need shutdown the entire database?


need to make these changes without affecting my application because i can not shutdown the both node...

Edited by: user568681 on 02-sep-2010 14:32