My Oracle Support Banner

Disk I/O Contention/Slow Can Lead to ORA-239 and Instance Crash (Doc ID 1068799.1)

Last updated on FEBRUARY 15, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2]
Oracle Database - Enterprise Edition - Version to [Release 10.2 to 11.1]
Oracle Database - Enterprise Edition - Version to [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 01-Jul-2016***


The following error occurred and the instance was terminated.


Tue Feb 23 04:12:23 2010
Thread 1 cannot allocate new log, sequence 15947
Checkpoint not complete
Current log# 1 seq# 15946 mem# 0: /oradata/CNOPRPT0/redo01.log
Errors in file /oracle/diag/rdbms/cnoprpt01/CNOPRPT01/trace/CNOPRPT01_lgwr_2307.trc (incident=432582):
ORA-00239: timeout waiting for control file enqueue: held by 'inst 1, osid 2309' for more than 900 seconds
Incident details in: /oracle/diag/rdbms/cnoprpt01/CNOPRPT01/incident/incdir_432582/CNOPRPT01_lgwr_2307_i432582.trc
ORA-603 : opidrv aborting process LGWR ospid (2307_3545232)
Tue Feb 23 04:12:29 2010
Errors in file /oracle/diag/rdbms/cnoprpt01/CNOPRPT01/trace/CNOPRPT01_pmon_2287.trc:
ORA-00470: LGWR process terminated with error
PMON (ospid: 2287): terminating the instance due to error 470
Instance terminated by PMON, pid = 2287


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.