Re: Bad value in SPFILE. . . Database won't come up

Giganews Newsgroups
Subject: Re: Bad value in SPFILE. . . Database won't come up
Posted by:  g…@pbihag.ch
Date: Tue, 27 Jan 2004

Forte Agent <14431…@usenetplanet.com> wrote:
>
> One of my database is refusing to be started on Windows 2000,
> complaining a parameter value in SP file is invalid.  I tried to
> modify the parameter value using "alter system set xxxx=xxxx
> scope=spfile", but of course, it refuses to update it saying database
> is not up.  So basically, I am stuck.  What should I do to change this
> value in SPFILE so that I can open it?  Thank you in advance.

create an ini file with correct values, then create a new spfile
from that ini file with the following command:

create spfile 'spfile_name' from pfile='inifile_name';

Vangelis

--

Replies

None

In response to

Bad value in SPFILE. . . Database won't come up posted by Forte Agent on Tue, 27 Jan 2004