Re: how i recover my database

"Frank van Bortel" <frank.van.bortel_at_gmail.com> wrote in message news:dqddvs$k5v$1_at_news5.zwoll1.ov.home.nl...
> srikanthpotluri wrote:
>> i am using oracle10.2.0 version on windowsXP.i open sp file once.
>> i got a proble to start a database..
>> the following two errors are comming ..
>> 1.ORA-01078: failure in processing system parameters
>> 2.LRM-00109: could not open parameter file
>> 'C:\ORACLE\PRODUCT\10.2.0\SREE\DATABASE\INITSREE.ORA'
>> how i recover my database could u help me any body
>> advance thanks
>> srikanth potluri
>>
>
> What did you do? Edit the spfile?!?
> As you found out, the spfile is a non-editable, binary
> copy (of the pfile, the human readable counterpart).
>
> You should have a pfile somewhere, and you could start
> with
> startup mount pfile=....
> where the '....' is the actual location of your pfile.
> --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...

And if Frank's assumption is correct, but you don't have a pfile anywhere, the 'non-editable' is 'mostly-editable', so you can trim the garbage from the top and tail, save the text parts as an init{yourSIDhere}.ora file, and use that in the pfile = command. (or rename the old spfile, and Oracle will choose an appropriately named init{SID}.ora file automatically.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
Cost Based Oracle: Fundamentals

http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 10th Jan 2006