| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Unable to open database
It was not just 'some error message' it was very specific as to the problem..
Cause:The background process was not able to find one of the data files. The database will prohibit access to this file but other files will be unaffected. However, the first instance to open the database will need to access all online data files. Accompanying messages from the operating system will describe why the file was not found.
Action:Make the file available to database. Then either open the database or do ALTER SYSTEM CHECK DATA FILES.
If you are not used to raw devices and their relationship to file identifiers, find someone who knows the system to check it out.
Tore Skogly <tore.skogly_at_sensewave.com> wrote:
>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
-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Wed Aug 07 2002 - 12:02:44 CDT
 |
 |