Re: changing init.ora and spfile
- From: Bradd Piontek <piontekdd@xxxxxxxxx>
- To: genegurevich@xxxxxxxxxxxx
- Date: Fri, 31 Jul 2009 12:17:08 -0500
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@xxxxxxxxxxxx> 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.
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
