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

From: Peter Sylvester <peters_no_spam_please_at_mitre.org>
Date: Tue, 27 Jan 2004 10:16:37 -0500
Message-ID: <bv5vcl$380$1@newslocal.mitre.org>

I had something similar happen on a Solaris box after there was a crash or power outage, and the spfile evidently got corrupted. Replacing with a good old fashion init.ora fixed it (and no more spfiles for me!).

--Peter

Forte Agent 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.
>
>
Received on Tue Jan 27 2004 - 09:16:37 CST