Re: How to edit spfile ?/

Hi

spfile is a binary file so you cannot do that

On 4/26/06, Dean Paul <oracledbam_at_hotmail.com> wrote:
>
> My question is diffrent, Normally we can open pfile thru vi or any editor
> and make changes and restart database.Can we do similar with spfile?
>
>
> >From: "Igor Neyman" <ineyman_at_perceptron.com>
> >To: <tomday2_at_gmail.com>,<davidsharples_at_gmail.com>
> >CC: <oracledbam_at_hotmail.com>,<gorbyx_at_gmail.com>,<oracle-l_at_freelists.org>
> >Subject: RE: How to edit spfile ?/
> >Date: Wed, 26 Apr 2006 16:05:10 -0400
> >
> >That's strange.
> >Any parameter you can change in pfile - you can change in spfile.
> >
> >Just not with every parameter you can do scope=both (meaning in memory
> >and in spfile - immediate effect).
> >So, for the the ones you can't - you do scope=spfile and restart the
> >database.
> >
> >________________________________
> >
> >From: oracle-l-bounce_at_freelists.org
> >[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Thomas Day
> >Sent: Wednesday, April 26, 2006 3:58 PM
> >To: davidsharples_at_gmail.com
> >Cc: oracledbam_at_hotmail.com; gorbyx_at_gmail.com; oracle-l_at_freelists.org
> >Subject: Re: How to edit spfile ?/
> >
> >
> >
> >Usually the parameter that I want to change is something that can't be
> >changed via ALTER SYSTEM. Very rarely do I get lucky and edit the
> >spfile such that the checksum is still valid. The only way that I know
> >of to always be able to alter the parameter in spfile is to create a
> >pfile from the spfile, edit the pfile, restart the database from the
> >pfile and create an spfile from the pfile.
> >
> >HUGE pain. Not a fan of spfile at all. Only use it when management
> >insists.
>
> _________________________________________________________________
> Don't just search. Find. Check out the new MSN Search!
> http://search.msn.click-url.com/go/onm00200636ave/direct/01/
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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