RE: How to edit spfile ?/
- From: "Josh Collier" <collier_jw@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 26 Apr 2006 16:03:12 -0700
My question is why would you want to administer the spfile in any other method
that that which is supported?
josh c.
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Fuad Arshad
Sent: Wednesday, April 26, 2006 3:48 PM
To: oracledbam@xxxxxxxxxxx; ineyman@xxxxxxxxxxxxxx; tomday2@xxxxxxxxx;
davidsharples@xxxxxxxxx
Cc: gorbyx@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: How to edit spfile ?/
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:
