Re: Using the SPFILE

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
Received on Sat Jun 07 2003 - 14:41:19 CDT