• From: "Herring Dave - dherri" <Dave.Herring@xxxxxxxxxx>
  • To: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • Date: Sun, 3 Sep 2006 16:09:37 -0500

I went through those hoops below because I incorrectly thought I had to
provide the sid value (never thought to try asterisk):

alter system reset sort_area_size scope = spfile sid = '...'
ERROR at line 1:
ORA-32010: cannot find entry to delete in SPFILE

Not sure what I'm missing, but at least I now know '*' works and will
definitely share that info!!  Thanks Chris!

Dave Herring, DBA
Acxiom Corporation
3333 Finley
Downers Grove, IL 60515
wk: 630.944.4762
"When I come home from work and see those little noses pressed against
the windowpane, then I know I am a success" - Paul Faulkner

> -----Original Message-----
> From: Christian Antognini [mailto:Christian.Antognini@xxxxxxxxxxxx]
> Sent: Sunday, September 03, 2006 2:33 PM
> To: Herring Dave - dherri
> Cc: oracle-l@xxxxxxxxxxxxx
> Dave
> > What would be the best way to do this in a non-RAC env?  All that I
> > can figure is:
> >
> > ALTER SYSTEM RESET db_cache_size SCOPE = memory SID = '<sid>';
> > /* Since SCOPE = spfile doesn't work in a non-RAC env as the sid
> > value isn't * included within the spfile. */
> There is no difference between RAC and non-RAC environment. The part
> about the SID is always available. If nothing is specified, which is
> common in non-RAC environment, the character "*" is used instead. In a
> RAC environment the character "*" is used for most parameters as well.
> In fact you use the SID only for those parameters that must be
> specific.
> Therefore to remove a parameter for a single instance, or from
> instances with RAC, you can use the following statement.
> ALTER SYSTEM RESET <parameter> SCOPE=spfile SID='*'
> > CREATE pfile FROM spfile;
> > /* to make sure any other changes get saved in the pfile, since
> > that'll be * used on next instance startup. */
> >
> > Then remember to delete line 'db_cache_size = ...' from the pfile
> > before
> > the next instance bounce, then startup the instance using the pfile.
> >
> > CREATE spfile FROM pfile;
> > /* so that the spfile is now current with pfile changes. */
> i.e. it's not reason to do it in this way...
> Chris
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally privileged.

If the reader of this message is not the intended recipient, you are 
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.

If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.

Thank you.

Other related posts: