Re: cannot delete entry from spfile

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<41acd106$0$20379$afc38c87_at_news.optusnet.com.au>...
> Fabrizio wrote:
> >
> > 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"?
>
>
> It's bizarre, isn't it?!
>
> When you're not running RAC, you might have thought that the
> specification of a SID was not necessary, since you've only got the one
> to choose from.
>
> Even in a RAC environment, you might reasonably have thought the
> specification of a SID was not necessary, because "*" is the default
> one. If you ever do 'alter system set shared_pool_size=200M
> scope=spfile', for example, and then look at what has been set inside
> the spfile, you'll see an entry for...
>
> *.shared_pool_size=200M
>
> ...the "*" gets put in automatically.
>
> But when it comes to *resetting* a parameter, relying on the default to
> kick in doesn't work. You absolutely, explicitly, have to specify either
> a named instance or a "*":
>
> SQL> alter system reset transactions_per_rollback_segment scope=spfile;
> alter system reset transactions_per_rollback_segment scope=spfile
> *
> ERROR at line 1:
> ORA-00905: missing keyword
>
> SQL> alter system reset transactions_per_rollback_segment scope=spfile
> sid='*';
>
> System altered.
>
> I can't see the logic in having to specify explicitly what would
> ordinarily be regarded as the default. But that's simply the way it is.
>
> Best regards,
> HJR
Of course, this made me curious as to what the docs say, so I went to tahiti and searched the 9.2 set for "alter system reset" which gave one hit, which didn't really clarify anything. OK, fine. I went to the 10 set, which gave one hit, which was just a DataGuard error. Sheesh, not so fine. I clicked on the Search tab, entered the same phrase for the Internet search, same results. Then I noticed under Master Index it had bright red letters "Goog Redirection Test" followed by Referrer =
http://otn.oracle.com/pls/db10g/portal.portal_demo3?selected=1

This page was not referred from Google

Then I went to the Master Index HTML, and I couldn't find an ALTER SYSTEM RESET. Hmmmm.

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_2013.htm#i2146449

ought to be in the index somewhere. And the Database Reference ought to describe it.

jg

--
@home.com is bogus
http://www.boston.com/news/nation/articles/2004/11/30/us_eyes_collection_of_college_student_data/