Cry about...
Oracle Troubleshooting

ORA-01078: failure in processing system parameters


When attempting to start (or mount) the database the following error is generated:

ORA-01078: failure in processing system parameters


This error indicates that Oracle had a problem processing the database initialisation file. It will normally be accompanied by another error that will give more specific details about the problem.


Resolve the accompanying error and try the operation again. It will normally be reasonably obvious from the accompanying error which initialisation parameter is causing the problem.

This page represents one page of many pages of notes I made whilst working with Oracle 7 through to 10i. I now no longer work with Oracle databases, but hope that these notes will continue to be of benefit to others.

About the author: is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.