Welcome to the website that lists all the Oracle error messages from version 8i to version 11g. Each message listed in this site contains the message statement, an explanation of the probable causes of the message, and a recommended action. If the message is a warning or indicates that an error has occurred, then the message listing will suggest a corrective action.
This list was of course drawn from the official Oracle documentation and updated several times thanks to the users’ feedback. Each Oracle version holds its own error listing which can be easily accessed from the tabs above.
Use the search function on right side to find and solve your error.
Why this site ?
This site aims to share experiences on specific Oracle error messages, through the exchange of comments.
Of course, any assistance or participation will be greatly thanked.
Common Oracle error codes encountered
The following is a short list of the most common oracle errors :
- Oracle error 12154 : TNS:could not resolve the connect identifier specified
- Oracle error 904 : string : invalid identifier
- Oracle error 12560 : TNS:protocol adapter error
- Oracle error 1403 : no data found
- Oracle error 942 : table or view does not exist
- Oracle error 1017 : invalid username/password; logon denied
- Oracle error 6502 : PL/SQL: numeric or value error string
- Oracle error 1031 : insufficient privileges
- Oracle error 1722 : invalid number
- Oracle error 1034 : ORACLE not available
- Oracle error 3113 : end-of-file on communication channel
- Oracle error 12899 : value too large for column string (actual: string, maximum: string)
- Oracle error 12505 : TNS:listener does not currently know of SID given in connect descriptor
- Oracle error 3114 : not connected to ORACLE
- Oracle error 2291 : integrity constraint ( string . string ) violated – parent key not found
- Oracle error 1917 : user or role ‘ string ‘ does not exist
- Oracle error 12170 : TNS:Connect timeout occurred
- Oracle error 1405 : fetched column value is NULL
- Oracle error 1012 : not logged on
- Oracle error 1422 : exact fetch returns more than requested number of rows
- Oracle error 12541 : TNS:no listener
This website only deals with error messages from Oracle versions 8i to 11g (soon 12c) although there obviously have been previous versions before. Below is a brief preview of the history of Oracle versions.
|1977||–||Software Development Laboratories was established.|
|1979||Oracle 2||SDL changed its name, thus becoming Relational Software, Inc. (RSI) and introduced its Oracle V2 product as a
relational database. Version 2 did not support transactions but implemented basic
SQL features like query and join. As a matter of fact, there never was any version 1 for marketing purposes.
The very first version was indeed version 2 which only worked on Digital VAX/VMS systems.
|1983||Oracle 3||RSI became Oracle Corporation in order to better represent its flagship product.
Version 3 which had been thoroughly rewritten in C programming language was published.
It supported transactions with commit and rollback features. It was also from this
version that the Unix platform was supported.
|1984||Oracle 4||Oracle version 4 was released, allowing read consistency.|
|1985||Oracle 5||Oracle began to incorporate the client-server model along with the arrival of networks in the mid-1980s.
Oracle Version 5 thus allowed distributed queries.
|1988||Oracle 6||Oracle launched its ERP – Oracle Financials based on the Oracle relational database.
Oracle Version 6 supports PL/SQL, row-level locking and hot backups.
|1992||Oracle 7||7.1, 7.2, 7.3||Oracle version 7 supports integrity constraints, stored procedures and triggers.|
|1995||Oracle Express||Acquisition of a powerful multidimensional engine, marketed under the name Oracle Express.|
|1997||Oracle 8||8.0.3, 8.0.4, 8.0.5, 8.0.6||Version 8 introduced object-oriented programming and multimedia applications.|
|1999||Oracle 8i||8.1.5 (Release 1), 8.1.6 (Release 2), 8.1.7 (Release 3)||The 8i version was published in order to refine Oracle applications with the Internet
(i refers to the Internet). The database included a native JVM.
|2001||Oracle 9i||9.0.1 (Release 1), 9.2.0 (Release 2)||Oracle 9i added 400 new features and allowed the user to read and write XML documents.
From the 9i version, OLAP engine was integrated within Oracle: Oracle Express engine was now
referenced in the Oracle OLAP option. Multidimensional data was furthermore available from the SQL language.
|2003||Oracle 10g||10.1 (Release 1)||The 10g version which supported regular expressions was published.
g stands for “grid”: one of the 10g marketing advantages was indeed that it supported the “grid computing”.
|2005||Oracle 10g||10.2 (Release 2)||At the end of November, a completely free version was published : the “Oracle Database 10g
Express Edition”. Oracle Database 10.2.0.1 – also known as Oracle Database 10g Release 2 (10gR2) – appeared that same year .
|2007||Oracle 11g||11.1 (Release 1)||In July 2007, Oracle Database 11g was launched for Linux and Windows.|
|2009||Oracle 11g||11.2 (Release 2)||In September 2009, Oracle Database 11g Release 21 appeared.|
|2013||Oracle 12c||12.1 (Release 1)||On July 1st, 2013, Oracle came up with its latest version : Oracle Database Release 12c2 (c stands for “cloud”).|