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!

ORA-00845: pfile is working but not spfile

user10427867Jan 5 2012 — edited Jan 9 2012

I have a 11.2.0.2 database. When I startup the database using the spfile, I got the ora-00845 error (MEMORY_TARGET not supported on this system). Then I tried to startup the database using the pfile. It worked! No problem. Then I created a new spfile using the current pfile. Shutdown the database and tried to startup using the spfile again. No luck. I still have this error. Why would the pfile work and not the spfile?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 6 2012

Added on Jan 5 2012

#general-database-discussions

17 comments

1,890 views