Xref: alice comp.databases.oracle.misc:28932
Path: alice!news-feed.fnsi.net!netnews.com!feed1.news.rcn.net!rcn!chippy.visi.com!news-out.visi.com!cam-news-hub1.bbnplanet.com!washdc3-snf1!news.gtei.net!news.ums.edu!news.umaryland.edu!not-for-mail
From: sraffert@umabnet.umab.edu (Steve Rafferty)
Newsgroups: comp.databases.oracle.misc
Subject: Re: cannot identify data file 1 - file not found
Date: 14 Apr 1999 13:34:42 GMT
Organization: University of Maryland, Baltimore
Lines: 33
Message-ID: <7f25hi$5bq$1@list.umaryland.edu>
References: <7evtgc$k4t$1@list.umaryland.edu> <37142D68.21B0@bhp.com.au>
X-Newsreader: TIN [UNIX 1.3 950824BETA PL0]

Connor McDonald (mcdonald.connor.cs@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