Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Switching from pfile to spfile

mohitanchliaMay 28 2010 — edited May 28 2010

Oracle 11.0.1.7:

Have a basic question. We got a new DB but it currently is using pfile. I mean spfile parameter is BLANK or NULL. How can I make the change such that Oracle starts to use spfile? I created spfile using create spfile but when I try to alter spfile parameter I get the following:

SQL> alter system set spfile='/u01/app/oracle/product/11.1.0.7/dbs/spfileprf01.ora' scope=both;
alter system set spfile='/u01/app/oracle/product/11.1.0.7/dbs/spfileprf01.ora' scope=both
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-32019: The parameter SPFILE cannot be updated in the server parameter file.

I can update in memory though.

Another question I have is when Oracle starts up how does it know if it should use spfile or pfile?

This post has been answered by sb92075 on May 28 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 25 2010

Added on May 28 2010

#general-database-discussions

3 comments

5,026 views