How to Create Pfile from Spfile and Vice Versa

<<Back to DB Administration Main Page

There are instances when a DBA need to start the database using pfile, for example to trouble an instance startup error or to validate init file post parameter changes etc.
In such situations you can create a pfile from spfile and once you are done with your changes you can create spfile from updated/modified pfile to start the database.

How to Create Pfile from Spfile

As sysdba execute following command 

SQL> create pfile='/tmp/initOrcl.ora' from spfile;

How to Create SPfile from Pfile

As sysdba execute following command 

SQL> create spfile from  pfile='/tmp/initOrcl.ora';

You can also create the pfile directly from memory

How to Create Pfile from Memory

As sysdba execute following command 

SQL> create  pfile='/tmp/initOrcl.ora' from memory;