CKPT: terminating instance due to error 204
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: CKPT: terminating instance due to error 204

  1. #1
    Join Date
    Sep 2000
    Posts
    362
    Hi,
    Today morning when I came to work I saw that the database was down and the following error was logged in the alert file.

    Tue Jun 12 03:45:55 2001
    CKPT: terminating instance due to error 204
    Instance terminated by CKPT, pid = 65

    I started the instance and it started successfully, but my question is why did it fail and what does this error mean.

    Please suggest.

    Thanks
    Anurag
    Appreciation is a wonderful thing;
    It makes what is excellent in others belong to us as well.


  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    The error suggests that there was an error reading the controlfile.

  3. #3
    Join Date
    Apr 2001
    Posts
    107
    Hi,

    oerr ora 204
    00204, 00000, "error in reading control file '%s' (block %s, # blocks %s)"
    // *Cause: Disk read failure of control file
    // *Action: Check if disk is online, if it is not, bring it online and try
    // warm start again. If it is, then need to recover disk.


    If you can access an UNIX server, you can retrieve the signification of oracle-based errors:
    just log as dba (belonging to the dba group), and type:

    oerr 'module' 'err#'

    for example, in your case:
    oerr ora 204

    cheers

    Fabien


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