Oracle terminated due to control file locked (Legacy KB ID CNC TS17012 )

Products

• CA eHealth

Issue/Introduction

This is also a common problem when using backup software. The backup utility locks the datafile, controlfile or logfile. When Oracle attempts to write to the file, the lock prevents it and the database crashes. Backup software should be configured so it does not lock open files. In this case, contact the third party vendor for information on how to not lock open files.

Related Issues/Questions:
Oracle terminated due to control file locked
System crashes
Oracle instance stops
From the $ORACLE_HOME\admin\bdump\{$ORACLE_SID}\alert_{$ORACLE_SID}.log file
Usually: $ORACLE_HOME\admin\bdump\EHEALTH\alert_EHEALTH.log

 

Example message:

 

Errors in $ORACLE_HOME\admin\bdump\ile c:\oracle\oracle.9.2\ehealth\ehealth_ckpt_1372.trc:

 

ORA-00221: error on write to controlfile
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: 'C:\EHEALTHDB\ORADATA\EHEALTH\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.

Problem Environment:
eHealth 5.5 and later
Oracle


(Legacy KB ID CNC TS17012 )

Environment

Release: ADVEVS99000-6-AdvantEDGE View standalone
Component: