1

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.

OMG Ponies
  • 325,700
  • 82
  • 523
  • 502
George Mauer
  • 117,483
  • 131
  • 382
  • 612

3 Answers3

2

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

Eddie Awad
  • 3,669
  • 1
  • 19
  • 17
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.

Mark Roddy
  • 27,122
  • 19
  • 67
  • 71
1
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"
dacracot
  • 22,002
  • 26
  • 104
  • 152