Wednesday, July 14, 2010

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


When you hit this error "ORA-12518: TNS: listener could not hand off client connection" ,Check the alert log.In my case the reason was , ORA 00020 – Maximum number of processes exceeded.When I queried the number of sessions, I can see that the number was more than 150, which I specified in my init.ora file.This prevents further connections to this service, resulting in ORA-12518: TNS: listener could not hand off client connection.

If my database runs in windows do this.

Work around :Restart the Oracle Service in windows

The reason for this error could be limited server resources or configuration. Try to check these

1. Database server memory were enough for new connection
2. Database connection parameters such as
       2.1 dedicated server, pls checked processes parameter or query from v$resource_limit where resource_name='processes'; checked max_utilization must less than Limit_value or
       2.2 shared server, pls verify large_pool_size or check dispatcher were enough for all connection.

3. You may check related log such as listener.log, alert log, trace file, etc



0 comments:

Post a Comment

 

ORA-BLOG. Copyright 2008 All Rights Reserved Revolution Two Church theme by Brian Gardner Converted into Blogger Template by Bloganol dot com