ORA-01137 data file string is still in the middle of going offline
This is an Oracle Database Server Message. This can be generated by the Oracle Database when running any Oracle program.
What is the cause of ORA-01137 from Oracle 8i ?
It was not possible to get the lock for a file that is offline when attempting to bring it online. The most likely cause is that the lock is still held by the instance that is took it offline.
How to deal with ORA-01137 from Oracle 8i ?
Wait for the other instance to release the lock on the file.
Contacting Oracle support services ?
Some messages recommend contacting Oracle Support Services to report a problem. Please go here for more information : Oracle Support.
Linked Error Messages
- ORA-01129 user's default or temporary tablespace does not exist
- ORA-01130 database file version string incompatible with ORACLE version string
- ORA-01131 DB_FILES system parameter value string exceeds limit of string
- ORA-01132 length of database file name ' string ' exceeds limit of string characters
- ORA-01133 length of log file name ' string ' exceeds limit of string characters
- ORA-01134 database mounted exclusive by another instance
- ORA-01135 file string accessed for DML/query is offline
- ORA-01136 specified size of file string ( string blocks) is less than original size of string blocks
- ORA-01138 database must either be open in this instance or not at all
- ORA-01139 RESETLOGS option only valid after an incomplete database recovery
- ORA-01140 cannot end online backup - all files are offline
- ORA-01141 error renaming data file string - new file ' string ' not found
- ORA-01142 cannot end online backup - none of the files are in backup
- ORA-01143 cannot disable media recovery - file string needs media recovery
- ORA-01144 File size ( string blocks) exceeds maximum of string blocks
- ORA-01145 offline immediate disallowed unless media recovery enabled