From oracle-l-bounce@freelists.org Thu Nov 11 03:35:24 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iAB9ZNk31758 for ; Thu, 11 Nov 2004 03:35:23 -0600 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 iAB9ZMa31747 for ; Thu, 11 Nov 2004 03:35:22 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8F87172DEA1; Thu, 11 Nov 2004 04:41:38 -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 25655-79; Thu, 11 Nov 2004 04:41:38 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B75C272DF76; Thu, 11 Nov 2004 04:41:37 -0500 (EST) Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Subject: Changing the spfile on 9.2.0.3 Date: Thu, 11 Nov 2004 11:40:55 +0200 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Changing the spfile on 9.2.0.3 Thread-Index: AcTH0opQYq1xkaXxSp+b6lEtcaJGEA== From: "Denham Eva" To: Content-Transfer-Encoding: 8bit X-archive-position: 12119 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: EVAD@TFMC.co.za Precedence: normal Reply-To: EVAD@TFMC.co.za X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Hello Folks I am trying to "update"/"change" the spfile with the edited init.ora file under pfile in admin. I start the database startup mount; Then use the CREATE SPFILE FROM PFILE='PATH\TO\INIT\PFILE\INIT.ORA'; But Oracle complains that the spfile is already in use. Must I use a different name ie change the name of spfile? OR can I update/alter spfile? OR is there something with the method? TIA Denham -- http://www.freelists.org/webpage/oracle-l