How to find oracle error codes that could result from a connection error?

Question

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.

Answer 1

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.

Answer 2

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"

Answer 3

Take a look at Oracle Database Error Messages 11g Release 1 (11.1). And here are the search results for TNS errors.