Home

April 11, 2015
Home
4.5 (90%) 4 votes

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 :

  1. Oracle error 12154 : TNS:could not resolve the connect identifier specified
  2. Oracle error 904 : string : invalid identifier
  3. Oracle error 12560 : TNS:protocol adapter error
  4. Oracle error 1403 : no data found
  5. Oracle error 942 : table or view does not exist
  6. Oracle error 1017 : invalid username/password; logon denied
  7. Oracle error 6502 : PL/SQL: numeric or value error string
  8. Oracle error 1031 : insufficient privileges
  9. Oracle error 1722 : invalid number
  10. Oracle error 1034 : ORACLE not available
  11. Oracle error 3113 : end-of-file on communication channel
  12. Oracle error 12899 : value too large for column string (actual: string, maximum: string)
  13. Oracle error 12505 : TNS:listener does not currently know of SID given in connect descriptor
  14. Oracle error 3114 : not connected to ORACLE
  15. Oracle error 2291 : integrity constraint ( string . string ) violated – parent key not found
  16. Oracle error 1917 : user or role ‘ string ‘ does not exist
  17. Oracle error 12170 : TNS:Connect timeout occurred
  18. Oracle error 1405 : fetched column value is NULL
  19. Oracle error 1012 : not logged on
  20. Oracle error 1422 : exact fetch returns more than requested number of rows
  21. Oracle error 12541 : TNS:no listener

History

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.

Year Version Release Comments
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”).

Leave a Reply

Your email address will not be published. Required fields are marked *