RE: How to edit spfile ?/

  • From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
  • To: <oracledbam@xxxxxxxxxxx>, <ineyman@xxxxxxxxxxxxxx>, <tomday2@xxxxxxxxx>, <davidsharples@xxxxxxxxx>
  • Date: Wed, 26 Apr 2006 15:14:57 -0600

No.  The spfile is binary.  On *nix, you can do this:

$ strings spfileSID.ora > initSID.ora

And then edit the init file using any text editor you would like.

You might be able to use sed or possibly perl (reading and writing in
binary mode).  However, I have never tried this, so you will need to
test this out.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Dean Paul
Sent: Wednesday, April 26, 2006 3:06 PM
To: ineyman@xxxxxxxxxxxxxx; tomday2@xxxxxxxxx; davidsharples@xxxxxxxxx
Cc: gorbyx@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: How to edit spfile ?/

My question is diffrent, Normally we can open pfile thru vi or any
and make  changes and restart database.Can we do similar with spfile?

>From: "Igor Neyman" <ineyman@xxxxxxxxxxxxxx>
>To: <tomday2@xxxxxxxxx>,<davidsharples@xxxxxxxxx>
>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
>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

Don't just search. Find. Check out the new MSN Search!


This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.


Other related posts: