Re: Oracle 9i does not use spfile on W2k?

From: Klaus Zeuch <nospKZeuch_at_hotmail.com>
Date: Sun, 9 Jun 2002 21:28:36 +0200
Message-ID: <ae0a97$6da$06$1@news.t-online.com>

"Lothar Armbruester" <lothar.armbruester_at_t-online.de> schrieb im Newsbeitrag news:PM0003A2F9A086FDE5_at_hades.none.local...
> Hello out there,
> yesterday we installed Oracle 9i on a W2k Server. I created a spfile
> from the init.ora and it is used when I startup the database from
> SQL*Plus but it is not used when the database is started automatically
> after server reboot.
> The documentation (Administrator's Guide for Windows) describes the use
> of oradim which can be used to make an instance startup automatically
> but it does not even mention the spfile. Oradim has a pfile parameter
> but none regarding spfile (at least not in the docs).
> Now the question is what can I do to make the automatic startup use the
> spfile instead of the init.ora?

Create your pfile containing only one line:

SPFILE=/... Klaus Received on Sun Jun 09 2002 - 14:28:36 CDT