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

Pete Sharman wrote:
> In article <PM0003A2F9A086FDE5_at_hades.none.local>, Lothar says...
>>
>>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.

[...]
> Create the spfile in the default directory and naming convention where
> Oracle
> expects it and Oracle will use it. The search mechanism if you just
> say STARTUP
> is the SPFILE, then the PFILE.
>

I did it:

create spfile from pfile='...';

so the spfile is created in the default location and it is used when I startup the database manually. But the automatic statup still uses the pfile.
When I say "show parameter spfile", the entry is empty. I think I'll try Klaus's solution.

Regards,
Lothar

-- 
Lothar Armbrüster       | la_at_oktagramm.de
Hauptstr. 26            | la_at_heptagramm.de
D-65346 Eltville        | lothar.armbruester_at_t-online.de