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-03117two-task save area overflow
ORA-10842Event for OCI Tracing and Statistics Info
ORA-00824cannot set sga_target due to existing internal settings, see alert log for more information
ORA-27046file size is not a multiple of logical block size
ORA-08322scnmin: open/convert of bias lock failed
ORA-16229PDML child string string string for parent string string string cannot be skipped.
ORA-13851Tracing for client identifier string is already enabled
ORA-01849hour must be between 1 and 12
ORA-19161XP0004 - XQuery type mismatch: invalid argument type 'string' for function 'string'
ORA-08104this index object string is being online built or rebuilt
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-01610:recovery using the BACKUP CONTROLFILE option must be done
  • ORA-01144:File size (string blocks) exceeds maximum of string blocks
  • ORA-00600:internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  • ORA-00027:cannot kill current session
  • ORA-00824:cannot set sga_target due to existing internal settings, see alert log for more information
  • ORA-01735:invalid ALTER TABLE option
  • ORA-01730:invalid number of column names specified
  • ORA-12152:TNS:unable to send break message
  • ORA-02069:global_names parameter must be set to TRUE for this operation
  • ORA-21561:OID generation failed
  • ORA-19804:cannot reclaim string bytes disk space from string limit
  • ORA-21780:Maximum number of object durations exceeded.
  • ORA-01149:cannot shutdown - file string has online backup set
  • ORA-02082:a loopback database link must have a connection qualifier
  • ORA-12712:new character set must be a superset of old character set
  • ORA-01732:data manipulation operation not legal on this view
  • ORA-01440:column to be modified must be empty to decrease precision or scale
  • ORA-12853:insufficient memory for PX buffers: current stringK, max needed stringK
  • ORA-00926:missing VALUES keyword
  • ORA-01733:virtual column not allowed here
    		•
    Main Page      Contact Us