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
Received on Wed Apr 26 2006 - 16:06:25 CDT
