Re: changing init.ora and spfile

From: Bradd Piontek <piontekdd_at_gmail.com>
Date: Fri, 31 Jul 2009 12:17:08 -0500
Message-ID: <e9569ef30907311017l6502445cy5c649c16cd7f58_at_mail.gmail.com>

I suppose that will work. I typically just stage them vi 'ALTER SYSTEM SET <parameter_name> = <value SCOPE=SPFILE'however, maybe you are worried someone else comes along and changes the spfile? You could just create the pfile and then create the new spfile right away (as a different name). Then, when it is time to restart shutdown immediate
cp spfilenew.ora spfile<SID>.ora
startup

Bradd Piontek
  "Next to doing a good job yourself,

        the greatest joy is in having someone
        else do a first-class job under your
        direction."

• William Feather

On Fri, Jul 31, 2009 at 12:09 PM, <genegurevich_at_discover.com> wrote:

> Hello:
>
> I want to make sure that I am making this change correctly. I have a
> 10.2.0.3 DB which users spfile and I need to increase the SGA_MAX and
> SGA_TARGET parameters. My plan is to
>
> - modify the init.ora file
> - make a copy of an existing spfile
> - shut down the database
> - restart as startup using pfile=initXXX.ora
> - when database is started execute create spfile from pfile
>
> That should guarantee that these changes are in the spfile and will not be
> lost next time the database is bounced. Am I correct?
>
> thank you
>
> Gene Gurevich
>
>
>
>
> Please consider the environment before printing this email.
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jul 31 2009 - 12:17:08 CDT