| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_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"
>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_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.
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 26 2006 - 17:48:21 CDT
 |
 |