My Oracle Support Banner

Database Crashed With Error ORA-00372: File Cannot Be Modified At This Time (Doc ID 2556704.1)

Last updated on JANUARY 30, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

Database is crashed with ORA-00372. Below is the snippet from the alert log entries. 

Errors in file /<path>/..dbw4_38303.trc:
ORA-00372: file 34 cannot be modified at this time
ORA-01110: data file 34: '/<path>/...261.1006858737'
Errors in file/<path>/.._dbw4_38303.trc  (incident=720831):

USER (ospid: 38316): terminating the instance due to error 372
2019-05-24T00:10:32.404024+03:00
System state dump requested by (instance=1, osid=38316 (DBW7)), summary=[abnormal instance termination].
System State dumped to trace file/<path>/..diag_38264_20190524001032.trc

Changes

No changes

Reported datafile is in ONLINE status and available at disk level. There is no issue with datafile. No corruption found.

Trace files shows One of the DML (insert/update) query is intermittently failing with ORA-00372 error.

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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