Re: Unable to open database

Tore Skogly <tore.skogly_at_sensewave.com> wrote in message news:<6bhria.183.ln_at_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

One reason could be is if your raw device or any symbolic link to it is not owned by Oracle or is not in dba group.

> I am not very used to working with raw devices

Before doing anything, I would recommend you ask for help from someone at your work who is familiar with raw devices.

//Rauf Sarwar Received on Wed Aug 07 2002 - 19:31:20 CDT