RE: How to edit spfile ?/
- From: Fuad Arshad <fuadar@xxxxxxxxx>
- To: oracledbam@xxxxxxxxxxx, ineyman@xxxxxxxxxxxxxx, tomday2@xxxxxxxxx, davidsharples@xxxxxxxxx
- Date: Wed, 26 Apr 2006 15:48:21 -0700 (PDT)
but the real point is what parameter are you tryingto set that need to be done
in a way of convertingto pfile.
all types of parameters can be set in an spfile including "_"'s
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"
>To: ,
>CC: ,,
>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:
