Oracle Database Errors or Warnings from Error ORA-01640 to ORA-01650



ORA-01640: cannot make tablespace read-only with changes by in-doubt transactions
Cause: An attempt was made to alter a tablespace read-only while there were changes in the tablespace made by in-doubt distributed transactions. The in-doubt transactions must commit or rollback to ensure that there is no undo for a tablespace before it can be made read-only.
Action: Any in-doubt transactions that made changes to the tablespace must be resolved.
ORA-01641: tablespace ‘string’ is not online – cannot add data file
Cause: Attempting to add a datafile to a tablespace that has been set to read-only or offline.
Action: Make the tablespace online and read write then add the datafile.
ORA-01642: begin backup not needed for read-only tablespace ‘string’
Cause: Attempting to begin or end a backup for a tablespace that has been set to read-only.
Action: Take the backup without any begin or end commands. The files are not being modified so the backup will be consistent.

ORA-01643: system tablespace can not be made read-only
Cause: Attempting to set the system tablespace to read-only. The system tablespace must remain read write for database operation.
Action: Leave system tablespace read write.
ORA-01644: tablespace ‘string’ is already read-only
Cause: Attempting to make tablespace read-only that is already read-only.
Action: Leave tablespace read-only, or make read write then make read-only again.
ORA-01645: previous attempt to make read write is half complete
Cause: A failure while making the tablespace read write left it read only, but the checkpoint was advanced. The tablespace will not be useable after a resetlogs if its files are offline.
Action: Repeat the command to make the tablespace read write.

ORA-01646: tablespace ‘string’ is not read-only – cannot make read write
Cause: Attempting to make a tablespace read write that is not read-only. It may be either online or offline.
Action: Leave tablespace read write.
ORA-01647: tablespace ‘string’ is read-only, cannot allocate space in it
Cause: Tried to allocate space in a read-only tablespace
Action: Create the object in another tablespace
ORA-01648: log string is the current log of disabled instance string (thread string)
Cause: An attempt to enable the thread failed after it was half completed. This log was left as the current log even though the thread is still disabled. Since a log switch cannot be done until the thread is enabled, the log can not be cleared or archived.
Action: Complete the thread enable by issuing the enable command again.
ORA-01649: operation not allowed with a backup control file
Cause: An attempt is being made to perform a command that does not make sense when the control file is a restored backup.
Action: Wait until after the database has been opened and try again.
ORA-01650: unable to extend rollback segment string by string in tablespace string
Cause: Failed to allocate an extent of the required number of blocks for a rollback segment in the tablespace.
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

Above are list of Oracle Database Errors or Warnings from Error ORA-01640 to ORA-01650 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 *