LRM-00109: could not open parameter file
When trying to start up Oracle, the following error is encountered:
LRM-00109: could not open parameter file '...'
ORA-01078: failure in processing system parameters
Oracle could not open the init-ora file. Typically this is because either
the init-ora file is in a different directory to the one Oracle is looking
in, or it has a different name to what Oracle expects.
By default the init-ora file is located in the directory:
and is called:
ORACLE_SID = "<SID>"
PFILE_<SID> = <full pathname of init file>
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: Brian Cryer
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.