Last updated on DECEMBER 15, 2016
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
***Checked for relevance on 15-Dec-2016***
Database crashes subsequent to following errors in the alert log:
error=27072 txt: '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.'
Errors in file d:\oracle\diag\rdbms\exc\exc\trace\exc_dbw4_692.trc:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01114: IO error writing block to file 32 (block # 3746957)
ORA-01110: data file 32: 'D:\ORACLE\ORADATA\EXC\RMS_DF13'
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.
DBW4 (ospid: 692): terminating the instance due to error 1242
Thu Jan 26 15:28:30 2012
Error occured while spawning process m000; error = 1242
Instance terminated by DBW4, pid = 692
Restarting the Database resolves the issue temorarily. This error eventually reoccurs and Database crashes again.
- DB Verify has been run on the affected datafile but reported no corruption.
- Could not identify the process holding the lock on the file using:
tlist, command line interface (downloadable from the windows resource kit).
Process Explorer, from Microsoft previous sysinternals.
- No anti-virus software was running.
- Windows Check Disk did not detect any bad sectors on the disk.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms