RE: Shooting yourself in the spfile

From: Grabowy, Chris <chris.grabowy_at_lmco.com>
Date: Fri, 20 Feb 2004 10:15:05 -0500
Message-id: <974B0BC4C9F3BB40B2651F8FC12B7B98A520F3@emss04m12.us.lmco.com>

Perhaps if I were a junior DBA and I blindly applied parameter changes to multiple databases then this would be a problem. To clarify, I am not refering to Jonathan's specific situation.

Obviously, before you apply any change across a couple hundred databases then you do some thorough testing. Assuming your configurations are the same then you should not have a problem. And yes, on occasion you will hit a problem database, so you go fix it.

As for your example, even if you made these changes in a pfile, wouldn't you get the same result?? So then you would fix it, either in the pfile or spfile, and bring the database up. Is that not true?

I still stand behind MHO. Spfiles are not pfiles, therefore you have to change your way of thinking and your "SOPs".

(psssstt)

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Niall Litchfield Sent: Friday, February 20, 2004 9:34 AM
To: oracle-l_at_freelists.org
Subject: RE: Shooting yourself in the spfile

I'd buy that if it wasn't so easy to do what Jonathan said for example

SQL> alter system set db_cache_size=3D50m scope=3Dspfile;

System altered.

SQL> alter system set db_block_buffers=3D2000 scope=3Dspfile;

System altered.

SQL> startup force;
ORA-00381: cannot use both new and old parameters for buffer cache size spe=
cification
SQL> oops

Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805=20

This email contains information intended for the addressee only. It may be confidential and may be the subject of legal and/or
professional privilege. Any dissemination, distribution, copyright or use of this
communication without prior permission of the sender is strictly prohibited.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Fri Feb 20 2004 - 09:15:05 CST