0

When we are connecting to Oracle via the listener and we reach our process limit, we're getting an ORA-12519: TNS:no appropriate service handler found. Looking at the the trace file for the event, it's showing an ORA-00020: maximum number of processes (%s) exceeded [where %s is our process limit of course].

What would cause Oracle to throw the misleading error message instead of the one for the real problem?

(I would have added a tag for ora-00020 but I don't have enough rep to add a new one.)

Mr. Muskrat
  • 22,772
  • 3
  • 20
  • 21
  • This is not off-topic. We're getting these errors through our app and I'd prefer if Oracle threw the ORA-00020 instead of a general purpose error that may or may not be caused by hitting the process limit. – Mr. Muskrat Jan 04 '12 at 17:18

1 Answers1

1

ORA-00020 is a database error. ORA-12519 is a TNS error.

Since you are using directly TNS (and database only indirectly), you directly get TNS error (and indirectly database error). As much as TNS is involved, there is no appropriate handler, and this is caused by the underlying database error.

kubanczyk
  • 5,184
  • 1
  • 41
  • 52
  • That makes sense but it seems like there should be some way for the database to notify the listener of the exact problem. – Mr. Muskrat Jan 04 '12 at 20:40