"ALTER SYSTEM SET" does not complete with Oracle error ORA-32001 (Legacy KB ID CNC TS33583 )

Document ID : KB000051649
Last Modified Date : 14/02/2018
Show Technical Document Details
To create and spfile do the following:


1. sqlplus sys/ehealth as sysdba


>CREATE SPFILE='$ORACLE_HOME\database\eHealth_spfile.ora'
>FROM PFILE='$ORACLE_HOME\database\initEHEALTH.ora';
>exit


2. Edit initEHEALTH.ora


3. just under the only IFILE entry place make reference to the newly created spfile by adding the following entry:


SPFILE='$ORACLE_HOME\database\eHealth_spfile.ora'


4. Stop and start the eHealth database to load the spfile at startup.


nhStopDb immediate / nhStart



Related Issues/Questions:
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"

Problem Environment:
Microsoft Windows 2003
Oracle 9i
eHealth 6.0
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'

Additional Information:
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 )