Re: how i recover my database

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

No need for panic or recovery.

Go to your \admin\<sid>\pfile directory and copy the init.ora file to C:\ORACLE\PRODUCT\10.2.0\SREE\DATABASE\INITSREE.ORA.

I would highly recommend you
A. Learn to use RMAN and do so.
B. Create an SPFILE from the init file and use it.

As others have suggested ... never edit an spfile.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)