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-01735invalid ALTER TABLE option
ORA-01732data manipulation operation not legal on this view
ORA-01849hour must be between 1 and 12
ORA-13851Tracing for client identifier string is already enabled
ORA-14168only one subpartition may be modified
ORA-01730invalid number of column names specified
ORA-12432LBAC error: string
ORA-12152TNS:unable to send break message
ORA-00027cannot kill current session
ORA-01741illegal zero-length identifier
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-12152:TNS:unable to send break message
  • ORA-21561:OID generation failed
  • 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-19804:cannot reclaim string bytes disk space from string limit
  • ORA-01610:recovery using the BACKUP CONTROLFILE option must be done
  • ORA-16224:Database Guard is enabled
  • ORA-00600:internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  • 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-01732:data manipulation operation not legal on this view
  • ORA-21780:Maximum number of object durations exceeded.
  • 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