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 18.104.22.168 and later
Information in this document applies to any platform.
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
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
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.
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