Oracle Error Messages – Cause and Solutions

This page contains a list of all the Oracle error messages that I have written about, and the links to their posts.

On each post, you will find information about the cause of the error, as well as one or many solutions (depending on the error).

Some posts also explain how to prevent the error from happening in the future.


Oracle Error Messages

ORA-00001ORA-00001 unique constraint violated
ORA-00609ORA-00609: could not attach to incoming connection
ORA-00904ORA-00904 invalid identifier
ORA-00907ORA-00907: missing right parenthesis
ORA-00911ORA-00911 invalid character
ORA-00933ORA-00933 SQL command not properly ended
ORA-00936ORA-00936: missing expression
ORA-00937ORA-00937: not a single-group group function
ORA-00942ORA-00942 table or view does not exist
ORA-00972ORA-00972 identifier is too long
ORA-00979ORA-00979 not a group by expression
ORA-01017ORA-01017 invalid username/password; logon denied
ORA-01031ORA-01031 insufficient privileges
ORA-01400ORA-01400: cannot insert null into (string)
ORA-01722ORA-01722 invalid number
ORA-06502ORA-06502 PLSQL numeric or value error
ORA-06512ORA-06512 at line
ORA-06550ORA-06550 line N column N
ORA-12154ORA-12154 TNS Connection Identifier
ORA-12514ORA-12514: TNS:listener does not currently know or service requested in connect descriptor
ORA-609ORA-609: opiodr aborting process unknown ospid


[text-blocks id=”5975″]