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-19161XP0004 - XQuery type mismatch: invalid argument type 'string' for function 'string'
ORA-02356The database is out of space. The load cannot continue
ORA-00090failed to allocate memory for cluster database ORADEBUG command
ORA-01752cannot delete from view without exactly one key-preserved table
ORA-00017session requested to set trace event
ORA-12719operation requires database is in RESTRICTED mode
ORA-01158database string already mounted
ORA-01096program version (string) incompatible with instance (string)
ORA-03254unable to execute the sql in read only database
ORA-00128this command requires a dispatcher name
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-01144:File size (string blocks) exceeds maximum of string blocks
  • ORA-12712:new character set must be a superset of old character set
  • ORA-01086:savepoint 'string' never established
  • ORA-00824:cannot set sga_target due to existing internal settings, see alert log for more information
  • ORA-12152:TNS:unable to send break message
  • ORA-19804:cannot reclaim string bytes disk space from string limit
  • ORA-01610:recovery using the BACKUP CONTROLFILE option must be done
  • 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-00027:cannot kill current session
  • ORA-16224:Database Guard is enabled
  • ORA-21780:Maximum number of object durations exceeded.
  • ORA-01732:data manipulation operation not legal on this view
  • ORA-00600:internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  • 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