Oracle is the biggest and most common database provider in the world.  It can run on all industry-standard platforms like Windows, Unix, Linux, Aix etc. We tried to describe oracle related errors and their solutions. You can find thousands of Oracle errors and their descriptions here.

Query Oracle Error Codes
Type Oracle error code below and then press the Query button.
Last Queried Errors
Error CodeDescription
ORA-01151use media recovery to recover block, restore backup if needed
ORA-00081address range [string, string) is not readable
ORA-00062DML full-table lock cannot be acquired; DML_LOCKS is 0
ORA-01050cannot acquire space to open context area
ORA-00053maximum number of enqueues exceeded
ORA-12800system appears too busy for parallel query execution
ORA-00031session marked for kill
ORA-00018maximum number of sessions exceeded
ORA-16230committing transaction string string string
ORA-00097use of Oracle SQL feature not in SQL92 string Level
Articles about Oracle
How to determine invalid objects and how to recompile them ? 
How to import data into oracle from Excel/ text files ? 
Oracle and Auto increment fields & Sequences 
Oracle Health Check & Monitoring
Oracle RAC and high available clusters
Oracle Cluster File System for Linux (OCFS)
Distributed Database Replication


 Oracle Errors
Oracle Errors and their explanations
Oracle Invalid Objects
Oracle Softwares & Tools

 Frequently asked oracle errors
  • ORA-19502:write error on file "string", blockno string (blocksize=string)
  • ORA-28001:the password has expired
  • ORA-24033:no recipients for message
  • ORA-21561:OID generation failed
  • ORA-12152:TNS:unable to send break message
  • ORA-01144:File size (string blocks) exceeds maximum of string blocks
  • ORA-01086:savepoint 'string' never established
  • ORA-12712:new character set must be a superset of old character set
  • ORA-00824:cannot set sga_target due to existing internal settings, see alert log for more information
  • ORA-01610:recovery using the BACKUP CONTROLFILE option must be done
  • ORA-19804:cannot reclaim string bytes disk space from string limit
  • ORA-16224:Database Guard is enabled
  • ORA-12853:insufficient memory for PX buffers: current stringK, max needed stringK
  • ORA-02069:global_names parameter must be set to TRUE for this operation
  • ORA-00600:internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  • ORA-00027:cannot kill current session
  • ORA-21780:Maximum number of object durations exceeded.
  • ORA-01732:data manipulation operation not legal on this view
  • ORA-01149:cannot shutdown - file string has online backup set
  • ORA-01190:control file or data file string is from before the last RESETLOGS
    		•
    Main Page      Contact Us