Re: Increasing Size of SGA_MAX in Oracle 10G

>> Hi People,
>>
>> I am running an Oracle 10G clustered database with ASM hosted on a SAM
>> system. There are two instances accessing the DB from two different
>> machines at any given point of time. Now my question is how do we
>> change the parameter value of SGA_MAX_SIZE in such an environment. I
>> tried the following and i got the stated error msg
>>
>> SQL> create pfile from spfile;
>>
>> File created.
>>
>> SQL> alter system set sga_max_size=4000m scop=spfile;
>> alter system set sga_max_size=4000m scop=spfile
>>                  *
>> ERROR at line 1:
>> ORA-02095: specified initialization parameter cannot be modified
>>
>> Now I had also tried the very same thing on another machine hosting
>> the same Oracle 10G DB but with a single instance and without ASM and
>> it worked perfectly. Is there a reason why the above may have failed
>> or any work arounds to this, thought to seek some advice before i
>> start playing with a prod machine :-)
>>
>> Thanks.

Oops, sorry, Michzel already pointed that out.

Best regards

Maxim Received on Mon Apr 27 2009 - 01:12:52 CDT