CKPT: terminating instance due to error 204

[anuragmin]

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

[Halo]

The error suggests that there was an error reading the controlfile.

[shadow21]

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