Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: alter system reset

Re: alter system reset

From: Mladen Gogala <mgogala_at_adelphia.net>
Date: Mon, 01 Sep 2003 22:39:25 -0800
Message-ID: <F001.005CE751.20030901223925@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US