如何查找可能由连接错误导致的 oracle 错误代码？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/159721/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to find oracle error codes that could result from a connection error?
提问by George Mauer
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?
我想处理在我的网络/数据库连接中断时抛出的 OracleException，我在哪里可以找到我可能会收到哪些错误代码？
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.
我想既然我们在谈论连接中断，那么这些在技术上应该是 TNS 错误，例如 ORA-12560“TNS：协议适配器错误”。但我注意到其他几个取决于连接丢失的确切位置，并希望获得完整列表。
回答by Eddie Awad
Take a look at Oracle Database Error Messages 11g Release 1 (11.1). And here are the search results for TNS errors.
回答by Mark Roddy
There's a full list here: http://ora-code.com
这里有一个完整的列表：http: //ora-code.com
But note that some of them, like "TNS:protocol adapter error", can actually mean many different things.
但请注意，其中一些，例如“TNS:protocol adapter error”，实际上可能意味着许多不同的东西。
回答by dacracot
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"
