Re: alter system reset

ALTER SYSTEM RESET applies to RACs only and you need to give the SID parameter. When you said "I find that shared_pool_size exists there", did it exist as the follwoing?

*.shared_pool_size=...

I bet it did. Note how you used the SID in setting the value

alter system set shared_pool_size=40M scope=spfile sid='lahiri' ;

This properly set the value for the SID lahiri, not globally. That is why the RESET operation was successful after the SET operation. The same is true for any other parameters that is reset.

HTH. Arup Nanda

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, September 04, 2003 3:29 AM

> Yes , opened up spfile in a text editor and undo_suppress_errors exists.
But
> I get the error , no matter which parameter I try to reset. ex:
> undo_management, undo_tablespace, undo_retention, pga_aggregate_target,
> workarea_size_policy, shared_pool_size, sort.......etc, etc
> However when I open the spfile I find that shared_pool_size exists there ,
> then I try resetting it (just to test it out)
>
>
> SQL> alter system reset shared_pool_size scope=spfile sid='lahiri' ;
> alter system reset shared_pool_size scope=spfile sid='lahiri'
> *
> ERROR at line 1:
> ORA-32010: cannot find entry to delete in SPFILE
>
>
> SQL> alter system set shared_pool_size=40M scope=spfile sid='lahiri' ;
>
>
> System altered.
>
> SQL> alter system reset shared_pool_size scope=spfile sid='lahiri' ;
>
> System altered.
>
> Why does this happen ?
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, September 02, 2003 00:44
>
>
> > Does the entry even exist in the SPFILE? Open up the spfile in notepad
and
> > check the existence of the parameter in there. Do the following:
> >
> > SQL> alter system set undo_suppress_errors = false scope=spfile
> > sid='ananda';
> >
> > System altered.
> >
> > SQL> ALTER SYSTEM RESET undo_suppress_errors scope=spfile sid='ananda';
> >
> > System altered.
> >
> > HTH.
> >
> > Arup
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Monday, September 01, 2003 2:14 PM
> >
> >
> > > Hello list I am using Oracle 9.2.0.1.0 enterprise on windows.
> > >
> > > When I run the following ( connected as sysdba , and using an spfile
> > called
> > > %oracle_home%\database\spfilelahiri.ora )
> > >
> > > SQL> show user
> > > USER is "SYS"
> > >
> > > SQL> host echo %oracle_sid%
> > > LAHIRI
> > >
> > > SQL> sho parameter db_name
> > >
> > > NAME TYPE VALUE
> > > db_name string lahiri
> > >
> > > SQL> ALTER SYSTEM RESET undo_suppress_errors SCOPE=BOTH SID='lahiri';
> > > ALTER SYSTEM RESET undo_suppress_errors SCOPE=BOTH SID='lahiri'
> > > *
> > > ERROR at line 1:
> > > ORA-32010: cannot find entry to delete in SPFILE
> > >
> > > Any ideas ? I get the same problem irrespective of the parameter I
try
> to
> > > reset.
> > > ..............
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: <bulbultyagi_at_now-india.net.in
> > > INET: bulbultyagi_at_now-india.net.in
> > >
> > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > > San Diego, California -- Mailing list and web hosting services
> > > ---------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> > >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Arup Nanda
> > INET: orarup_at_hotmail.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: <bulbultyagi_at_now-india.net.in
> INET: bulbultyagi_at_now-india.net.in
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: orarup_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).