Oracle Database Down Error
Contents |
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 oracle sql error codes list about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users
Oracle Error Codes List With Description
Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping oracle database errors and solutions 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 oracle error codes and solution 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 199k37361417
Oracle 11g Error Codes Pdf
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| Did you find this question interesting? Try our newsletter Sign up for our newsletter and get our top new questions delivered to your inbox (see an example). Subscribed! Success! Please click the link in the confirmation email to activate your subscription. 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" ORA-12545 TNS:name lookup failure" ORA-12560 TNS:protocol adapter error" share|improve this answer answered Oct 1 '08 at 21:10 dacraco
Operating System-Specific Messages Accuracy of Messages Message Format Recognizing Variable Text in Messages Message Stacks Contacting Oracle Support Services Oracle Exception Messages Trace Files The Alert oracle common errors and solutions File 2 ORA-00000 to ORA-00832 3 ORA-00910 to ORA-01497 4 ORA-01500 oracle error codes table to ORA-02098 5 ORA-02140 to ORA-04099 6 ORA-04930 to ORA-07499 7 ORA-09870 to ORA-12100 8 ORA-07500
List Of All Oracle Error Codes With Description
to ORA-09859 9 ORA-12150 to ORA-12236 10 ORA-12315 to ORA-12354 11 ORA-12400 to ORA-12497 12 ORA-12500 to ORA-12699 13 ORA-12700 to ORA-19380 14 ORA-19400 to ORA-24276 15 http://stackoverflow.com/questions/159721/how-to-find-oracle-error-codes-that-could-result-from-a-connection-error ORA-24280 to ORA-28674 16 ORA-29250 to ORA-32775 17 ORA-32800 to ORA-32848 18 ORA-33000 to ORA-37999 19 ORA-38029 to ORA-39962 20 ORA-40001 to ORA-40322 21 EXP-00000 to EXP-00107 22 IMP-00000 to IMP-00401 23 SQL*Loader-00100 to SQL*Loader-03120 24 KUP-00550 to KUP-11012 25 UDE-00001 to UDE-00053 26 UDI-00001 to UDI-00053 27 DBV-00200 to DBV-00200 28 NID-00001 to NID-00604 https://docs.oracle.com/cd/B19306_01/server.102/b14219/toc.htm 29 DGM-16900 to DGM-17007 30 LCD-00100 to LCD-00219 31 QSM-00501 to QSM-03120 32 OCI-00601 to OCI-31199 33 RMAN-00550 to RMAN-20507 34 LRM-00100 to LRM-00123 35 LFI-00002 to LFI-01523 36 PLS-00049 to PLS-01913 37 PLW-05000 to PLW-07204 38 AMD-00100 to AMD-00160 39 CLSR-00001 to CLSR-06507 40 CLSS-00001 to CLSS-03202 41 PROC-00001 to PROC-00106 42 PROT-00001 to PROT-00807 43 TNS-00000 to TNS-12699 44 NNC-00001 to NNC-00501 45 NNO-00050 to NNO-00854 46 NNL-00001 to NNL-01078 47 NPL-00100 to NPL-00420 48 NNF-00001 to NNF-04009 49 NMP-00001 to NMP-00011 50 NCR-00001 to NCR-04028 51 NZE-28750 to NZE-29249 52 O2F-00301 to O2F-00341 53 O2I-00101 to O2I-00133 54 O2U-00200 to O2U-00212 55 PCB-00001 to PCB-00903 56 PCC-00001 to PCC-01515 57 PCC-02010 to PCC-02451 58 SQL-01075 to SQL-02157 59 AUD-00611 to AUD-00809 60 IMG-00001 to IMG-02014 61 VID-00611 to VID-00721 62 DRG-10000 to DRG-52210 63 LPX-00000 to LPX-00773 64 LSX-00001 to LSX-00344 Index Scripting on this page enhances content navigation, but does not change the content in any way.
TNS:received bad packet type from network layer Cause: Internal error. Action: Not normally visible to the user. For further details, turn on tracing and reexecute the operation. https://docs.oracle.com/cd/B19306_01/server.102/b14219/net12150.htm If error persists, contact Worldwide Customer Support. ORA-12152: TNS:unable to send break message Cause: Unable to send break message. Connection probably disconnected. Action: Reestablish connection. If the error is persistent, turn on tracing and reexecute the operation. ORA-12153: TNS:not connected Cause: Not currently connected to a remote host. Action: Reestablish connection. ORA-12154: TNS:could not resolve the connect identifier specified Cause: error codes A connection to a database or other service was requested using a connect identifier, and the connect identifier specified could not be resolved into a connect descriptor using one of the naming methods configured. For example, if the type of connect identifier used was a net service name then the net service name could not be found in a naming oracle error codes method repository, or the repository could not be located or reached. Action: - If you are using local naming (TNSNAMES.ORA file): - Make sure that "TNSNAMES" is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA) - Verify that a TNSNAMES.ORA file exists and is in the proper directory and is accessible. - Check that the net service name used as the connect identifier exists in the TNSNAMES.ORA file. - Make sure there are no syntax errors anywhere in the TNSNAMES.ORA file. Look for unmatched parentheses or stray characters. Errors in a TNSNAMES.ORA file may make it unusable. - If you are using directory naming: - Verify that "LDAP" is listed as one of the values of the NAMES.DIRETORY_PATH parameter in the Oracle Net profile (SQLNET.ORA). - Verify that the LDAP directory server is up and that it is accessible. - Verify that the net service name or database name used as the connect identifier is configured in the directory. - Verify that the default context being used is correct by speci