RE: Shooting yourself in the spfile
- From: "Grabowy, Chris" <chris.grabowy@xxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 20 Feb 2004 10:15:05 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Niall Litchfield
Sent: Friday, February 20, 2004 9:34 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
