Re: cannot identify data file 1

From: Steve Rafferty <sraffert_at_umabnet.umab.edu>
Date: 14 Apr 1999 13:34:42 GMT
Message-ID: <7f25hi$5bq$1@list.umaryland.edu>

Connor McDonald (mcdonald.connor.cs_at_bhp.com.au) wrote:

: > I have a database (Oracle 8.0.3 running on Solaris2.6)
: > which suddenly refuses to open with the message
: >
: > cannot identify data file 1 - file not found
: >
: > it then provides the full path to the file it can't
: > find -- the path and filename are correct and the
: > file is there.
: >
: > A colleague has suggested that the problem may be that
: > the datafile has become too large
: >
: > 2215428096 Apr 12 07:01 system01.dbf

: > Does this sound like a reasonable explanation of why
: > the database won't open? other thoughts?

: Things to check:
:
: a. permissions on directory and the file
: b. is the size of the file on disk the same as the file in v$datafile

I checked the file permissions when the problem first occurred -- everything is as it should be.

Bytes in v$datafile is 0 (server reference indicates that 0 in

                          this column indicates the file is
                          inaccessible)

Steve Received on Wed Apr 14 1999 - 08:34:42 CDT

Re: cannot identify data file 1 - file not found