| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: More spfile goodness
My First Post, so newbie apologies in advance :-)
We considered, and discarded, the idea of moving to full use of spfiles during our upgrade from 8i to 9i using the following reasoning:
Pros
Cons
useful
- You need permission to log into the server O/S in order to modify the=20
initialization parameters (security)
The Cons were pretty important to us and the Pros seemed to have both
security issues (we don't want any DBA to be able to modify the file,
we want the added O/S security) and unintential consequence issues=20
(Change this parameter for this run -- don't fat-finger SCOPE=3DBOTH
by accident). Since the old format was still supported, we stayed with
it.
(We did take the opportunity to thoroughly scrub the old files and ditch
parameters for which we should have been using Oracle's defaults instead).
I'm guessing that the reason a binary file was chosen was because the developer used some weird internal object to represent the parameters=20 (heck, it's probably a Java-serialized-object :-) and sold his/her management that it was necessary in order to achieve the Pros as listed above :-) ("Don't want those pesky DBA's messing up the file format").
Dominic Delmolino
Sr. Development Manager, Database Services
ddelmolino_at_networksolutions.com
703.668.4694 Office
703.668.7810 Office Fax
Mailstop WV-9-1
9-127
Network Solutions
13200 Woodland Park Dr.
Herndon, VA 20171
USA=20
=20
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Wolfson Larry -
lwolfs
Sent: Friday, May 07, 2004 8:13 PM
To: 'oracle-l_at_freelists.org'
Subject: RE: More spfile goodness
Paul,
Thanks Larry
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Paul Baumgartel
Sent: Friday, May 07, 2004 11:19 AM
To: oracle-l_at_freelists.org
Subject: RE: More spfile goodness
Larry, yes, you can just delete the spfile.
PB
>=20
> I just had my first distasteful experience with spfile.
>=20
[snip]
=20
> So can we just rm this file?
>=20
> Thanks > Larry
=09
=09
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ********************************************************************** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination,=20 distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. ---------------------------------------------------------------- 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 Mon May 10 2004 - 14:05:44 CDT
 |
 |