Re: cannot delete entry from spfile

From: Fabrizio <fabrizio.magni_at_mycontinent.com>
Date: Tue, 30 Nov 2004 18:59:44 GMT
Message-ID: <41ACC321.3090601@mycontinent.com>

Howard J. Rogers wrote:
> 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'.
>
> Regards
> HJR
Thank you. Second time in a row you teach me something useful about spfile.

Just to complete what you have started:
can you explain me the part on "sid='*'"? I'm puzzled: why do I need to specify "all instances"?

As always: many thanks

-- 
Fabrizio Magni

fabrizio.magni_at_mycontinent.com

replace mycontinent with europe

Received on Tue Nov 30 2004 - 12:59:44 CST