Re: Using the SPFILE

If you don't specify a PFILE or SPFILE on startup, then Oracle will look in %ORACLE_HOME%\database on Windows ($ORACLE_HOME/dbs on Unix). If it finds a SPFILE with the default name for your database, then it will use it. If that fails, it will look for an INIT.ORA with the default name and use that.

HTH,
Brian

Peter wrote:
>
> On Fri, 6 Jun 2003 22:54:23 +0200, Lothar Armbruester
> <lothar.armbruester_at_t-online.de> wrote:
>
> My default init file does not have an IFILE line. Don't know why.
> But now I only have a SPFILE line in my <SID\>pfile\init file that
> points to the SPFILE in \oracle_home\database directory. Looos like it
> works.
>
> Thanks
>
> >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

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"