-
I am getting the following error when the database is going down
KCF: write/open error block=0x3bc22 online=1
file=26 N:\ORACLE816\ORADATA\TEST\DATA11.ORA
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.'
DBW0: terminating instance due to error 1242
Mon Dec 18 11:50:20 2000
Instance terminated by DBW0, pid = 381
Dump file o:\oracle816\admin\test\bdump\testALRT.LOG
Bu when I stop the service & start the service I am able to access the database.Again after some more days the same message appears.Has anyone got any clue why it happens.If so what is the solution.All suggestions are welcome.How to keep the trace on
Thanks
Suresh
-
OOPS THE DATABASE IS RUNNING ON WINDOWSN/T & ORACLE VERSION IS 8.1.6
-
Solution Or Help Needed
These are the different error messages got in a span of 2 to 3 months.Please see that error message is same that is a portion of the file is locked only difference is that each time different files got locked
Fri Oct 20 03:57:23 2000
Errors in file o:\oracle816\admin\test\bdump\testCKPT.TRC:
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'O:\ORACLE816\ORADATA\TEST\CONTROL02.CTL'
ORA-27072: skgfdisp: 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.
Fri Oct 20 03:57:24 2000
CKPT: terminating instance due to error 221
Instance terminated by CKPT, pid = 286
Dump file o:\oracle816\admin\test\bdump\testALRT.LOG
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'O:\ORACLE816\ORADATA\TEST\CONTROL03.CTL'
ORA-27072: skgfdisp: 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.
Sat Oct 21 04:27:15 2000
CKPT: terminating instance due to error 221
Instance terminated by CKPT, pid = 302
Dump file o:\oracle816\admin\test\bdump\testALRT.LOG
Tue Oct 24 04:23:10 2000
Errors in file o:\oracle816\admin\test\bdump\testCKPT.TRC:
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'O:\ORACLE816\ORADATA\TEST\CONTROL01.CTL'
ORA-27072: skgfdisp: 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.
Tue Oct 24 04:23:10 2000
CKPT: terminating instance due to error 221
Instance terminated by CKPT, pid = 249
Dump file o:\oracle816\admin\test\bdump\testALRT.LOG
Fri Oct 27 01:11:42 2000
KCF: write/open error block=0x33005 online=1
file=16 J:\TEST\DATA10.ORA
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.'
DBW0: terminating instance due to error 1242
Instance terminated by DBW0, pid = 105
Dump file o:\oracle816\admin\test\bdump\testALRT.LOG
Fri Oct 27 08:34:40 2000
Fri Oct 27 01:11:42 2000
KCF: write/open error block=0x33005 online=1
file=16 J:\TEST\DATA10.ORA
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.'
DBW0: terminating instance due to error 1242
Instance terminated by DBW0, pid = 105
Dump file o:\oracle816\admin\test\bdump\testALRT.LOG
Fri Oct 27 08:34:40 2000
