From oracle-l-bounce@freelists.org Fri May 7 04:49:02 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i479mlA14187 for ; Fri, 7 May 2004 04:48:57 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i479mb614160 for ; Fri, 7 May 2004 04:48:47 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3598C72CB03; Fri, 7 May 2004 04:39:16 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26647-40; Fri, 7 May 2004 04:39:16 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 81BB672C9BE; Fri, 7 May 2004 04:39:15 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 07 May 2004 04:38:01 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8601872C9A7 for ; Fri, 7 May 2004 04:38:00 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26686-12 for ; Fri, 7 May 2004 04:38:00 -0500 (EST) Received: from mail009.syd.optusnet.com.au (mail009.syd.optusnet.com.au [211.29.132.64]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1B99572C99E for ; Fri, 7 May 2004 04:37:59 -0500 (EST) Received: from dcs001 (c211-30-91-186.belrs3.nsw.optusnet.com.au [211.30.91.186]) by mail009.syd.optusnet.com.au (8.11.6p2/8.11.6) with SMTP id i479q3m15772 for ; Fri, 7 May 2004 19:52:03 +1000 Message-ID: <01b101c43418$f40f2830$9b00a8c0@dcs001> From: "Nuno Souto" To: References: <564DE4477544D411AD2C00508BDF0B6A1CE0AB18@usahm018.exmi01.exch.eds.com> <015b01c4337c$40e61bc0$9b00a8c0@dcs001> <409A78C0.1ACC27EE@sun.com> Subject: Re: More spfile goodness Date: Fri, 7 May 2004 19:34:20 +1000 MIME-Version: 1.0 Content-type: text/plain; charset=Windows-1252 Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 82 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: dbvision@optusnet.com.au Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org I thought the suggestion was that whatever needs to be communicated between instances be kept in the control file. Not that ALL parameters should end up in the control file? Cheers Nuno Souto in sunny Sydney, Australia dbvision@optusnet.com.au ----- Original Message ----- From: "Daniel Fink" > 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. > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------