Oracle-L: alter system reset

From: <bulbultyagi_at_now-india.net.in>
Date: Mon, 01 Sep 2003 10:14:25 -0800
Message-ID: <F001.005CE734.20030901101425@fatcity.com>

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). Received on Mon Sep 01 2003 - 13:14:25 CDT