Re: Using the SPFILE

From: Tim Arnold <timkarnold_at_comcast.net>
Date: Sat, 7 Jun 2003 08:50:28 -0100
Message-ID: <hGKdnam7LfK_QnyjXTWcrg@comcast.com>

"Lothar Armbruester" <lothar.armbruester_at_t-online.de> wrote in message news:PM0003BF74B29B114E_at_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
>

Also, remove the registry entry for PFILE Received on Sat Jun 07 2003 - 04:50:28 CDT