-
Title
Post stopped due to "ORA-00372: file 14 cannot be modified at this time.ORA-01110: data file < -
Description
Post is stopped due to the following error:
08/20/06 19:36 Notice: ORA-00372: file 14 cannot be modified at this time.ORA-01110: data file 14: '<name>'. [sp_opst(osp)/876900]
08/20/06 19:36 Error: Unexpected Oracle error: ORA-00372: file 14 cannot be modified at this time.ORA-01110: data file 14: '<name>'. (object name: "owner"."tablename") [sp_opst (for o.SID1-o.SID2 queue queue_name)/876900]
08/20/06 19:36 Process exited sp_opst (for o.SID1-o.SID2 queue queue_name) [pid = 876900] - exit(1) event_log (57/57) -
Cause
There some issues with the datafile mentioned in the Oracle error.
-
Resolution
If there are any issues with the datafile that is being accessed during the time Post is applying changes to an object, it will cause Post to stop due to ORA-00372. Once the underlying Oracle issue is resolved, then Post can be restarted. The clue about Oracle error may also be found in the *alert.log.
-
Additional Information
Some of the common reasons may be bad datafile, state of the tablespace housing the datafile changed to "Read Only", database being shutdown during that period of Post error, etc. The following describes the Oracle error:
ORA-00372: file string 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