|
|
 |
|
|
How to resolve LRM-00109 with ORA-01078 errors? by Gitesh Trivedi
|
|
|
How to resolve LRM-00109 with ORA-01078 errors? |
|
|
|
|
|
Software
|
|
When user got following errors to gather it is may be due to some mismatch with server parameter file (spfile) and parameter file (init.ora). Generally these errors are occurring due to not exist of pfile or spfile on system. May be oracle doesn't find out parameter file in default location. Or may be file there but contents of file is wipe off. There are so many reasons for getting ORA-01078 with LRM-00109 errors to gather. If you get only ORA-01078 then it is indication of wrong parameter configuration. But when you get both error simultaneously is indicating problem of parameter file/server parameter file existence. In this article we can see how error will be generating and how it gets resolved.
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'D:\ORACLE\ORA92\DATABASE\INITGPT.ORA'
Reason: Server parameter file or parameter file doesn't available::
Some times error ORA-01078 is coming with LRM-00109. It is due to either spfile or init.ora doesn't available in required path. If database is running with spfile and there is no init.ora available in system. If Oracle dba execute following command in SQL*Plus for creating spfile.ora (which already there in system but init.ora doesn't in system).
SQL>create spfile from pfile;
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'D:\ORACLE\ORA92\DATABASE\INITGPT2.ORA'
System will generate error for creating spfile because required init.ora doesn't available. Means you will get error. But your command "create spfile from pfile" will be generating new empty spfile and it will be overwriting existing spfile. Means your current spfile has been washed and becoming empty. After getting this error if you are trying to restart your database then you will get actual following error due to spfile file is empty.
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'D:\ORACLE\ORA92\DATABASE\INITGPT2.ORA'
How to resolve ORA-01078 with LRM-00109 error?
For resolving these error, you should need to replace init.ora or spfile if you have backup of same files. If you don't have backup then go to alert.log and copy all parameters in one file and save as "init.ora". Modify same init.ora with some parameters which need single quotation mark " ' " like background_dump_dest,controlfiles,db_name etc. Connect as sysdba in SQL*Plus and execute command "create spfile from pfile". This command will generate again your server parameter file (spfile) in system which needs to be starting database.
Means creating new spfile or pfile will solve error of LRM-00109 error with ORA-01078 error. When you got error check first default location for same files exist or not. If you don't find out any of files then re-create it. If you find out any of one file then check exact location and try to open database using "startup pfile=' '" command. Does it working or not? If it is working then create spfile from it. Or create pfile from alert.log file is last solution to resolve ORA-01078 with LRM-00109 error.
About The Author: Gitesh Trivedi is an Expert Oracle DBA and working in Dbametrix. He has excellent 12 years experience. You can reach him on site http://www.dbametrix.com offers Remote DBA support and Offshore Oracle DBA support. All copyright reserved by @Dbametrix. Contact mailto:info@dbametrix.com or at http://www.dbametrix.com/service.html
Related Articles -
LRM-00109, ORA-01078, oracle dba tips, ,
|
Rate This Article  |
|
|
|
|
|
Do you Agree or Disagree? Have a Comment? POST IT!
| Reader Opinions |
|
|
|
|
|
|
|
|
|
| Author Login |
|
|
 |
Advertiser Login
ADVERTISE HERE NOW!
Limited Time $60 Offer!
90 Days-1.5 Million Views
|
|
TIM FAY
After 60-plus years of living, I am just trying to pass down some of the information that I have lea...more
|
|
|
|
|
LAURA JEEVES
At LeadGenerators, we specialise in content-led Online Marketing Strategies for our clients in the t...more
|
|
|
|
|
ALEX BELSEY
I am the editor of QUAY Magazine, a B2B publication based in the South West of the UK. I am also the...more
|
|
|
|
|
GENE MYERS
Author of four books and two screenplays; frequent magazine contributor. I have four other books "in...more
|
|
|
|
|
SUSAN FRIESEN
Located in the lower mainland of B.C., Susan Friesen is a visionary brand strategist, entrepreneur, ...more
|
|
|
|
|
STEPHEN BYE
Steve Bye is currently a fiction writer, who published his first novel, ‘Looking Forward Through the...more
|
|
|
|
|
SHALINI MITTAL
A postgraduate in Fashion Technology. Shalini is a writer at heart! Writing for her is an expression...more
|
|
|
|
|
ADRIAN JOELE
I have been involved in nutrition and weight management for over 12 years and I like to share my kn...more
|
|
|
|
|
JAMES KENNY
James is a Research Enthusiast that focuses on the understanding of how things work and can be impro...more
|
|
|
|
