Good point. On AIX with RAC you have to have an init.ora that points to the spfile so you can find it. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Daniel Fink Sent: Thursday, May 06, 2004 1:41 PM To: oracle-l@xxxxxxxxxxxxx Subject: Re: More spfile goodness Ah, the chicken or the egg... Control files are identified by the parameter (spfile/init.ora) file. If you kept the parameters in the control file, how would the database know which control files to read? And if a control file was lost? How would you edit the control file to change the parameter to point to a different control file? Sounds like a catch-42. Regards, Daniel in sunny Denver, Colorado Nuno Souto wrote: > Why complicate things indeed? If it had to be a binary file, > it could well have been the control file as you suggest. > All this spfile/pfile rigmarole is just an unnecessary > and unwarranted complication. But it's great to generate > revenue out of OCP training... > Cheers > Nuno Souto > in sunny Sydney, Australia > dbvision@xxxxxxxxxxxxxxx ---------------------------------------------------------------- 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 -----------------------------------------------------------------