st ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: alter system reset
Of course, you can engage in the practice known as "safe hex", which means
using binary editors like "bvi", "bed" or "bitedit". That will help with
by: [EMAIL PROTECTED]
10/30/2003 01:29 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: RE: alter system reset
On a Unix system, you can "tput reset" to clear up that mess aft
ared
>
>
>
>
>
> "Arup Nanda" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>
>
> 09/01/2003 08:19 PM
> Please respond to ORACLE-L
>
>
>
> To:Multiple recipients of list ORACLE-L <[EMAIL
Khanna J.>>> 02-09-2003 04:14:26,
"Arup Nanda" <[EMAIL PROTECTED]> wrote:> >Does the entry even
exist in the SPFILE? Open up the spfile in notepadand> >check
the existence of the parameter in there. Do the following:> >SQL>
alter system set undo
You are correct arup
The parameter originally existed as
*.=
After running
alter system set = sid='lahiri' ;
it now exists as
lahiri.=
So either I specify the sid name while setting the parameters or I should
use the following to reset the parameters
alter system reset sid=&#
Mladen , you seem to be correct,
I checked the spfile and the parameters I try to modify exist there, but
reseting them takes one extra step
Say for example I find that undo_suppress_errors=false in the spfile.
Now if I try
SQL> alter system reset undo_suppress_errors scope=spfile sid=
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_poo
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 en
he 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
> >SQL> sid='ananda';
>
>> One should not rely on either the init.ora or the spfile to determine
which parameters are set, but should query the database
True, but the original poster wanted to see why the ALTER SYSTEM RESET ...
SCOPE=SPFILE failed and that would occur only if the entry is not found in
the spfile
quot; <[EMAIL PROTECTED]> wrote:
> >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
.
Jared
"Arup Nanda" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
09/01/2003 08:19 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: alter system res
Of course you can always do something like this:
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Sep 2 01:32:26 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning option
JServer R
Arup Bhai/Mladen,
these are the lines i read from oracle docs.
"Caution: Although you can open the binary server parameter file with a text editor
and view its text, do not
manually edit it. Doing so will corrupt the file. You will not be able to start your
instance, and if the
instance is ru
Arup Bhai, many many thanx for your explanation.
Regards,
Prem Khanna J.
02-09-2003 12:19:25, "Arup Nanda" <[EMAIL PROTECTED]> wrote:
>Prem,
>
>The SPFILE should never be opened to be modified; opening a file to see the
>contents are acceptable and that's what I said. Sometimes opening the file
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.
>Arup
--
Please see the official ORACLE-L FAQ: http://www.
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_er
>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
up Nanda wrote:
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_su
.wanted to know how you gurus handle SPFILE.
Thanx Mladen.
Regards,
Prem.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- M
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
ME TYPE VALUE
db_namestring 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 id
22 matches
Mail list logo
