Shooting yourself in the spfile 2004-02-20 - By Grabowy, Chris
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@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of Niall Litchfield
Sent: Friday, February 20, 2004 9:34 AM
To: oracle-l@(protected)
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=50m scope=spfile;
System altered.
SQL > alter system set db_block_buffers=2000 scope=spfile;
System altered.
SQL > startup force;
ORA-00381 (See ORA-00381.ora-code.com): cannot use both new and old parameters for buffer cache size
specification
SQL > oops
Niall Litchfield
Oracle DBA
Audit Commission
+44 117 975 7805
**********************************************************************
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@(protected)
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
