Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database won't open: ORA-27037: unable to obtain file status

391322Mar 31 2003 — edited Mar 31 2003

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.

Any suggestions are most welcome.

thanks
Scott

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 28 2003

Added on Mar 31 2003

#general-database-discussions

1 comment

748 views