Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Using the SPFILE

Re: Using the SPFILE

From: Lothar Armbruester <lothar.armbruester_at_t-online.de>
Date: Fri, 6 Jun 2003 22:54:23 +0200
Message-ID: <PM0003BF74B29B114E@hades.none.local>


Peter wrote:
> When you boot up your Windows machine, Oracle would start your
> database instance. Oracle would use the init file in the <SID\>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_at_oktagramm.de
Hauptstr. 26            | la_at_heptagramm.de
D-65346 Eltville        | lothar.armbruester_at_t-online.de
Received on Fri Jun 06 2003 - 15:54:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US