| recreate parameter file on lost [message #463538] |
Thu, 01 July 2010 14:14 |
javeed.md
Messages: 1
Registered: July 2010
|
Junior Member |
|
|
recreate paramater file if u lost init.ora or spfile.ora
STEPS
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'D:ORACLEORA92DATABASEINITGPT2.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 and "dispatchers ......)". Connect as sysdba in SQL*Plus and execute command "create spfile from pfile=" or startup pfile or startup
all the best friends
regards
javeed
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
