Re: How to edit spfile ?/
- From: "LS Cheng" <exriscer@xxxxxxxxx>
- To: oracledbam@xxxxxxxxxxx
- Date: Wed, 26 Apr 2006 23:16:58 +0200
Hi
spfile is a binary file so you cannot do that
On 4/26/06, Dean Paul <oracledbam@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx>
> >To: <tomday2@xxxxxxxxx>,<davidsharples@xxxxxxxxx>
> >CC: <oracledbam@xxxxxxxxxxx>,<gorbyx@xxxxxxxxx>,<oracle-l@xxxxxxxxxxxxx>
> >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@xxxxxxxxxxxxx
> >[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Thomas Day
> >Sent: Wednesday, April 26, 2006 3:58 PM
> >To: davidsharples@xxxxxxxxx
> >Cc: oracledbam@xxxxxxxxxxx; gorbyx@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> >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/
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
