Oracle: CKPT terminating instance due to error 221 (ORA-00221)
Friday, 09.02.2007 – DejanAko vam se instanca Oracle baze skrsi sa greskom iz naslova i ukoliko u alert logu pronadjete ovo:
(Na njemackom)
Wed Feb 07 22:44:32 2007
Errors in file c:ora10gadmindb10gbdumpdb10g_ckpt_55.trc:
ORA-00221: Fehler beim Schreiben in Kontrolldatei
ORA-00206: Fehler beim Schreiben (Block 3, Anzahl Blöcke 1) der Kontrolldatei
ORA-00202: Kontrolldatei: 'C:ORA10GORADATADB10GCONTROL03.CTL'
ORA-27072: Datei-I/O-Fehler
OSD-04008: WriteFile()-Fehler, in Datei kann nicht geschrieben werden
O/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file. Wed Feb 07 22:44:32 2007
CKPT: terminating instance due to error 221
(ili na engleskom)
Wed Feb 07 22:44:32 2007
Errors in file c:ora10gadmindb10gbdumpdb10g_ckpt_55.trc:
ORA-00221: error on write to controlfile
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'C:ORA10GORADATADB10GCONTROL03.CTL'
ORA-27072: File 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.Wed Feb 07 22:44:32 2007
CKPT: terminating instance due to error 221
onda je moguci uzrok tome anti-virusni software ili neki third-party software, koji vrsi odrzavanje sistemske particije (u ovom slucaju C: particija).
U mom slucaju je bilo oboje. Svako vece se vrsi skeniranje sistema anti-virusnim softwareom, a potom se vrsi automatski backup sistemske particije (neki alat za HP SAN storage), koji lockuje controlfile, nakon cega CKPT (Checkpoint process) terminira DB instancu.
Ako ne mozete izbjeci pokretanje tog anti-virusnog i backup softwarea, onda je rjesenje da controlfileove smjestite na neku nesistemsku particiju i necete imati ovakvih situacija. 🙂