Oracle Error Message
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Oracle Error Message

  1. #1
    Join Date
    Sep 2000
    Posts
    56
    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

  2. #2
    Join Date
    Sep 2000
    Posts
    56
    OOPS THE DATABASE IS RUNNING ON WINDOWSN/T & ORACLE VERSION IS 8.1.6

  3. #3
    Join Date
    Sep 2000
    Posts
    56

    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




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width