| indra |
Posted: Oct 29, 2007 03:48:09 AM |
Total Post: 20
Joined: Jan, 2007
|
I am getting this error while trying to open the database.
LRM-00109: could not open parameter file
'/oracle/app/ oracle/product/ 9.2.0.1.0/ dbs/initIFSD. ora'
> ORA-01078: failure in processing system parameters
>
Please help me.what should I do now?Why it has been showing? |
|
|
 Babu |
| Posted: Oct 29, 2007 07:15:15 AM |  |
|
Total Post: 90
Joined: Oct, 2007
|
Create pfile using spfile.
set oracle_sid=orcl
sqlplus "/as sysdba"
create pfile from spfile;
startup force.
|
|
|
|
|
| Billy |
| Posted: Oct 29, 2007 09:44:46 AM | |
|
Total Post: 8
Joined: Jun, 2007
|
Basically your pfile is corrupted, below listed steps would fix this problem.
1) Startup Database with sample parameter file
Location of sample file is '/oracle/app/oracle/product/admin/orcl/pfile/init.ora'
Before starting the database edit the file SID’s with IFSD.
2) Create SPFILE from PFILE;
It'll create a binaryfile on a default location(DBS folder).
3) Startup Force
On next startup it'll use the binary file(spfile)
e.g.
SQL> startup mount pfile="/oracle/app/oracle/product/admin/orcl/pfile/init.ora"
SQL> create spfile from pfile;
SQL> startup force
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
