ORA-00372: file cannot be modified at this time

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 )

 

 643 views last month,  1 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply