Converting between SPFILE or PFILE

Posted by ITsiti — July 21, 2012 in ORACLE — 2 Comments

You can convert the SPFILE and PFILE on each by executing below commands

Convert to SPFILE from PFILE

 
SQL> create SPFILE from PFILE;

SQL> create PFILE from SPFILE;

Pranjal Tiwari says:
January 2, 2013 at 6:53 pm
I have below queries related to this post:
1. Which file is the main (primary) pfile or spfile?
2. Why spfile to pfile conversion is needed when we could not edit spfile (binary) and we always edit the pfile content?
Kindly help.
Reply
1. Siti says:
  January 2, 2013 at 10:05 pm
  1. Which file is the main (primary) pfile or spfile?
  SPFILE are available since Oracle 9i and above. I cannot tell which one is the main here but i’d say we should using the SPFILE since it’s newer and having more advantages than PFILE
  2. Why spfile to pfile conversion is needed when we could not edit spfile (binary) and we always edit the pfile content?
  It’s for backup purposes. You’ll have a backup of the SPFILE/PFILE.
  Reply