-
SPFILE was deleted accidentially :(
Hi experts,
I have a problem with my spfile. I was deleted (accidentially).
Now I use my PFILE (initCAROL1.ora) to start it up, but... I want my spfile back.
I tried
create spfile from pfile;
and also tried doing it with the whole path
create SPFILE= 'the path' from PFILE= 'the path';
but all I got was this error message:
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'C:\ORACLE\ORA92\DATABASE\INITCAROL1.ORA'
Please help...
Thanks much...
Carol
-
make sure your environment is setup correctly and that the path is indeed correct. 'C:\ORACLE\ORA92\DATABASE\INITCAROL1.ORA'
-
Is it problem with spfile or pfile? Your error message shows problem with pfile.
If problem with pfile, then
shutdown
and
startup
create pfile from spfile;
if problem with spfile, then
shutdown
and
startup pfile=
create spfile from pfile;
Thanks and Regards,
Satheesh Babu.S
-
Thanks a lot!!
I put in the wrong path (duuh...).
I tried again with the right SPFILE file name (which is SPFILECAROL1.ora ) and it worked like a charm.
-Carol-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|