| bottom-link"> | | | | 'D:\ORACLE\ORA92\DATABASE\INITGPT2.ORA' |
| Article explains solution of LRM-00109 error while | | | | System will generate error for creating spfile because |
| starting database. | | | | required init.ora doesn't available. Means you will get |
| When user got following errors to gather it is may be | | | | error. But your command "create spfile from pfile" will |
| due to some mismatch with server parameter file | | | | be generating new empty spfile and it will be |
| (spfile) and parameter file (init.ora). Generally these | | | | overwriting existing spfile. Means your current spfile |
| errors are occurring due to not exist of pfile or spfile | | | | has been washed and becoming empty. After getting |
| on system. May be oracle doesn't find out parameter | | | | this error if you are trying to restart your database |
| file in default location. Or may be file there but contents | | | | then you will get actual following error due to spfile file |
| of file is wipe off. There are so many reasons for | | | | is empty. |
| getting ORA-01078 with LRM-00109 errors to gather. If | | | | SQL> startup |
| you get only ORA-01078 then it is indication of wrong | | | | ORA-01078: failure in processing system parameters |
| parameter configuration. But when you get both errors | | | | LRM-00109: could not open parameter file |
| simultaneously is indicating problem of parameter file | | | | 'D:\ORACLE\ORA92\DATABASE\INITGPT2.ORA' |
| server parameter file existence. In this article we can | | | | How to resolve ORA-01078 with LRM-00109 |
| see how error will be generating and how it gets | | | | error? |
| resolved. | | | | For resolving this error, you should need to replace |
| SQL> conn /as sysdba | | | | init.ora or spfile if you have backup of same files. If you |
| Connected to an idle instance. | | | | don't have backup then go to alert.log and copy all |
| SQL> startup | | | | parameters in one file and save as "init.ora". Modify |
| ORA-01078: failure in processing system parameters | | | | same init.ora with some parameters which need single |
| LRM-00109: could not open parameter file | | | | quotation mark " ' " like |
| 'D:\ORACLE\ORA92\DATABASE\INITGPT.ORA' | | | | background_dump_dest,controlfiles,db_name etc. |
| Reason: Server parameter file or parameter file | | | | Connect as sysdba in SQL*Plus and execute |
| doesn't available:: | | | | command "create spfile from pfile". This command will |
| Some times error ORA-01078 is coming with | | | | generate again your server parameter file (spfile) in |
| LRM-00109. It is due to either spfile or init.ora doesn't | | | | system which needs to be starting database. Means |
| available in required path. If database is running with | | | | creating new spfile or pfile will solve error of |
| spfile and there is no init.ora available in system. If | | | | LRM-00109 error with ORA-01078 error. When you |
| Oracle dba execute following command in SQL*Plus | | | | got error check first default location for same files |
| for creating spfile.ora (which already there in system | | | | exist or not. If you don't find out any of files then |
| but init.ora doesn't in system). | | | | re-create it. If you find out any of one file then check |
| SQL>create spfile from pfile; | | | | exact location and try to open database using "startup |
| * | | | | pfile=' '" command. Does it working or not? If it is |
| ERROR at line 1: | | | | working then create spfile from it. Or create pfile from |
| ORA-01078: failure in processing system parameters | | | | alert.log file is last solution to resolve ORA-01078 with |
| LRM-00109: could not open parameter file | | | | LRM-00109 error. |