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 Sudden Crash

939393Nov 7 2011 — edited Nov 8 2011

Hi All,

My DB Version: 10.2.0
OS Version: Windows Server 2003

During Normal Working Suddenly DB Crash and the error in log file is like that

Errors in file c:\oracle\product\10.2.0\admin\tsi\bdump\tsi_dbw0_7608.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01114: IO error writing block to file 18 (block # 5285)
ORA-01110: data file 18: 'E:\CAT\IN_OCT17.DBF'
ORA-27072: File I/O error
OSD-04008: WriteFile() failure, unable to write to file
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file.

Can anyone tell me what is the reason of this happening.

Regards,

Vikas Kohli

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 6 2011

Added on Nov 7 2011

#general-database-discussions

5 comments

355 views