Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how i recover my database

Re: how i recover my database

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sun, 15 Jan 2006 13:19:54 +0100
Message-ID: <dqddvs$k5v$1@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...
Received on Sun Jan 15 2006 - 06:19:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US