List Of Oracle Error Messages
Contents |
MySQL MariaDB PostgreSQL SQLite MS Office Excel Access Word Web Development HTML CSS Color oracle error handling Picker Languages C Language More ASCII Table Linux UNIX ora error 12154 Java Clipart Techie Humor Advertisement Oracle Basics Oracle Advanced Alter Table Alter Tablespace Change
Oracle Sqlcode Values
Password Check Constraints Comments in SQL Create Schema Create Schema Statement Create Table Create Table As Create Tablespace Create User Data Types Declare Variables https://docs.oracle.com/cd/B28359_01/nav/lookup.htm?id=ERRMG Drop Table Drop Tablespace Drop User Error Messages Find Default Tablespace Find Users Find Users Logged In Find Version Information Functions Global Temporary Grant/Revoke Privileges Indexes Literals Local Temporary Primary Keys Procedures Roles Sequences Set Default Tablespace Synonyms System Tables Unique Constraints Views Oracle Cursors Oracle Exception https://www.techonthenet.com/oracle/errors/ Handling Oracle Foreign Keys Oracle Loops/Conditionals Oracle Transactions Oracle Triggers String/Char Functions Numeric/Math Functions Date/Time Functions Conversion Functions Analytic Functions Advanced Functions NEXT: TUTORIAL COMPLETE Oracle / PLSQL: Oracle Error Messages The following is a listing of Oracle Error Messages: 00001-00899 ORA-00001 ORA-00018 ORA-00020 ORA-00023 ORA-00028 ORA-00034 ORA-00051 ORA-00054 ORA-00057 ORA-00058 ORA-00060 ORA-00063 ORA-00068 ORA-00071 ORA-00078 ORA-00100 ORA-00107 ORA-00201 ORA-00257 ORA-00301 ORA-00304 ORA-00361 ORA-00401 00900-00999 ORA-00900 ORA-00902 ORA-00903 ORA-00904 ORA-00905 ORA-00906 ORA-00907 ORA-00908 ORA-00909 ORA-00910 ORA-00911 ORA-00913 ORA-00917 ORA-00918 ORA-00919 ORA-00920 ORA-00923 ORA-00924 ORA-00925 ORA-00926 ORA-00927 ORA-00928 ORA-00931 ORA-00932 ORA-00933 ORA-00934 ORA-00935 ORA-00936 ORA-00937 ORA-00938 ORA-00939 ORA-00942 ORA-00946 ORA-00947 ORA-00948 ORA-00955 ORA-00957 ORA-00960 ORA-00962 ORA-00971 ORA-00972 ORA-00975 ORA-00979 ORA-00980 ORA-00984 ORA-00985 ORA-00995 01000-01399 ORA-01000 ORA-01001 ORA-01002 ORA-01004 ORA-01005 ORA-01006 ORA-01007 ORA-01008 ORA-01012 ORA-01013 ORA-01014 ORA-01017 ORA-01023 ORA-01031 ORA-01033 ORA-01034 ORA-01035 ORA-01037 ORA-01039 ORA-01040 ORA-01042 ORA-01045 ORA-01052 ORA-01074 ORA-01089 ORA-01109
vid Type in oracle error text* *e.g.username (at oracle error codes least 3 characters long) ora amd aud dbv drg epc exp img imp kup lcd lfi lpx lrm lsx mod ncr nid nmp nnc nnf nnl nno npl nze o2f o2i o2u pcb pcc pcf pls qsm rman sql sql*loader tns vid Error type information..... Search tips..... Oracle Support Copyright © Ora-error 2004-2012, all rights reserved.
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up How to find oracle error codes that could result from a connection error? up vote 1 down vote favorite I would like to handle an OracleException thrown when my network/database connection is interrupted, where can I find out what error codes I might can receive? I guess since we are talking about a connection interruption these would be technically TNS errors such as ORA-12560 "TNS:protocol adapter error." But I have noticed a couple others depending on where exactly the connection is lost and would like to get a full list. oracle ora-12560 share|improve this question edited Apr 1 '11 at 16:47 OMG Ponies 199k37358417 asked Oct 1 '08 at 21:01 George Mauer 35.7k81246467 add a comment| 3 Answers 3 active oldest votes up vote 2 down vote accepted Take a look at Oracle Database Error Messages 11g Release 1 (11.1). And here are the search results for TNS errors. share|improve this answer answered Oct 1 '08 at 21:15 Eddie Awad 3,0531114 987 results! Wow, those guys at oracle sure love to make things easy –George Mauer Oct 1 '08 at 21:21 add a comment| up vote 1 down vote There's a full list here: http://ora-code.com But note that some of them, like "TNS:protocol adapter error", can actually mean many different things. share|improve this answer answered Oct 1 '08 at 21:06 Mark Roddy 10.9k95261 Ugh, That only makes my problem MORE difficult not less. –George Mauer Oct 1 '08 at 21:12 add a comment| up vote 1 down vote ORA-12154 TNS:could not resolve service name" ORA-12203 TNS:unable to connect to destination" ORA-12500 TNS:listener failed to start a dedicated server process