Ora-00206
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Ora-00206

  1. #1
    Join Date
    May 2001
    Location
    Delhi
    Posts
    340
    Hi,

    I check my alert file and found following error. On talking to my clleaues I found that some error occured in database and it was shutdown and again brought online. (I was on leave).

    Foll is the SID ALERT log.

    ************************************
    Dump file E:\oracle\P62\816\RDBMS\trace\p62ALRT.LOG
    Thu Dec 06 16:13:12 2001
    ORACLE V8.1.6.1.0 - Production vsnsta=0
    vsnsql=e vsnxtr=3
    Windows NT Version 4.0 Service Pack 6, CPU type 586
    Thu Dec 06 16:13:12 2001
    Errors in file E:\oracle\P62\816\RDBMS\trace\p62CKPT.TRC:
    ORA-00206: error in writing (block 3, # blocks 1) of controlfile
    ORA-00202: controlfile: 'L:\ORACLE\P62\SAPARCH\CNTRL\CNTRLP62.DBF'
    ORA-27072: skgfdisp: I/O error
    OSD-04008: WriteFile() failure, unable to write to file
    O/S-Error: (OS 21) The device is not ready.
    ORA-00206: error in writing (block 3, # blocks 1) of controlfile
    ORA-00202: controlfile: 'J:\ORACLE\P62\ORIGLOGA\CNTRL\CNTRLP62.DBF'
    ORA-27072: skgfdisp: I/O error
    OSD-04008: WriteFile() failure, unable to write to file
    O/S-Error: (OS 21) The device is not ready.
    ORA-00206: error in writing (block 3, # blocks 1) of controlfile
    ORA-00202: controlfile: 'M:\ORACLE\P62\SAPDATA1\CNTRL\CNTRLP62.DBF'
    ORA-27072: skgfdisp: I/O error
    OSD-04008: WriteFile() failure, unable to write to file
    O/S-Error: (OS 21) The device is not ready.


    Thu Dec 06 16:13:12 2001
    CKPT: terminating instance due to error 221
    Thu Dec 06 16:13:16 2001
    Errors in file E:\oracle\P62\816\RDBMS\trace\ORA00524.TRC:
    ORA-00600: internal error code, arguments: [12333], [7], [3], [54], [], [], [], []

    Thu Dec 06 16:13:16 2001
    Errors in file E:\oracle\P62\816\RDBMS\trace\ORA00312.TRC:
    ORA-00600: internal error code, arguments: [12333], [7], [3], [54], [], [], [], []

    Thu Dec 06 16:13:16 2001
    Errors in file E:\oracle\P62\816\RDBMS\trace\p62SMON.TRC:
    ORA-00221: error on write to controlfile

    Thu Dec 06 16:13:16 2001
    Errors in file E:\oracle\P62\816\RDBMS\trace\ORA00275.TRC:
    ORA-00600: internal error code, arguments: [12333], [7], [4], [195], [], [], [], []

    Thu Dec 06 16:13:16 2001
    Errors in file E:\oracle\P62\816\RDBMS\trace\ORA00476.TRC:
    ORA-00221: error on write to controlfile
    ORA-00221: error on write to controlfile

    Thu Dec 06 16:13:16 2001
    Errors in file E:\oracle\P62\816\RDBMS\trace\ORA00075.TRC:
    ORA-00221: error on write to controlfile

    Thu Dec 06 16:13:16 2001
    Errors in file E:\oracle\P62\816\RDBMS\trace\ORA00347.TRC:
    ORA-00221: error on write to controlfile

    Thu Dec 06 16:13:16 2001
    Errors in file E:\oracle\P62\816\RDBMS\trace\ORA00481.TRC:
    ORA-00221: error on write to controlfile

    Thu Dec 06 16:13:16 2001
    Errors in file E:\oracle\P62\816\RDBMS\trace\ORA00570.TRC:
    ORA-00221: error on write to controlfile

    Thu Dec 06 16:13:16 2001
    Errors in file E:\oracle\P62\816\RDBMS\trace\ORA00475.TRC:
    ORA-00221: error on write to controlfile

    Thu Dec 06 16:13:16 2001
    Errors in file E:\oracle\P62\816\RDBMS\trace\ORA00626.TRC:
    ORA-00221: error on write to controlfile

    ****************************
    SIDSMON.TRC

    *** SESSION ID:(4.7) 2001-12-06 16:13:12.843
    *** 2001-12-06 16:13:12.843
    SMON: following errors trapped and ignored:
    ORA-00221: error on write to controlfile

    ***********************************
    SIDDBW0.TRC
    *** 2001-12-06 16:13:15.781
    *** SESSION ID:(2.1) 2001-12-06 16:13:13.890
    error 221 detected in background process
    ********************************
    I also found that this kind of error had occured earlier also in Sept and July.

    What should I do. Any precaution to be taken .

    --------------------------
    The Time has come ....

  2. #2
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    Looks like a hardware problem involving I/O.
    Get a hardware expert.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

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