Oracle Database Error Messages 11g
Contents |
documentation) contain proprietary information; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent, and other
Oracle Common Errors And Solutions
intellectual and industrial property laws. Reverse engineering, disassembly, or decompilation of the oracle error sqlcode Programs, except to the extent required to obtain interoperability with other independently created software or as specified by oracle error handling law, is prohibited. The information contained in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in https://docs.oracle.com/cd/B28359_01/nav/lookup.htm?id=ERRMG writing. This document is not warranted to be error-free. Except as may be expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose. If the Programs are delivered to the United States Government or anyone licensing or using https://docs.oracle.com/cd/B28359_01/server.111/b28278/title.htm the Programs on behalf of the United States Government, the following notice is applicable: U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the Programs, including documentation and technical data, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement, and, to the extent applicable, the additional rights set forth in FAR 52.227-19, Commercial Computer Software--Restricted Rights (June 1987). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065. The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and we disclaim liability for any damages caused by such use of the Programs. Oracle, JD
Interpreting Gateway Error Messages Mapped Errors Gateway Error Codes SQL Tracing and the Gateway 5.1 Interpreting Gateway Error Messages The gateway https://docs.oracle.com/cd/B28359_01/gateways.111/b31046/errors.htm architecture consists of different components. Any component may detect and report an error condition while processing SQL statements that refer to one or more DRDA database tables. This http://stackoverflow.com/questions/159721/how-to-find-oracle-error-codes-that-could-result-from-a-connection-error means that errors can be complex, involving error codes and supporting data from multiple components. In all cases, however, the application ultimately receives a single error code or a oracle error return code. As most gateway messages exceed the 70character message area in the Oracle SQL Communications Area (SQLCA), the programmatic interfaces and Oracle Call Interfaces, that you use to access data through the gateway should use SQLGLM or OERHMS to view the entire text of messages. Refer to the programmer's guide to the Oracle precompilers for additional information oracle error codes about SQLGLM, and refer to the Oracle C++ Call Interface Programmer's Guide for additional information about OERHMS. Errors encountered when using the gateway can originate from many sources, as follows: Errors detected by the Oracle database Errors detected by the gateway Errors detected in the DRDA software, either on the client or server side Communication errors Errors detected by the server database 5.1.1 Errors Detected by the Oracle Database Errors detected by the Oracle database are reported back to the application or tool with the standard ORA type message. Refer to Oracle Database Error Messages for descriptions of these errors. For example, the following error occurs when an undefined database link name is specified: ORA-02019: connection description for remote database not found Errors in the ORA-9100 to ORA-9199 range are reserved for the generic gateway layer (components of the gateway that are not specific to DRDA). Messages in this range are documented in Oracle Database Error Messages. 5.1.2 Errors Detected by the Gateway Errors detected by the generic gat
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 199k37361417 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" ORA-12545 TNS:name lookup failure" ORA-12560 TNS:protocol adapter error" share|improve this answer answered Oct 1 '08 at 21:10 dacracot 11.2k1776135 thanks, thats a good start –George Mauer Oct 1 '08 at 21:22 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Googl