Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: alter system reset
Of course you can always do something like this:
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Sep 2 01:32:26 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer Release 9.2.0.4.0 - Production
SQL> create pfile='/tmp/init.ora' from spfile;
File created.
SQL> and then edit '/tmp/init.ora'. You can still startup the database by using "startup pfile=/tmp/init.ora' command. What's the big deal?
On 2003.09.02 01:09, Prem Khanna J wrote:
> Arup Bhai/Mladen,
>
> these are the lines i read from oracle docs.
>
> "Caution: Although you can open the binary server parameter file with a text
> editor and view its text, do not
> manually edit it. Doing so will corrupt the file. You will not be able to
> start your instance, and if the
> instance is running, it could fail."
>
> As you said,opening spfile is not a problem...but editing IS.
>
> Thanx to you both.
>
> Regards,
> Prem Khanna J.
>
> 02-09-2003 12:44:26, Mladen Gogala <mgogala_at_adelphia.net> wrote:
> >Prem, if you want to read the spfile, you can always do something like
> >strings $ORACLE_HOME/dbs/spfile.ora>/tmp/spfile.txt
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Prem Khanna J
> INET: jprem_at_kssnet.co.jp
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
-- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: mgogala_at_adelphia.net Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Tue Sep 02 2003 - 01:39:25 CDT