Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm seeing random TNS connection closed errors when connecting to one of our databases. It's not affecting all users. (Appears to be happening during spikes of user activity) Occasionally I'm also seeing ORA-12518: TNS:listener could not hand off client connection.

The connections are being made from .Net using the ODP driver. (Which generates a lot of connect/disconnect activity)

share|improve this question
add comment

2 Answers 2

up vote 2 down vote accepted

From here:

Your server is probably running out of memory and need to swap memory to disk.

One cause can be an Oracle process consuming too much memory. A possible workaround is to set following parameter in the listener.ora and restart the listener:

 DIRECT_HANDOFF_TTC_LISTENER=OFF

Should you be working with Multi threaded server connections, you might need to increase the value of large_pool_size.

You could examine the listener log file. By issuing the lsrnctl status command you can see log file. Check listener parameter file and see listener version.

See this blog post for other possible causes and additional help: ORA-12518: TNS:listener could not hand off client connection

share|improve this answer
add comment

Something crazy, but I used to see this issue when I was trying to do an OCI call to a 10g database using an older 9i driver. You might want to check your driver version to make sure it matches the database you're trying to connect to.

share|improve this answer
    
Did it happen all the time with a mismatched driver? Or just randomly? What I'm seeing is random. –  jeffspost Jun 16 '09 at 20:32
    
Totally random - took me 6 months to isolate it, we thought it was a problem with a router for a long time. –  Keith Jun 16 '09 at 20:34
    
I just checked and I'm running the 11g driver, so I doubt that's my problem, but thanks for the idea. I'd upvote it, but I don't have enough reputation yet. :-( –  jeffspost Jun 17 '09 at 0:55
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.