| 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 ?/
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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dean Paul
Sent: Wednesday, April 26, 2006 3:06 PM
To: ineyman_at_perceptron.com; tomday2_at_gmail.com; davidsharples_at_gmail.com
Cc: gorbyx_at_gmail.com; oracle-l_at_freelists.org
Subject: RE: How to edit spfile ?/
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.
-- http://www.freelists.org/webpage/oracle-l This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended 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. -- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 26 2006 - 16:14:57 CDT
 |
 |