ORA-12518 TNS listener could not hand off client connection

April 24th, 2009 Posted in Oracle How-To, Oracle Tip

Have you ever seen the error “ORA-12518 TNS listener could not hand off client connection”? I did yesterday and it was a pretty simple fix.

It turns out the processes for a particular instance was set too low. You can see how many processes are running via this command:

select count(*) from v$process;

If you want to see what your threshold is set to run:

show parameter processes;

To change the number of processe run this command:

ALTER SYSTEM SET processes=250 SCOPE=spfile;

Unfortunately this requires you to restart the database for the new value takes affect. To see the new value in the spfile you can run this command:

SELECT value FROM v$spparameter WHERE name='processes';
Tags: , , ,
This entry was posted on Friday, April 24th, 2009 at 7:21 pm and is filed under Oracle How-To, Oracle Tip. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “ORA-12518 TNS listener could not hand off client connection”

  1. whathappen Says:

    August 20th, 2009 at 4:37 pm

    this problem almost root cause of 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

    referrence : http://blogitknowledge.u-indy.com/database-services/oracle-troubleshoot/oracle-troubleshoot-ora-12518-tnslistener-could-not-hand-off-client-connection/



Leave a Reply