Oracle Database Errors or Warnings from Error ORA-01135 to ORA-01140



ORA-01135: file string accessed for DML/query is offline
Cause: Attempted to access a data file that is offline
Action: Bring the data file back online
ORA-01136: specified size of file string (string blocks) is less than original size of string blocks
Cause: A file size was specified in the AS clause of ALTER DATABASE CREATE DATAFILE, and the size was smaller the the size needed
Action: Create the file with a larger size.

ORA-01137: data file string is still in the middle of going offline
Cause: 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.
Action: Wait a bit and try to online the file again.
ORA-01138: database must either be open in this instance or not at all
Cause: The requested operation can not be done when the database is mounted but not open in this instance, and another instance has the database open.
Action: Execute the operation in an open instance, open the datbase in this instance, or close the database in the other instances.

ORA-01139: RESETLOGS option only valid after an incomplete database recovery
Cause: The RESETLOGS option was given in ALTER DATABASE OPEN, but there has been no incomplete recovery session.
Action: Retry the ALTER DATABASE OPEN without specifying RESETLOGS
ORA-01140: cannot end online backup – all files are offline or readonly
Cause: All the files were found to be offline or readonly when attempting to end an online backup.
Action: None. Online backup does not need to be ended for this tablespace.

Above are list of Oracle Database Errors or Warnings from Error ORA-01135 to ORA-01140 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database.  Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *