I got ” ORA-00372: file cannot be modified at this time ” error in Oracle database.
ORA-00372: file cannot be modified at this time
Details of error are as follows.
$ oerr ora 372 00372, 00000, "file %s cannot be modified at this time" // *Cause: attempting to modify the contents of a file that cannot be // modified. The file is most likely part of a read only tablespace // but may be in the process of going offline, or the database may // be in the process of closing. // *Action: check the status of the file and its tablespace
file %s cannot be modified at this time
This ORA-00372 is related with the attempting to modify the contents of a file that cannot be modified. The file is most likely part of a read only tablespace but may be in the process of going offline, or the database may be in the process of closing.
check the status of the file and its tablespace.
ORA-372 is occurred on temporary tablespace though it is ONLINE status :
ORA-00372: file 999 cannot be modified at this time ORA-01110: data file 999: '/<PATH>/temp01.dbf' About ORA-372 : $ oerr ora 372 00372, 00000, "file %s cannot be modified at this time" // *Cause: attempting to modify the contents of a file that cannot be // modified. The file is most likely part of a read only tablespace // but may be in the process of going offline, or the database may // be in the process of closing. // *Action: check the status of the file and its tablespace
However, DBA_TABLESPACES.STATUS of temporary tablespace is neither “OFFLINE” nor “READ ONLY”, but “ONLINE”.
The issue is due to the below bugs:
BUG 26280704 – ORA-00372: ON TEMP TABLESPACE
Unpublished BUG 30293935 – TRACKING BUG FOR LRG 22002464 (ORA-00372: ON TEMP TABLESPACE)
BUG:26280704 – fix the error code
BUG:30293935 – fix temporary tablespace allocation
Apply both Patch:26280704 and Patch:30293935 to your environment.
or
apply DBRU 19.7 or above
Second case is as follows.
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
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.
Issue symptoms are matching to bugs Bug 29533604 and Bug 28338982 which are closed as duplicate to Bug 26126424
Apply the patch 26126424
Do you want to learn Oracle Database for Beginners, then read the following articles.
Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )