Oracle Database Errors or Warnings from Error ORA-01091 to ORA-01100



ORA-01091: failure during startup force
Cause: Unable to destroy the old SGA.
Action: Manually remove the old SGA and reissue the STARTUP command
ORA-01092: ORACLE instance terminated. Disconnection forced
Cause: The instance this process was connected to was terminated abnormally, probably via a shutdown abort. This process was forced to disconnect from the instance.
Action: Examine the alert log for more details. When the instance has been restarted, retry action.

ORA-01093: ALTER DATABASE CLOSE only permitted with no sessions connected
Cause: There is at least one more session other than the current one logged into the instance. ALTER DATABASE CLOSE is not permitted.
Action: Find the other sessions and log them out and resubmit the command
ORA-01095: DML statement processed zero rows
Cause: During a call to OTEX, an update, delete, or insert statement being executed processed zero rows. The execution of statements by OTEX was halted at this point.
Action: None
ORA-01096: program version (string) incompatible with instance (string)
Cause: A program is trying to connect to an instance using a different version of code than the database was started with. This is not allowed.
Action: Either relink the program with the same version as the database or restart the database using the old version of code.

ORA-01097: cannot shutdown while in a transaction – commit or rollback first
Cause: Obvious
Action: None
ORA-01099: cannot mount database in SHARED mode if started in single process mode
Cause: Obvious
Action: None
ORA-01100: database already mounted
Cause: A database is already mounted in this instance.
Action: None

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