Also doesn't hurt to have a backup of the spfile hanging around, just in = case. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- From: Ruth Gramolini [mailto:rgramolini@xxxxxxxxxxxxxxx] Sent: Wednesday, May 05, 2004 9:43 AM To: oracle-l@xxxxxxxxxxxxx Subject: RE: More spfile goodness I have been told by Oracle Support that you really don't need an spfile. There is nothing wrong with using the init.ora and that is what we do. = If you use OEM to make a change to a parameter, it gives you a little box = that says don't forget to change your init.ora to reflect the change. It = says nothing about the spfile. I have found out the hard way that sometimes being on the bleeding edge or Oracle's new technology is = counter-productive. Just my $0.02, Ruth Gramolini Oracle DBA Vermont Department of Taxes -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Nuno Souto Sent: Wednesday, May 05, 2004 6:21 AM To: oracle-l@xxxxxxxxxxxxx Subject: Re: More spfile goodness ain't it a GREAT feature? Who the heck needs ANOTHER binary config file, Mr Oracle.... Cheers Nuno Souto in sunny Sydney, Australia dbvision@xxxxxxxxxxxxxxx ----- Original Message ----- From: "Niall Litchfield" <n-litchfield@xxxxxxxxxxxxxxxxxxxxxxx> > > This is apparently due to a corrupt spfile - per support. > ---------------------------------------------------------------- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------