Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!newspeer1.nwr.nac.net!newsfeed.freenet.de!news-lei1.dfn.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!newsmm00.sul.t-online.com!t-online.de!news.t-online.com!not-for-mail From: Lothar Armbruester Newsgroups: comp.databases.oracle.server Subject: Re: Using the SPFILE Date: Fri, 6 Jun 2003 22:54:23 +0200 Organization: T-Online Lines: 21 Message-ID: References: <7ls1evol8qll3ccthdmjru0i146ijf8b43@4ax.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: news.t-online.com 1054932826 04 24278 Op7VV-7VSbAC5J 030606 20:53:46 X-Complaints-To: usenet-abuse@t-online.de X-ID: S9OIf0ZXoebKbbAsl2q4EH-5dStgtip9A-fLMD2zVer5x3N-Pj7y88 User-Agent: Pineapple News 0.9.8 [PLAID BETA], BeOS (Intel) 5.0.3 X-Program-URL: http://www.beosdevelopers.org/brunsona/pineapplenews.html X-Registered-To: Lothar Armbruster Xref: core-easynews comp.databases.oracle.server:188925 X-Received-Date: Fri, 06 Jun 2003 13:54:28 MST (news.easynews.com) Peter wrote: > When you boot up your Windows machine, Oracle would start your > database instance. Oracle would use the init file in the pfile > directory. But what should I do so that it will automatically use the > spfile in the \oracle_home\database directory? > > I know "Startup open" will always the use the spfile in > \oracle_home\database directory. > Hello Peter, you can replace the line IFILE=... in the init.ora in the spfile directory with a line like this: SPFILE=... This should use the given spfile. Hope that helps, Lothar -- Lothar Armbrüster | la@oktagramm.de Hauptstr. 26 | la@heptagramm.de D-65346 Eltville | lothar.armbruester@t-online.de