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 -> Unable to open database

Unable to open database

From: Tore Skogly <tore.skogly_at_sensewave.com>
Date: Wed, 07 Aug 2002 16:19:56 GMT
Message-ID: <6bhria.183.ln@ypsilon>


I am experiencing a (to me) major problem with one of my databases. When trying to start the database I am only able to mount it, not open it.

When I use srvmgrl and run startup I get this error message: ORA-01157: (some error message) not able to open file ORA-01110: (the name of the file).
The file that is reported to be the problem is one used by a tablespace containing indexes.

I have "inherited" this database from another DBA, and it is an Oracle 8.0.4 running on HP-UX. For our datafiles we use raw devices, so the device that seems to cause the problem is /dev....
I am not sure what has caused this to occur - and even less able to solve it...

Anyone who can give me a clue on how to solve this one? I am not very used to working with raw devices, so this is making the scene even more complicated.

Any help is appreciated.

Regards,
Tore Skogly, Norway Received on Wed Aug 07 2002 - 11:19:56 CDT

Original text of this message

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