Skip to Main Content

Database Software

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!

Tool to Edit SPFILE Offline

Matheus BoesingJul 2 2016

Actually the only way to edit a SPFILE is through an online database.

But if you made a mistake scope SPFILE, get the database down and then database is not starting up?

You actually need to find an old spfile or a “parallel” pfile (or build one) to get database up again, once you cannot simply “edit” the spfile to fix your mistake.

Why not?

Comments
Post Details
Added on Jul 2 2016
5 comments
4,517 views