I have shut down my Oracle 8.17 database (shutdown immediate;). Now when I
try to startup, the database mounts, but won't open.

Mon Mar 31 14:51:00 2003
ALTER DATABASE OPEN
Mon Mar 31 14:51:00 2003
Errors in file /orahome/admin/dev/bdump/dbw0_20256.trc:
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: '/oradb/oradata/dev/temp01.dbf'
ORA-27037: unable to obtain file status
Linux Error: 75: Value too large for defined data type
Additional information: 3

ORA-27037: unable to obtain file status
Cause: Stat system call returned an error. Additional information indicates
which function encountered the error.
Action: Examine errno.

Note that the problem is with the temp01.dbf datafile, which is associated
to the temporary tablespace, so a solution my involve removing the current
data file. Any suggestions are most welcome.

thanks
Scott
Oracle LazyDBA home page