Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TNS-12518: TNS:listener could not hand off client connection

User_YE9CXFeb 10 2015 — edited Feb 11 2015

Dear All,

I found the TNS-12518 oracle error from listener and alert log as shown below:

temp_super_20150211_listenerlog.jpg

temp_super_20150211_AlertLog.jpg

The following is the resource limit information:

temp_super_20150211_ResourceLimit.jpg

The following is the sga information:

temp_super_20150211_sga.jpg

I am not really sure what has happened and how to resolve this issue. I just restart the server and everything back to normal. But this problem will happen once for every 2 to 3 months time.

May i know how to troubleshoot and solve this error?

Thank you.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 11 2015
Added on Feb 10 2015
3 comments
492 views