To create and spfile do the following:
1. sqlplus sys/ehealth as sysdba
2. Edit initEHEALTH.ora
3. just under the only IFILE entry place make reference to the newly created spfile by adding the following entry:
4. Stop and start the eHealth database to load the spfile at startup.
nhStopDb immediate / nhStart
How to create an Oracle System Parameter file (spfile) on Windows
"ALTER SYSTEM SET" does not complete with Oracle error "ORA-32001 write to SPFILE requested but no SPFILE specified at startup"
Microsoft Windows 2003
Replace $ORACLE_HOME variables in this article with the literal path on the file system e.g.CREATE SPFILE='E:\oracle\Oracle.9.2\databaseeHealth_spfile.ora'
The spfile is not created by default. An spfile can be created from a pfile. The naming convention for the pfile is init<SID>.ora. The default location for the pfile is $ORACLE_HOME\database\initEHEALTH.ora. The pfile is the default location where Oracle loads parameters from at startup.
(Legacy KB ID CNC TS33583 )