Oracle provides two different types of mutually
exclusive parameter files that you can use, PFILE and SPFILE. Let?s look at the
PFILE and the SPFILE in a bit more detail.
Tip! - Making a PFILE when Oracle will not start
SQL> connect system/manager as sysdba
SQL> create pfile='C:\ora\pfile\init.ora'
File Created.
Now edit the pfile in notepad to make the changes need to
allow Oracle to start.
Finally, start the database using the pfile you just
edited:
SQL startup pfile='C:\ora\pfile\init.ora';
SQL create spfile from pfile='C:\ora\pfile\init.ora'
