Re: Increasing Size of SGA_MAX in Oracle 10G

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Mon, 27 Apr 2009 08:11:53 +0200
Message-ID: <49F54CA9.2080301_at_gmail.com>

navneel.singh_at_gmail.com schrieb:
> 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.

You have a typo.

SQL> alter system set sga_max_size=400M scop=spfile; alter system set sga_max_size=400M scop=spfile

                  *

ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

SQL> alter system set sga_max_size=400M scope=spfile;

System altered.

Best regards

Maxim Received on Mon Apr 27 2009 - 01:11:53 CDT