Re: More spfile goodness

  • From: <jtesta@xxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 6 May 2004 14:00:46 -0400 (EDT)

Whats a catch-42, a catch-22 that's 20 years old?

now back to our regularly scheduled program.

joe

original message below



 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
-----------------------------------------------------------------

Other related posts: