Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Bad value in SPFILE. . . Database won't come up
Forte Agent <1443131_at_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
--Received on Tue Jan 27 2004 - 05:37:35 CST