Re: cannot delete entry from spfile

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:41acb3ef$0$9390$afc38c87_at_news.optusnet.com.au...
> Ed Stevens wrote:
>
> >
> > Gen it to a pfile, edit to your heart's content, then gen it back to a
> > spfile. I leave the syntax details to the student as homework.
>
> I'll reply to you Ed, but I see you are not alone.
>
> There is zero need to convert to a pfile to edit out (ie, remove) the
> deprecated parameter, given that it has not prevented him from at least
> starting his instance.
>
> The command people should apparently be a little more familiar with is:
>
> alter system reset max_enabled_roles scope=spfile sid='*' ;
>
> (And the "sid=" clause is required, even though the value specified is,
> in this case, the default in any case!).
>
> In a world where converting to a pfile might not actually remain an
> option for ever and ever, it might be a good idea to know how to work
> with spfiles 'natively'.
>

Brillient it works! Thanks, it's just ashame Oracle forgot to put this useful information under the 'how to remove a parameter from the spfile' section of their documentation.

Cheers,
Steve.

> Regards
> HJR
Received on Tue Nov 30 2004 - 23:47:16 CST