Originally posted by davey23uk
i dont user an spfile, all changes I make in the init.ora are permanent.

So why do I need an spfile to make things permanent
I'd rather start my database by using STARTUP instead of the 3 commands:STARTUP NOMOUNT PFILE=..., ALTER DATABASE MOUNT, ALTER DATABASE OPEN.