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: Changing the spfile on 9.2.0.3

Re: Changing the spfile on 9.2.0.3

From: David Sharples <davidsharples_at_gmail.com>
Date: Thu, 11 Nov 2004 09:42:49 +0000
Message-ID: <be592d550411110142594216ec@mail.gmail.com>


If you already have an spfile you cant create another one.

You can delete the old one of you wish and re-create it like that.

If you didnt know you can change any parameters with alter system set <parameter> = <value> scope = spfile;

Dont have to keep creating a new one

On Thu, 11 Nov 2004 11:40:55 +0200, Denham Eva <evad_at_tfmc.co.za> wrote:
> Hello Folks
>
> I am trying to "update"/"change" the spfile with the edited init.ora
> file under pfile in admin.
>
> I start the database startup mount;
>
> Then use the
>
> CREATE SPFILE FROM PFILE='PATH\TO\INIT\PFILE\INIT.ORA';
>
> But Oracle complains that the spfile is already in use.
>
> Must I use a different name ie change the name of spfile? OR can I
> update/alter spfile?
>
> OR is there something with the method?
>
> TIA
>
> Denham
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 11 2004 - 03:38:42 CST

Original text of this message

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